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.PO_DOC_NUMBERING_PKG dependencies on DBMS_SQL

Line 498: l_attr_grp_ids Dbms_Sql.number_table;

494: l_query VARCHAR2(4000);
495: l_col_name VARCHAR2(20);
496: l_attrb_grp_id NUMBER;
497:
498: l_attr_grp_ids Dbms_Sql.number_table;
499: l_where_cls VARCHAR2(100):='';
500:
501: min_code NUMBER;
502: max_code NUMBER;

Line 521: l_ranges_array Dbms_Sql.varchar2_table;

517: SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
518: and enabled_flag = 'Y'
519: and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code);
520:
521: l_ranges_array Dbms_Sql.varchar2_table;
522: l_serial_num_fetched BOOLEAN := FALSE;
523:
524: BEGIN
525: -- If document number is already generated, just return and don't redefault

Line 818: l_attr_grp_ids Dbms_Sql.number_table;

814: l_query VARCHAR2(4000);
815: l_col_name VARCHAR2(20);
816: l_attrb_grp_id NUMBER;
817:
818: l_attr_grp_ids Dbms_Sql.number_table;
819: l_where_cls VARCHAR2(100):='';
820:
821: CURSOR C IS
822: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 1012: l_attr_grp_ids Dbms_Sql.number_table;

1008: l_query VARCHAR2(4000);
1009: l_col_name VARCHAR2(20);
1010: l_attrb_grp_id NUMBER;
1011:
1012: l_attr_grp_ids Dbms_Sql.number_table;
1013: l_where_cls VARCHAR2(100):='';
1014:
1015: CURSOR C IS
1016: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 1306: l_attr_grp_ids Dbms_Sql.number_table;

1302: l_query VARCHAR2(4000);
1303: l_col_name VARCHAR2(20);
1304: l_attrb_grp_id NUMBER;
1305:
1306: l_attr_grp_ids Dbms_Sql.number_table;
1307: l_where_cls VARCHAR2(100):='';
1308:
1309: CURSOR C IS
1310: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 1480: l_attr_grp_ids Dbms_Sql.number_table;

1476: l_query VARCHAR2(4000);
1477: l_col_name VARCHAR2(20);
1478: l_attrb_grp_id NUMBER;
1479:
1480: l_attr_grp_ids Dbms_Sql.number_table;
1481: l_where_cls VARCHAR2(100):='';
1482:
1483: CURSOR C IS
1484: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 1774: l_attr_grp_ids Dbms_Sql.number_table;

1770: l_query VARCHAR2(4000);
1771: l_col_name VARCHAR2(20);
1772: l_attrb_grp_id NUMBER;
1773:
1774: l_attr_grp_ids Dbms_Sql.number_table;
1775: l_where_cls VARCHAR2(100):='';
1776:
1777: CURSOR C IS
1778: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 1936: l_attr_grp_ids Dbms_Sql.number_table;

1932: )
1933: IS
1934:
1935: l_query VARCHAR2(4000);
1936: l_attr_grp_ids Dbms_Sql.number_table;
1937: l_where_cls VARCHAR2(100):='';
1938: l_num NUMBER;
1939:
1940: CURSOR C IS

Line 2072: l_attr_grp_ids Dbms_Sql.number_table;

2068: )
2069: IS
2070:
2071: l_query VARCHAR2(4000);
2072: l_attr_grp_ids Dbms_Sql.number_table;
2073: l_where_cls VARCHAR2(100):='';
2074: l_num NUMBER;
2075:
2076: CURSOR C IS

Line 2216: l_attr_grp_ids Dbms_Sql.number_table;

2212: l_query VARCHAR2(4000);
2213: l_col_name VARCHAR2(20);
2214: l_attrb_grp_id NUMBER;
2215:
2216: l_attr_grp_ids Dbms_Sql.number_table;
2217: l_where_cls VARCHAR2(100):='';
2218:
2219: CURSOR C IS
2220: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 2237: l_ranges_array Dbms_Sql.varchar2_table;

2233: SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
2234: and enabled_flag = 'Y'
2235: and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code);
2236:
2237: l_ranges_array Dbms_Sql.varchar2_table;
2238: l_serial_num_fetched BOOLEAN := FALSE;
2239:
2240: min_code NUMBER;
2241: max_code NUMBER;

