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 999: -- Standard Start of API savepoint

995: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_tbl';
996: l_api_version CONSTANT NUMBER := 1.0;
997: BEGIN
998:
999: -- Standard Start of API savepoint
1000: -- SAVEPOINT dump_rel_tbl;
1001: IF p_rel_tbl.COUNT > 0 THEN
1002: FOR tab_row IN p_rel_tbl.FIRST .. p_rel_tbl.LAST
1003: LOOP

Line 1034: -- Standard Start of API savepoint

1030: l_api_name CONSTANT VARCHAR2(30) := 'dump_rel_query_rec';
1031: l_api_version CONSTANT NUMBER := 1.0;
1032: BEGIN
1033:
1034: -- Standard Start of API savepoint
1035: -- SAVEPOINT dump_rel_query_rec;
1036:
1037: put_line(' ');
1038: put_line('Dumping the values for Instance-Instance relationship query Record:');

Line 1068: -- Standard Start of API savepoint

1064: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_rec';
1065: l_api_version CONSTANT NUMBER := 1.0;
1066: BEGIN
1067:
1068: -- Standard Start of API savepoint
1069: -- SAVEPOINT dump_sys_rec;
1070:
1071: put_line(' ');
1072: put_line('Dumping the values for System Record:');

Line 1143: -- Standard Start of API savepoint

1139: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_tbl';
1140: l_api_version CONSTANT NUMBER := 1.0;
1141: BEGIN
1142:
1143: -- Standard Start of API savepoint
1144: -- SAVEPOINT dump_sys_tbl;
1145: IF p_systems_tbl.COUNT > 0 THEN
1146: FOR tab_row IN p_systems_tbl.FIRST .. p_systems_tbl.LAST
1147: LOOP

Line 1179: -- Standard Start of API savepoint

1175: l_api_name CONSTANT VARCHAR2(30) := 'dump_sys_query_rec';
1176: l_api_version CONSTANT NUMBER := 1.0;
1177: BEGIN
1178:
1179: -- Standard Start of API savepoint
1180: -- SAVEPOINT dump_sys_query_rec;
1181:
1182: put_line(' ');
1183: put_line('Dumping the values for System query Record:');

Line 1213: -- Standard Start of API savepoint

1209: l_api_name CONSTANT VARCHAR2(30) := 'dump_ext_attrib_rec';
1210: l_api_version CONSTANT NUMBER := 1.0;
1211: BEGIN
1212:
1213: -- Standard Start of API savepoint
1214: -- SAVEPOINT dump_ext_attrib_pvt;
1215:
1216: put_line(' ');
1217: put_line('Dumping the values for Extended attribs Record:');

Line 1270: -- Standard Start of API savepoint

1266: l_api_name CONSTANT VARCHAR2(30) := 'dump_inst_party_id';
1267: l_api_version CONSTANT NUMBER := 1.0;
1268:
1269: BEGIN
1270: -- Standard Start of API savepoint
1271: -- SAVEPOINT dump_inst_party_id;
1272:
1273: FOR i IN p_instance_party_id_lst.FIRST..p_instance_party_id_lst.LAST LOOP
1274:

Line 1298: -- Standard Start of API savepoint

1294: l_api_name CONSTANT VARCHAR2(30) := 'dump_instance_asset_rec';
1295: l_api_version CONSTANT NUMBER := 1.0;
1296: BEGIN
1297:
1298: -- Standard Start of API savepoint
1299: -- SAVEPOINT dump_instance_asset_rec;
1300:
1301: PUT_LINE (' ');
1302: PUT_LINE ('Dumping the values for Instance Asset Record:');

Line 1337: -- Standard Start of API savepoint

1333: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_query_rec';
1334: l_api_version CONSTANT NUMBER := 1.0;
1335: BEGIN
1336:
1337: -- Standard Start of API savepoint
1338: -- SAVEPOINT dump_party_query_rec;
1339:
1340: PUT_LINE (' ');
1341: PUT_LINE ('Dumping the values for Instance Party Query Record:');

