set_item_property('<block.item>',PROMPT_TEXT,'<new_prompt>');

set_item_property('<block.item>',PROMPT_EDGE_OFFSET,'<new_offset>');

Describing tblpackagetext....
NAME                            Null?     Type
------------------------------- --------- -----
PACKAGEID                       NOT NULL  NUMBER(11,0)
LANGUAGEID                      NOT NULL  NUMBER(2,0)
NAME                                      VARCHAR2(80)
DESCRIPTION                               VARCHAR2(4000)
COMMENTS                                  VARCHAR2(4000)
QACOMMENTS                                VARCHAR2(4000)
GUIDELINE                                 VARCHAR2(20)
EDITED                          NOT NULL  NUMBER(1,0)
TIMESTAMP                       NOT NULL  DATE

select packageid, Name, NameArabic
                  from (select max(packageid) AS packageid,
                  max(case when languageid = 1 then name end) Name,
                  max(case when languageid = 2 then name end) NameArabic 
                   from tblpackagetext group by packageid)


 sql>select * from tblpackagetext;

PACKAGEID LANGUAGEID NAME                 DESCRIPTION
--------- ---------- -------------------- -------------------- 
       1          1 English Name         English Description        
       1          2 Arabic  Name         Arabic  Description   
       2          1 Another English      More English

sql>select packageid,
  2         max(decode(languageid, 1, name, null)) name,
  3         max(decode(languageid, 2, name, null)) nameArabic,
  4         max(decode(languageid, 1, description, null)) description,
  5         max(decode(languageid, 2, description, null)) descriptionArabic
  6    from tblpackagetext
  7   group by packageid;

PACKAGEID NAME                 NAMEARABIC
--------- -------------------- ------------------------------
DESCRIPTION                   DESCRIPTIONARABIC
-------------------- ------------------------------
        1 English Name         Arabic Name
English Description  Arabic   Description
        2 Another EnglishMore English