DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on PA_VARCHAR2_240_TBL_TYPE

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

1475: l_bis_note number(10) := 0;
1476: l_pjp_note number(10) := 0;
1477: l_sp_note number(10) := 0;
1478: l_separator VARCHAR2(240) := ' ';
1479: prof_opt_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1480: prof_val_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1481: -- For BIS Report
1482: l_bis_pri_curr_code VARCHAR2(240);
1483: l_bis_pri_rate_type VARCHAR2(240);

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

1476: l_pjp_note number(10) := 0;
1477: l_sp_note number(10) := 0;
1478: l_separator VARCHAR2(240) := ' ';
1479: prof_opt_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1480: prof_val_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1481: -- For BIS Report
1482: l_bis_pri_curr_code VARCHAR2(240);
1483: l_bis_pri_rate_type VARCHAR2(240);
1484: l_bis_sec_curr_code VARCHAR2(240);

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

1502: l_planamt_alloc_method VARCHAR2 (30);
1503: l_curr_rep_pa_period VARCHAR2(30);
1504: l_curr_rep_gl_period VARCHAR2(30);
1505: l_curr_rep_ent_period VARCHAR2(30);
1506: l_sp_curr_rep_org_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1507: l_sp_curr_rep_pa_period_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1508: l_sp_curr_rep_gl_period_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1509: l_sp_curr_rep_ent_period_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1510: l_p_glb_curr_flag VARCHAR2(100);

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

1563: raise;
1564: END;
1565: -- For Bis Setup Options Prompts or captions
1566: BEGIN
1567: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1568: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1569:
1570: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1571: INTO prof_opt_tbl,prof_val_tbl

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

1564: END;
1565: -- For Bis Setup Options Prompts or captions
1566: BEGIN
1567: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1568: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1569:
1570: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1571: INTO prof_opt_tbl,prof_val_tbl
1572: FROM pji_lookups

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

1733: END;
1734:
1735: -- For PJP setup options prompt or caption
1736: BEGIN
1737: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1738: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1739:
1740: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1741: INTO prof_opt_tbl,prof_val_tbl

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

1734:
1735: -- For PJP setup options prompt or caption
1736: BEGIN
1737: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1738: prof_opt_tbl := SYSTEM.pa_varchar2_240_tbl_type();
1739:
1740: SELECT lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
1741: INTO prof_opt_tbl,prof_val_tbl
1742: FROM pji_lookups