Line 1369: -- Standard Start of API savepoint

1365: l_api_name CONSTANT VARCHAR2(30) := 'dump_organization_unit_rec';
1366: l_api_version CONSTANT NUMBER := 1.0;
1367: BEGIN
1368:
1369: -- Standard Start of API savepoint
1370: -- SAVEPOINT dump_organization_unit_rec;
1371: PUT_LINE (' ');
1372: PUT_LINE ('Dumping the values for Org. Assignments Record:');
1373: PUT_LINE (' ');

Line 1421: -- Standard Start of API savepoint

1417: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_ORGANIZATION_UNIT_TBL';
1418: l_api_version CONSTANT NUMBER := 1.0;
1419: BEGIN
1420:
1421: -- Standard Start of API savepoint
1422: -- SAVEPOINT dump_organization_unit_tbl;
1423:
1424: IF p_org_unit_tbl.COUNT > 0 THEN
1425: FOR tab_row IN p_org_unit_tbl.FIRST .. p_org_unit_tbl.LAST

Line 1483: -- Standard Start of API savepoint

1479: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_query_rec';
1480: l_api_version CONSTANT NUMBER := 1.0;
1481: BEGIN
1482:
1483: -- Standard Start of API savepoint
1484: -- SAVEPOINT dump_pricing_attribs_query_rec;
1485:
1486: PUT_LINE (' ');
1487: PUT_LINE ('Dumping the values for Pricing Attribs Query Record:');

Line 1515: -- Standard Start of API savepoint

1511: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_rec';
1512: l_api_version CONSTANT NUMBER := 1.0;
1513: BEGIN
1514:
1515: -- Standard Start of API savepoint
1516: -- SAVEPOINT dump_pricing_attribs_rec;
1517:
1518: PUT_LINE (' ');
1519: PUT_LINE ('Dumping the values for Pricing Attribs Record:');

Line 1666: -- Standard Start of API savepoint

1662: l_api_name CONSTANT VARCHAR2(30) := 'dump_pricing_attribs_tbl';
1663: l_api_version CONSTANT NUMBER := 1.0;
1664: BEGIN
1665:
1666: -- Standard Start of API savepoint
1667: -- SAVEPOINT dump_pricing_attribs_tbl;
1668:
1669: IF p_pricing_attribs_tbl.COUNT > 0 THEN
1670: FOR tab_row IN p_pricing_attribs_tbl.FIRST .. p_pricing_attribs_tbl.LAST

Line 1826: -- Standard Start of API savepoint

1822: ) IS
1823: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_rec';
1824: l_api_version CONSTANT NUMBER := 1.0;
1825: BEGIN
1826: -- Standard Start of API savepoint
1827: -- SAVEPOINT dump_party_rec;
1828:
1829: PUT_LINE (' ');
1830: PUT_LINE ('Dumping the values for Instance Party Record:');

Line 1879: -- Standard Start of API savepoint

1875: IS
1876: l_api_name CONSTANT VARCHAR2(30) := 'DUMP_PARTY_TBL';
1877: l_api_version CONSTANT NUMBER := 1.0;
1878: BEGIN
1879: -- Standard Start of API savepoint
1880: -- SAVEPOINT dump_party_tbl;
1881:
1882: IF p_party_tbl.COUNT > 0 THEN
1883: FOR tab_row IN p_party_tbl.FIRST .. p_party_tbl.LAST LOOP

Line 1938: -- Standard Start of API savepoint

1934: l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_rec';
1935: l_api_version CONSTANT NUMBER := 1.0;
1936: BEGIN
1937:
1938: -- Standard Start of API savepoint
1939: -- SAVEPOINT dump_version_label_rec;
1940:
1941: PUT_LINE (' ');
1942: PUT_LINE ('Dumping the values for Version Labels Record:');

Line 1989: -- Standard Start of API savepoint