Line 2759: l_attr_grp_ids Dbms_Sql.number_table;

2755: l_query VARCHAR2(4000);
2756: l_col_name VARCHAR2(20);
2757: l_attrb_grp_id NUMBER;
2758:
2759: l_attr_grp_ids Dbms_Sql.number_table;
2760: --l_where_cls VARCHAR2(100):='';
2761: l_cur_attr_group_id NUMBER ;
2762:
2763: /*CURSOR C IS

Line 2781: l_ranges_array Dbms_Sql.varchar2_table;

2777: SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
2778: and enabled_flag = 'Y'
2779: and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code);
2780:
2781: l_ranges_array Dbms_Sql.varchar2_table;
2782: l_serial_num_fetched BOOLEAN := FALSE;
2783:
2784: min_code NUMBER;
2785: max_code NUMBER;

Line 3347: l_attr_grp_ids Dbms_Sql.number_table;

3343: l_query VARCHAR2(4000);
3344: l_col_name VARCHAR2(20);
3345: l_attrb_grp_id NUMBER;
3346:
3347: l_attr_grp_ids Dbms_Sql.number_table;
3348: l_where_cls VARCHAR2(100):='';
3349:
3350: CURSOR C IS
3351: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 3368: l_ranges_array Dbms_Sql.varchar2_table;

3364: SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
3365: and enabled_flag = 'Y'
3366: and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code);
3367:
3368: l_ranges_array Dbms_Sql.varchar2_table;
3369: l_serial_num_fetched BOOLEAN := FALSE;
3370:
3371: min_code NUMBER;
3372: max_code NUMBER;

Line 3824: l_attr_grp_ids Dbms_Sql.number_table;

3820: l_query VARCHAR2(4000);
3821: l_col_name VARCHAR2(20);
3822: l_attrb_grp_id NUMBER;
3823: l_num NUMBER;
3824: l_attr_grp_ids Dbms_Sql.number_table;
3825: l_where_cls VARCHAR2(100):='';
3826:
3827: CURSOR C IS
3828: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 4095: l_attr_grp_ids Dbms_Sql.number_table;

4091: l_query VARCHAR2(4000);
4092: l_col_name VARCHAR2(20);
4093: l_attrb_grp_id NUMBER;
4094: l_num NUMBER;
4095: l_attr_grp_ids Dbms_Sql.number_table;
4096: l_where_cls VARCHAR2(100):='';
4097:
4098: CURSOR C IS
4099: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID

Line 4288: l_attr_grp_ids Dbms_Sql.number_table;

4284: )
4285: IS
4286:
4287: l_query VARCHAR2(4000);
4288: l_attr_grp_ids Dbms_Sql.number_table;
4289: l_where_cls VARCHAR2(100):='';
4290: l_num NUMBER;
4291: l_lookup_const VARCHAR2(50);
4292:

Line 4630: l_attr_grp_ids Dbms_Sql.number_table;

4626: )
4627: IS
4628:
4629: l_query VARCHAR2(4000);
4630: l_attr_grp_ids Dbms_Sql.number_table;
4631: l_where_cls VARCHAR2(100):='';
4632: l_num NUMBER;
4633: l_lookup_const VARCHAR2(50);
4634:

Line 4867: l_attr_grp_ids Dbms_Sql.number_table;

4863: )
4864: IS
4865:
4866: l_query VARCHAR2(4000);
4867: l_attr_grp_ids Dbms_Sql.number_table;
4868: l_where_cls VARCHAR2(100):='';
4869: l_num NUMBER;
4870: l_uca_special_character VARCHAR2(1); -- UCA Changes - CLM R4
4871: l_isUCAEnabled VARCHAR2(1);

Line 5468: l_attr_grp_ids Dbms_Sql.number_table;

5464: d_api_name CONSTANT VARCHAR2(30) := 'awd_par_XD';
5465: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
5466: d_progress NUMBER := 0;
5467: l_query VARCHAR2(4000);
5468: l_attr_grp_ids Dbms_Sql.number_table;
5469: l_where_cls VARCHAR2(100):='';
5470: l_num NUMBER;
5471: l_lookup_const VARCHAR2(50);
5472: l_src_doc_id NUMBER := NULL;