eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_UTILS dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 1596: prof_opt_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

1592: l_bis_note number(10) := 0;
1593: l_pjp_note number(10) := 0;
1594: l_sp_note number(10) := 0;
1595: l_separator VARCHAR2(240) := ' ';
1596: prof_opt_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1597: prof_val_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1598: -- For BIS Report
1599: l_bis_pri_curr_code VARCHAR2(240);
1600: l_bis_pri_rate_type VARCHAR2(240);

Line 1597: prof_val_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

1593: l_pjp_note number(10) := 0;
1594: l_sp_note number(10) := 0;
1595: l_separator VARCHAR2(240) := ' ';
1596: prof_opt_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1597: prof_val_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1598: -- For BIS Report
1599: l_bis_pri_curr_code VARCHAR2(240);
1600: l_bis_pri_rate_type VARCHAR2(240);
1601: l_bis_sec_curr_code VARCHAR2(240);

Line 1623: l_sp_curr_rep_org_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

1619: l_planamt_alloc_method VARCHAR2 (30);
1620: l_curr_rep_pa_period VARCHAR2(30);
1621: l_curr_rep_gl_period VARCHAR2(30);
1622: l_curr_rep_ent_period VARCHAR2(30);
1623: l_sp_curr_rep_org_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1624: l_sp_curr_rep_pa_period_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1625: l_sp_curr_rep_gl_period_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1626: l_sp_curr_rep_ent_period_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1627: l_p_glb_curr_flag VARCHAR2(100);

Line 1706: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();

1702: raise;
1703: END;
1704: -- For Bis Setup Options Prompts or captions
1705: BEGIN
1706: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1707: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1708:
1709: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1710: INTO prof_opt_tbl,prof_val_tbl

Line 1707: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();

1703: END;
1704: -- For Bis Setup Options Prompts or captions
1705: BEGIN
1706: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1707: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1708:
1709: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1710: INTO prof_opt_tbl,prof_val_tbl
1711: FROM pji_lookups

Line 1756: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();

1752: END;
1753: /*For new profile options added (PJI: Default Reporting Calendar Type, PJI: Default Reporting Currency Type and PJI: Extraction Batch Size )*/
1754: /*Following code is added for bug 6802867 */
1755: BEGIN
1756: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1757: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1758:
1759: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1760: INTO prof_opt_tbl,prof_val_tbl

Line 1757: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();

1753: /*For new profile options added (PJI: Default Reporting Calendar Type, PJI: Default Reporting Currency Type and PJI: Extraction Batch Size )*/
1754: /*Following code is added for bug 6802867 */
1755: BEGIN
1756: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1757: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1758:
1759: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1760: INTO prof_opt_tbl,prof_val_tbl
1761: FROM pji_lookups

Line 1906: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();

1902: END;
1903:
1904: -- For PJP setup options prompt or caption
1905: BEGIN
1906: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1907: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1908:
1909: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1910: INTO prof_opt_tbl,prof_val_tbl

Line 1907: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();

1903:
1904: -- For PJP setup options prompt or caption
1905: BEGIN
1906: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1907: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1908:
1909: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1910: INTO prof_opt_tbl,prof_val_tbl
1911: FROM pji_lookups