1985: l_api_name CONSTANT VARCHAR2(30) := 'dump_version_label_tbl';
1986: l_api_version CONSTANT NUMBER := 1.0;
1987: BEGIN
1988:
1989: -- Standard Start of API savepoint
1990: -- SAVEPOINT dump_version_label_tbl;
1991:
1992: IF p_version_label_tbl.COUNT > 0 THEN
1993: FOR tab_row IN p_version_label_tbl.FIRST .. p_version_label_tbl.LAST LOOP

Line 2045: -- Standard Start of API savepoint

2041: l_api_version CONSTANT NUMBER := 1.0;
2042:
2043: BEGIN
2044:
2045: -- Standard Start of API savepoint
2046: -- SAVEPOINT dump_party_account_tbl;
2047:
2048: IF p_party_account_tbl.COUNT > 0 THEN
2049: FOR tab_row IN p_party_account_tbl.FIRST .. p_party_account_tbl.LAST LOOP

Line 2100: -- Standard Start of API savepoint

2096: ) IS
2097: l_api_name CONSTANT VARCHAR2(30) := 'dump_party_account_rec';
2098: l_api_version CONSTANT NUMBER := 1.0;
2099: BEGIN
2100: -- Standard Start of API savepoint
2101: -- SAVEPOINT dump_party_account_rec;
2102:
2103: PUT_LINE (' ');
2104: PUT_LINE ('Dumping the values for Instance Party Account Record:');

Line 2154: -- Standard Start of API savepoint

2150:
2151: l_api_name CONSTANT VARCHAR2(30) := 'dump_account_query_rec';
2152: l_api_version CONSTANT NUMBER := 1.0;
2153: BEGIN
2154: -- Standard Start of API savepoint
2155: -- SAVEPOINT dump_account_query_rec;
2156:
2157: PUT_LINE (' ');
2158: PUT_LINE ('Dumping the values for Instance Party Account Query Record:');

Line 2184: -- Standard Start of API savepoint

2180:
2181: l_api_name CONSTANT VARCHAR2(30) := 'dump_asset_query_rec';
2182: l_api_version CONSTANT NUMBER := 1.0;
2183: BEGIN
2184: -- Standard Start of API savepoint
2185: -- SAVEPOINT dump_asset_query_rec;
2186:
2187: PUT_LINE (' ');
2188: PUT_LINE ('Dumping the values for Instance Assets Query Record:');

Line 2216: -- Standard Start of API savepoint

2212:
2213: l_api_name CONSTANT VARCHAR2(30) := 'dump_ver_label_query_rec';
2214: l_api_version CONSTANT NUMBER := 1.0;
2215: BEGIN
2216: -- Standard Start of API savepoint
2217: -- SAVEPOINT dump_ver_label_query_rec;
2218:
2219: PUT_LINE (' ');
2220: PUT_LINE ('Dumping the values for Version Labels Query Record:');

Line 2247: -- Standard Start of API savepoint

2243: l_api_name CONSTANT VARCHAR2(30) := 'dump_id_tbl';
2244: l_api_version CONSTANT NUMBER := 1.0;
2245: BEGIN
2246:
2247: -- Standard Start of API savepoint
2248: -- SAVEPOINT dump_id_tbl;
2249:
2250: IF id_tbl.COUNT > 0 THEN
2251: FOR tab_row IN id_tbl.FIRST .. id_tbl.LAST LOOP

Line 2353: -- Standard Start of API savepoint

2349: IS
2350: l_api_name CONSTANT VARCHAR2(30) := 'dump_call_batch_val';
2351: l_api_version CONSTANT NUMBER := 1.0;
2352: BEGIN
2353: -- Standard Start of API savepoint
2354: -- SAVEPOINT dump_call_batch_val;
2355: PUT_LINE ('Api_version :'||p_api_version);
2356: PUT_LINE ('Init_msg_list :'||p_init_msg_list);
2357: FOR tab_row IN p_parameter_name.FIRST..p_parameter_name.LAST