DBA Data[Home] [Help]

APPS.CSI_GEN_UTILITY_PVT dependencies on STANDARD

Line 132: -- Standard Start of API savepoint

128: l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_values_rec';
129: l_api_version CONSTANT NUMBER := 1.0;
130: BEGIN
131:
132: -- Standard Start of API savepoint
133: -- SAVEPOINT dump_ext_attrib_values_rec;
134:
135: PUT_LINE (' ');
136: PUT_LINE ('Dumping the values for Extended Attribs Record:');

Line 186: -- Standard Start of API savepoint

182: l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_values_tbl';
183: l_api_version CONSTANT NUMBER := 1.0;
184: BEGIN
185:
186: -- Standard Start of API savepoint
187: -- SAVEPOINT dump_ext_attrib_values_tbl;
188:
189: IF p_ext_attrib_values_tbl.COUNT > 0 THEN
190: FOR tab_row IN p_ext_attrib_values_tbl.FIRST .. p_ext_attrib_values_tbl.LAST

Line 248: -- Standard Start of API savepoint

244: l_api_name CONSTANT VARCHAR2(30) := 'dump_ou_query_rec';
245: l_api_version CONSTANT NUMBER := 1.0;
246: BEGIN
247:
248: -- Standard Start of API savepoint
249: -- SAVEPOINT dump_ext_attrib_query_rec;
250:
251: PUT_LINE (' ');
252: PUT_LINE ('Dumping the values for Extended Attribs Query Record:');

Line 280: -- Standard Start of API savepoint

276: l_api_name CONSTANT VARCHAR2(30) := 'dump_ou_query_rec';
277: l_api_version CONSTANT NUMBER := 1.0;
278: BEGIN
279:
280: -- Standard Start of API savepoint
281: -- SAVEPOINT dump_ou_qurey_rec;
282:
283: PUT_LINE (' ');
284: PUT_LINE ('Dumping the values for Org. Assignments Query Record:');

Line 313: -- Standard Start of API savepoint

309: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_rec';
310: l_api_version CONSTANT NUMBER := 1.0;
311: BEGIN
312:
313: -- Standard Start of API savepoint
314: --SAVEPOINT dump_instance_rec;
315:
316: PUT_LINE (' ');
317: PUT_LINE ('Dumping the values for Instance Record:');

Line 450: -- Standard Start of API savepoint

446: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_query_rec';
447: l_api_version CONSTANT NUMBER := 1.0;
448: BEGIN
449:
450: -- Standard Start of API savepoint
451: -- SAVEPOINT dump_instance_query_rec;
452:
453: PUT_LINE (' ');
454: PUT_LINE ('Dumping the values for Instance Query Record ');

Line 518: -- Standard Start of API savepoint

514: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_header_rec';
515: l_api_version CONSTANT NUMBER := 1.0;
516: BEGIN
517:
518: -- Standard Start of API savepoint
519: -- SAVEPOINT dump_instance_header_rec;
520:
521: PUT_LINE (' ');
522: PUT_LINE ('Dumping the values for Instance Header Record:');

Line 713: -- Standard Start of API savepoint

709: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_rec';
710: l_api_version CONSTANT NUMBER := 1.0;
711: BEGIN
712:
713: -- Standard Start of API savepoint
714: -- SAVEPOINT dump_txn_rec;
715:
716: put_line(' ');
717: put_line('Dumping the values for Transaction Record:');

Line 781: -- Standard Start of API savepoint

777: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_tbl';
778: l_api_version CONSTANT NUMBER := 1.0;
779: BEGIN
780:
781: -- Standard Start of API savepoint
782: -- SAVEPOINT dump_txn_tbl;
783: IF p_txn_tbl.COUNT > 0 THEN
784: FOR tab_row IN p_txn_tbl.FIRST .. p_txn_tbl.LAST
785: LOOP

Line 816: -- Standard Start of API savepoint

812: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_query_rec';
813: l_api_version CONSTANT NUMBER := 1.0;
814: BEGIN
815:
816: -- Standard Start of API savepoint
817: -- SAVEPOINT dump_txn_query_rec;
818:
819: put_line(' ');
820: put_line('Dumping the values for Transaction query Record:');

Line 862: -- Standard Start of API savepoint

858: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_query_rec';
859: l_api_version CONSTANT NUMBER := 1.0;
860: BEGIN
861:
862: -- Standard Start of API savepoint
863: -- SAVEPOINT dump_txn_sort_rec;
864:
865: put_line(' ');
866: put_line('Dumping the values for Transaction sort Record:');

Line 893: -- Standard Start of API savepoint

889: l_api_name CONSTANT VARCHAR2(30) := 'dump_txn_error_rec';
890: l_api_version CONSTANT NUMBER := 1.0;
891: BEGIN
892:
893: -- Standard Start of API savepoint
894: -- SAVEPOINT dump_txn_error_rec;
895:
896: put_line(' ');
897: put_line('Dumping the values for Transaction Error Record:');

Line 941: -- Standard Start of API savepoint

937: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_rec';
938: l_api_version CONSTANT NUMBER := 1.0;
939: BEGIN
940:
941: -- Standard Start of API savepoint
942: -- SAVEPOINT dump_rel_rec;
943:
944: put_line(' ');
945: put_line('Dumping the values for Instance-Instance relationship Record:');

Line 1007: -- Standard Start of API savepoint

1003: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_tbl';
1004: l_api_version CONSTANT NUMBER := 1.0;
1005: BEGIN
1006:
1007: -- Standard Start of API savepoint
1008: -- SAVEPOINT dump_rel_tbl;
1009: IF p_rel_tbl.COUNT > 0 THEN
1010: FOR tab_row IN p_rel_tbl.FIRST .. p_rel_tbl.LAST
1011: LOOP

Line 1042: -- Standard Start of API savepoint

1038: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_query_rec';
1039: l_api_version CONSTANT NUMBER := 1.0;
1040: BEGIN
1041:
1042: -- Standard Start of API savepoint
1043: -- SAVEPOINT dump_rel_query_rec;
1044:
1045: put_line(' ');
1046: put_line('Dumping the values for Instance-Instance relationship query Record:');

Line 1076: -- Standard Start of API savepoint

1072: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_rec';
1073: l_api_version CONSTANT NUMBER := 1.0;
1074: BEGIN
1075:
1076: -- Standard Start of API savepoint
1077: -- SAVEPOINT dump_sys_rec;
1078:
1079: put_line(' ');
1080: put_line('Dumping the values for System Record:');

Line 1151: -- Standard Start of API savepoint

1147: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_tbl';
1148: l_api_version CONSTANT NUMBER := 1.0;
1149: BEGIN
1150:
1151: -- Standard Start of API savepoint
1152: -- SAVEPOINT dump_sys_tbl;
1153: IF p_systems_tbl.COUNT > 0 THEN
1154: FOR tab_row IN p_systems_tbl.FIRST .. p_systems_tbl.LAST
1155: LOOP

Line 1187: -- Standard Start of API savepoint

1183: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_query_rec';
1184: l_api_version CONSTANT NUMBER := 1.0;
1185: BEGIN
1186:
1187: -- Standard Start of API savepoint
1188: -- SAVEPOINT dump_sys_query_rec;
1189:
1190: put_line(' ');
1191: put_line('Dumping the values for System query Record:');

Line 1221: -- Standard Start of API savepoint

1217: l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_rec';
1218: l_api_version CONSTANT NUMBER := 1.0;
1219: BEGIN
1220:
1221: -- Standard Start of API savepoint
1222: -- SAVEPOINT dump_ext_attrib_pvt;
1223:
1224: put_line(' ');
1225: put_line('Dumping the values for Extended attribs Record:');

Line 1278: -- Standard Start of API savepoint

1274: l_api_name CONSTANT VARCHAR2(30) := 'dump_inst_party_id';
1275: l_api_version CONSTANT NUMBER := 1.0;
1276:
1277: BEGIN
1278: -- Standard Start of API savepoint
1279: -- SAVEPOINT dump_inst_party_id;
1280:
1281: FOR i IN p_instance_party_id_lst.FIRST..p_instance_party_id_lst.LAST LOOP
1282:

Line 1306: -- Standard Start of API savepoint

1302: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_asset_rec';
1303: l_api_version CONSTANT NUMBER := 1.0;
1304: BEGIN
1305:
1306: -- Standard Start of API savepoint
1307: -- SAVEPOINT dump_instance_asset_rec;
1308:
1309: PUT_LINE (' ');
1310: PUT_LINE ('Dumping the values for Instance Asset Record:');

Line 1345: -- Standard Start of API savepoint

1341: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_query_rec';
1342: l_api_version CONSTANT NUMBER := 1.0;
1343: BEGIN
1344:
1345: -- Standard Start of API savepoint
1346: -- SAVEPOINT dump_party_query_rec;
1347:
1348: PUT_LINE (' ');
1349: PUT_LINE ('Dumping the values for Instance Party Query Record:');

Line 1377: -- Standard Start of API savepoint

1373: l_api_name CONSTANT VARCHAR2(30) := 'dump_organization_unit_rec';
1374: l_api_version CONSTANT NUMBER := 1.0;
1375: BEGIN
1376:
1377: -- Standard Start of API savepoint
1378: -- SAVEPOINT dump_organization_unit_rec;
1379: PUT_LINE (' ');
1380: PUT_LINE ('Dumping the values for Org. Assignments Record:');
1381: PUT_LINE (' ');

Line 1429: -- Standard Start of API savepoint

1425: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_ORGANIZATION_UNIT_TBL';
1426: l_api_version CONSTANT NUMBER := 1.0;
1427: BEGIN
1428:
1429: -- Standard Start of API savepoint
1430: -- SAVEPOINT dump_organization_unit_tbl;
1431:
1432: IF p_org_unit_tbl.COUNT > 0 THEN
1433: FOR tab_row IN p_org_unit_tbl.FIRST .. p_org_unit_tbl.LAST

Line 1491: -- Standard Start of API savepoint

1487: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_query_rec';
1488: l_api_version CONSTANT NUMBER := 1.0;
1489: BEGIN
1490:
1491: -- Standard Start of API savepoint
1492: -- SAVEPOINT dump_pricing_attribs_query_rec;
1493:
1494: PUT_LINE (' ');
1495: PUT_LINE ('Dumping the values for Pricing Attribs Query Record:');

Line 1523: -- Standard Start of API savepoint

1519: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_rec';
1520: l_api_version CONSTANT NUMBER := 1.0;
1521: BEGIN
1522:
1523: -- Standard Start of API savepoint
1524: -- SAVEPOINT dump_pricing_attribs_rec;
1525:
1526: PUT_LINE (' ');
1527: PUT_LINE ('Dumping the values for Pricing Attribs Record:');

Line 1674: -- Standard Start of API savepoint

1670: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_tbl';
1671: l_api_version CONSTANT NUMBER := 1.0;
1672: BEGIN
1673:
1674: -- Standard Start of API savepoint
1675: -- SAVEPOINT dump_pricing_attribs_tbl;
1676:
1677: IF p_pricing_attribs_tbl.COUNT > 0 THEN
1678: FOR tab_row IN p_pricing_attribs_tbl.FIRST .. p_pricing_attribs_tbl.LAST

Line 1834: -- Standard Start of API savepoint

1830: ) IS
1831: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_rec';
1832: l_api_version CONSTANT NUMBER := 1.0;
1833: BEGIN
1834: -- Standard Start of API savepoint
1835: -- SAVEPOINT dump_party_rec;
1836:
1837: PUT_LINE (' ');
1838: PUT_LINE ('Dumping the values for Instance Party Record:');

Line 1887: -- Standard Start of API savepoint

1883: IS
1884: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_PARTY_TBL';
1885: l_api_version CONSTANT NUMBER := 1.0;
1886: BEGIN
1887: -- Standard Start of API savepoint
1888: -- SAVEPOINT dump_party_tbl;
1889:
1890: IF p_party_tbl.COUNT > 0 THEN
1891: FOR tab_row IN p_party_tbl.FIRST .. p_party_tbl.LAST LOOP

Line 1947: -- Standard Start of API savepoint

1943: l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_rec';
1944: l_api_version CONSTANT NUMBER := 1.0;
1945: BEGIN
1946:
1947: -- Standard Start of API savepoint
1948: -- SAVEPOINT dump_version_label_rec;
1949:
1950: PUT_LINE (' ');
1951: PUT_LINE ('Dumping the values for Version Labels Record:');

Line 1998: -- Standard Start of API savepoint

1994: l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_tbl';
1995: l_api_version CONSTANT NUMBER := 1.0;
1996: BEGIN
1997:
1998: -- Standard Start of API savepoint
1999: -- SAVEPOINT dump_version_label_tbl;
2000:
2001: IF p_version_label_tbl.COUNT > 0 THEN
2002: FOR tab_row IN p_version_label_tbl.FIRST .. p_version_label_tbl.LAST LOOP

Line 2054: -- Standard Start of API savepoint

2050: l_api_version CONSTANT NUMBER := 1.0;
2051:
2052: BEGIN
2053:
2054: -- Standard Start of API savepoint
2055: -- SAVEPOINT dump_party_account_tbl;
2056:
2057: IF p_party_account_tbl.COUNT > 0 THEN
2058: FOR tab_row IN p_party_account_tbl.FIRST .. p_party_account_tbl.LAST LOOP

Line 2109: -- Standard Start of API savepoint

2105: ) IS
2106: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_account_rec';
2107: l_api_version CONSTANT NUMBER := 1.0;
2108: BEGIN
2109: -- Standard Start of API savepoint
2110: -- SAVEPOINT dump_party_account_rec;
2111:
2112: PUT_LINE (' ');
2113: PUT_LINE ('Dumping the values for Instance Party Account Record:');

Line 2163: -- Standard Start of API savepoint

2159:
2160: l_api_name CONSTANT VARCHAR2(30) := 'dump_account_query_rec';
2161: l_api_version CONSTANT NUMBER := 1.0;
2162: BEGIN
2163: -- Standard Start of API savepoint
2164: -- SAVEPOINT dump_account_query_rec;
2165:
2166: PUT_LINE (' ');
2167: PUT_LINE ('Dumping the values for Instance Party Account Query Record:');

Line 2193: -- Standard Start of API savepoint

2189:
2190: l_api_name CONSTANT VARCHAR2(30) := 'dump_asset_query_rec';
2191: l_api_version CONSTANT NUMBER := 1.0;
2192: BEGIN
2193: -- Standard Start of API savepoint
2194: -- SAVEPOINT dump_asset_query_rec;
2195:
2196: PUT_LINE (' ');
2197: PUT_LINE ('Dumping the values for Instance Assets Query Record:');

Line 2225: -- Standard Start of API savepoint

2221:
2222: l_api_name CONSTANT VARCHAR2(30) := 'dump_ver_label_query_rec';
2223: l_api_version CONSTANT NUMBER := 1.0;
2224: BEGIN
2225: -- Standard Start of API savepoint
2226: -- SAVEPOINT dump_ver_label_query_rec;
2227:
2228: PUT_LINE (' ');
2229: PUT_LINE ('Dumping the values for Version Labels Query Record:');

Line 2256: -- Standard Start of API savepoint

2252: l_api_name CONSTANT VARCHAR2(30) := 'dump_id_tbl';
2253: l_api_version CONSTANT NUMBER := 1.0;
2254: BEGIN
2255:
2256: -- Standard Start of API savepoint
2257: -- SAVEPOINT dump_id_tbl;
2258:
2259: IF id_tbl.COUNT > 0 THEN
2260: FOR tab_row IN id_tbl.FIRST .. id_tbl.LAST LOOP

Line 2362: -- Standard Start of API savepoint

2358: IS
2359: l_api_name CONSTANT VARCHAR2(30) := 'dump_call_batch_val';
2360: l_api_version CONSTANT NUMBER := 1.0;
2361: BEGIN
2362: -- Standard Start of API savepoint
2363: -- SAVEPOINT dump_call_batch_val;
2364: PUT_LINE ('Api_version :'||p_api_version);
2365: PUT_LINE ('Init_msg_list :'||p_init_msg_list);
2366: FOR tab_row IN p_parameter_name.FIRST..p_parameter_name.LAST