[Home] [Help]
44: NULL;
45: END Update_Interface_Table;
46: --
47: FUNCTION Valid_Lot_Number
48: ( p_instance_rec IN csi_datastructures_pub.instance_rec,
49: p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
50: ) RETURN BOOLEAN IS
51: --
52: l_lot_type NUMBER;
45: END Update_Interface_Table;
46: --
47: FUNCTION Valid_Lot_Number
48: ( p_instance_rec IN csi_datastructures_pub.instance_rec,
49: p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
50: ) RETURN BOOLEAN IS
51: --
52: l_lot_type NUMBER;
53: l_temp VARCHAR2(1);
101: RETURN l_return_value;
102: END Valid_Lot_Number;
103: --
104: FUNCTION Valid_Serial_Number
105: ( p_instance_rec IN csi_datastructures_pub.instance_rec,
106: p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
107: p_inst_tab_row IN NUMBER := -1 --bug 9227016
108: ) RETURN BOOLEAN IS
109: --
102: END Valid_Lot_Number;
103: --
104: FUNCTION Valid_Serial_Number
105: ( p_instance_rec IN csi_datastructures_pub.instance_rec,
106: p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
107: p_inst_tab_row IN NUMBER := -1 --bug 9227016
108: ) RETURN BOOLEAN IS
109: --
110: l_serial_type NUMBER;
291: END Valid_Serial_Number;
292: --
293: FUNCTION Check_Inst_Party_Rules
294: (
295: p_party_tbl IN csi_datastructures_pub.party_tbl
296: ,p_party_rec IN csi_datastructures_pub.party_rec
297: ,p_start_date IN DATE -- Instance start date
298: ,p_end_date IN DATE -- Instance end date
299: ) RETURN BOOLEAN IS
292: --
293: FUNCTION Check_Inst_Party_Rules
294: (
295: p_party_tbl IN csi_datastructures_pub.party_tbl
296: ,p_party_rec IN csi_datastructures_pub.party_rec
297: ,p_start_date IN DATE -- Instance start date
298: ,p_end_date IN DATE -- Instance end date
299: ) RETURN BOOLEAN IS
300: --
297: ,p_start_date IN DATE -- Instance start date
298: ,p_end_date IN DATE -- Instance end date
299: ) RETURN BOOLEAN IS
300: --
301: l_party_rec csi_datastructures_pub.party_rec := p_party_rec;
302: l_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
303: l_count NUMBER := 0;
304: l_primary_pty_count NUMBER := 0;
305: l_primary_con_count NUMBER := 0;
298: ,p_end_date IN DATE -- Instance end date
299: ) RETURN BOOLEAN IS
300: --
301: l_party_rec csi_datastructures_pub.party_rec := p_party_rec;
302: l_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
303: l_count NUMBER := 0;
304: l_primary_pty_count NUMBER := 0;
305: l_primary_con_count NUMBER := 0;
306: l_return_status BOOLEAN;
433: END Check_Inst_Party_Rules;
434: --
435: FUNCTION Check_Party_Acct_Rules
436: (
437: p_account_tbl IN csi_datastructures_pub.party_account_tbl
438: ,p_account_rec IN csi_datastructures_pub.party_account_rec
439: ,p_pty_src_table IN VARCHAR2
440: ,p_party_id IN NUMBER
441: ,p_acct_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_id_tbl
434: --
435: FUNCTION Check_Party_Acct_Rules
436: (
437: p_account_tbl IN csi_datastructures_pub.party_account_tbl
438: ,p_account_rec IN csi_datastructures_pub.party_account_rec
439: ,p_pty_src_table IN VARCHAR2
440: ,p_party_id IN NUMBER
441: ,p_acct_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_id_tbl
442: ,p_start_date IN DATE -- Instance Party Start Date
594: RETURN l_return_status;
595: END Check_Party_Acct_Rules;
596: --
597: FUNCTION Check_Org_Rules
598: ( p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
599: ,p_org_units_rec IN csi_datastructures_pub.organization_units_rec
600: ,p_start_date IN DATE
601: ,p_end_date IN DATE
602: ) RETURN BOOLEAN IS
595: END Check_Party_Acct_Rules;
596: --
597: FUNCTION Check_Org_Rules
598: ( p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
599: ,p_org_units_rec IN csi_datastructures_pub.organization_units_rec
600: ,p_start_date IN DATE
601: ,p_end_date IN DATE
602: ) RETURN BOOLEAN IS
603: --
658: END Check_Org_Rules;
659: --
660: FUNCTION Check_Pricing_Rules
661: (
662: p_pricing_rec IN csi_datastructures_pub.pricing_attribs_rec
663: ,p_start_date IN DATE
664: ,p_end_date IN DATE
665: ) RETURN BOOLEAN IS
666: --
701: END Check_Pricing_Rules;
702: --
703: FUNCTION Check_Ext_Rules
704: (
705: p_ext_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
706: ,p_ext_rec IN csi_datastructures_pub.extend_attrib_values_rec
707: ,p_start_date IN DATE
708: ,p_end_date IN DATE
709: ) RETURN BOOLEAN IS
702: --
703: FUNCTION Check_Ext_Rules
704: (
705: p_ext_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
706: ,p_ext_rec IN csi_datastructures_pub.extend_attrib_values_rec
707: ,p_start_date IN DATE
708: ,p_end_date IN DATE
709: ) RETURN BOOLEAN IS
710: --
765: END Check_Ext_Rules;
766: --
767: FUNCTION Check_Asset_Rules
768: (
769: p_asset_rec IN csi_datastructures_pub.instance_asset_rec
770: ,p_start_date IN DATE
771: ,p_end_date IN DATE
772: ) RETURN BOOLEAN IS
773: --
808: END Check_Asset_Rules;
809: --
810: PROCEDURE Build_Instance_History
811: (
812: p_inst_hist_tbl IN OUT NOCOPY csi_datastructures_pub.instance_history_tbl
813: ,p_inst_rec IN csi_datastructures_pub.instance_rec
814: ,p_txn_id IN NUMBER
815: ) IS
816: --
809: --
810: PROCEDURE Build_Instance_History
811: (
812: p_inst_hist_tbl IN OUT NOCOPY csi_datastructures_pub.instance_history_tbl
813: ,p_inst_rec IN csi_datastructures_pub.instance_rec
814: ,p_txn_id IN NUMBER
815: ) IS
816: --
817: l_count NUMBER;
1022: END Build_Instance_History;
1023: --
1024: PROCEDURE Build_Ver_Label_History
1025: (
1026: p_ver_label_history_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1027: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
1028: ,p_txn_id IN NUMBER
1029: ) IS
1030: --
1023: --
1024: PROCEDURE Build_Ver_Label_History
1025: (
1026: p_ver_label_history_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1027: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
1028: ,p_txn_id IN NUMBER
1029: ) IS
1030: --
1031: l_count NUMBER;
1083: p_ver_label_history_tbl(l_count).NEW_ATTRIBUTE15 := p_version_label_rec.ATTRIBUTE15;
1084: END Build_Ver_Label_History;
1085: --
1086: PROCEDURE Build_Party_History
1087: ( p_party_hist_tbl IN OUT NOCOPY csi_datastructures_pub.party_history_tbl
1088: ,p_party_rec IN csi_datastructures_pub.party_rec
1089: ,p_txn_id IN NUMBER
1090: ) IS
1091: l_count NUMBER;
1084: END Build_Ver_Label_History;
1085: --
1086: PROCEDURE Build_Party_History
1087: ( p_party_hist_tbl IN OUT NOCOPY csi_datastructures_pub.party_history_tbl
1088: ,p_party_rec IN csi_datastructures_pub.party_rec
1089: ,p_txn_id IN NUMBER
1090: ) IS
1091: l_count NUMBER;
1092: l_hist_id NUMBER;
1151: p_party_hist_tbl(l_count).NEW_PREFERRED_FLAG := p_party_rec.PREFERRED_FLAG;
1152: END Build_Party_History;
1153: --
1154: PROCEDURE Build_Account_History
1155: ( p_acct_hist_tbl IN OUT NOCOPY csi_datastructures_pub.account_history_tbl
1156: ,p_acct_rec IN csi_datastructures_pub.party_account_rec
1157: ,p_txn_id IN NUMBER
1158: ) IS
1159: --
1152: END Build_Party_History;
1153: --
1154: PROCEDURE Build_Account_History
1155: ( p_acct_hist_tbl IN OUT NOCOPY csi_datastructures_pub.account_history_tbl
1156: ,p_acct_rec IN csi_datastructures_pub.party_account_rec
1157: ,p_txn_id IN NUMBER
1158: ) IS
1159: --
1160: l_count NUMBER;
1215: END Build_Account_History;
1216: --
1217: PROCEDURE Build_Org_History
1218: (
1219: p_org_hist_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1220: ,p_org_rec IN csi_datastructures_pub.organization_units_rec
1221: ,p_txn_id IN NUMBER
1222: ) IS
1223: --
1216: --
1217: PROCEDURE Build_Org_History
1218: (
1219: p_org_hist_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1220: ,p_org_rec IN csi_datastructures_pub.organization_units_rec
1221: ,p_txn_id IN NUMBER
1222: ) IS
1223: --
1224: l_count NUMBER;
1275: END Build_Org_History;
1276: --
1277: PROCEDURE Build_Pricing_History
1278: (
1279: p_pricing_hist_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_history_tbl
1280: ,p_pricing_rec IN csi_datastructures_pub.pricing_attribs_rec
1281: ,p_txn_id IN NUMBER
1282: ) IS
1283: --
1276: --
1277: PROCEDURE Build_Pricing_History
1278: (
1279: p_pricing_hist_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_history_tbl
1280: ,p_pricing_rec IN csi_datastructures_pub.pricing_attribs_rec
1281: ,p_txn_id IN NUMBER
1282: ) IS
1283: --
1284: l_count NUMBER;
1533: END Build_Pricing_History;
1534: --
1535: PROCEDURE Build_Ext_Attr_History
1536: (
1537: p_ext_attr_hist_tbl IN OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1538: ,p_ext_attr_rec IN csi_datastructures_pub.extend_attrib_values_rec
1539: ,p_txn_id IN NUMBER
1540: ) IS
1541: --
1534: --
1535: PROCEDURE Build_Ext_Attr_History
1536: (
1537: p_ext_attr_hist_tbl IN OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1538: ,p_ext_attr_rec IN csi_datastructures_pub.extend_attrib_values_rec
1539: ,p_txn_id IN NUMBER
1540: ) IS
1541: --
1542: l_count NUMBER;
1593: END Build_Ext_Attr_History;
1594: --
1595: PROCEDURE Build_Asset_History
1596: (
1597: p_asset_hist_tbl IN OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1598: ,p_asset_rec IN csi_datastructures_pub.instance_asset_rec
1599: ,p_txn_id IN NUMBER
1600: ) IS
1601: --
1594: --
1595: PROCEDURE Build_Asset_History
1596: (
1597: p_asset_hist_tbl IN OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1598: ,p_asset_rec IN csi_datastructures_pub.instance_asset_rec
1599: ,p_txn_id IN NUMBER
1600: ) IS
1601: --
1602: l_count NUMBER;
1630: END Build_Asset_History;
1631: --
1632: PROCEDURE Build_Inst_Rec_of_Table
1633: (
1634: p_inst_tbl IN csi_datastructures_pub.instance_tbl
1635: ,p_inst_rec_tab IN OUT NOCOPY csi_item_instance_grp.instance_rec_tab
1636: ) IS
1637: BEGIN
1638: FOR i in p_inst_tbl.FIRST .. p_inst_tbl.LAST LOOP
1749: END LOOP;
1750: END Build_Inst_Rec_of_Table;
1751: --
1752: PROCEDURE Build_Inst_Hist_Rec_of_Table
1753: ( p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
1754: ,p_inst_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.instance_history_rec_tab
1755: ) IS
1756: BEGIN
1757: FOR i in p_inst_hist_tbl.FIRST .. p_inst_hist_tbl.LAST LOOP
2031: END Build_Inst_Hist_Rec_of_Table;
2032: --
2033: PROCEDURE Build_Ver_Label_Rec_of_Table
2034: (
2035: p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
2036: ,p_version_label_rec_tab IN OUT NOCOPY csi_item_instance_grp.version_label_rec_tab
2037: ) IS
2038: BEGIN
2039: FOR i in p_version_label_tbl.FIRST .. p_version_label_tbl.LAST LOOP
2065: END Build_Ver_Label_Rec_of_Table;
2066: --
2067: PROCEDURE Build_Ver_Lbl_Hist_Rec_Table
2068: (
2069: p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
2070: ,p_ver_label_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.ver_label_history_rec_tab
2071: ) IS
2072: BEGIN
2073: FOR i in p_ver_label_hist_tbl.FIRST .. p_ver_label_hist_tbl.LAST LOOP
2122: END LOOP;
2123: END Build_Ver_Lbl_Hist_Rec_Table;
2124: --
2125: PROCEDURE Build_Party_Rec_of_Table
2126: ( p_party_tbl IN csi_datastructures_pub.party_tbl
2127: ,p_party_rec_tab IN OUT NOCOPY csi_item_instance_grp.party_rec_tab
2128: ) IS
2129: BEGIN
2130: FOR i in p_party_tbl.FIRST .. p_party_tbl.LAST LOOP
2162: END LOOP;
2163: END Build_Party_Rec_of_Table;
2164: --
2165: PROCEDURE Build_Party_Hist_Rec_of_Table
2166: ( p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
2167: ,p_party_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.party_history_rec_tab
2168: ) IS
2169: BEGIN
2170: FOR i in p_party_hist_tbl.FIRST .. p_party_hist_tbl.LAST LOOP
2260: END Build_Party_Hist_Rec_of_Table;
2261: --
2262: PROCEDURE Build_Acct_Rec_of_Table
2263: (
2264: p_account_tbl IN csi_datastructures_pub.party_account_tbl
2265: ,p_account_rec_tab IN OUT NOCOPY csi_item_instance_grp.account_rec_tab
2266: ) IS
2267: BEGIN
2268: FOR i in p_account_tbl.FIRST .. p_account_tbl.LAST LOOP
2300: END Build_Acct_Rec_of_Table;
2301: --
2302: PROCEDURE Build_Acct_Hist_Rec_of_Table
2303: (
2304: p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
2305: ,p_acct_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.account_history_rec_tab
2306: ) IS
2307: BEGIN
2308: FOR i in p_acct_hist_tbl.FIRST .. p_acct_hist_tbl.LAST LOOP
2382: END Build_Owner_Pty_Acct_Rec_Table;
2383: --
2384: PROCEDURE Build_Txn_Rec_of_Table
2385: (
2386: p_txn_tbl IN csi_datastructures_pub.transaction_tbl
2387: ,p_txn_rec_tab IN OUT NOCOPY csi_item_instance_grp.transaction_rec_tab
2388: ) IS
2389: BEGIN
2390: FOR i in p_txn_tbl.FIRST .. p_txn_tbl.LAST LOOP
2431: END Build_Txn_Rec_of_Table;
2432: --
2433: PROCEDURE Build_Org_Rec_of_Table
2434: (
2435: p_org_tbl IN csi_datastructures_pub.organization_units_tbl
2436: ,p_org_units_rec_tab IN OUT NOCOPY csi_item_instance_grp.org_units_rec_tab
2437: ) IS
2438: BEGIN
2439: FOR i in p_org_tbl.FIRST .. p_org_tbl.LAST LOOP
2464: END LOOP;
2465: END Build_Org_Rec_of_Table;
2466: --
2467: PROCEDURE Build_Org_Hist_Rec_of_Table
2468: ( p_org_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
2469: ,p_org_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.org_units_history_rec_tab
2470: ) IS
2471: BEGIN
2472: FOR i in p_org_hist_tbl.FIRST .. p_org_hist_tbl.LAST LOOP
2523: END Build_Org_Hist_Rec_of_Table;
2524: --
2525: PROCEDURE Build_pricing_Rec_of_Table
2526: (
2527: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
2528: ,p_pricing_rec_tab IN OUT NOCOPY csi_item_instance_grp.pricing_attribs_rec_tab
2529: ) IS
2530: BEGIN
2531: FOR i in p_pricing_tbl.FIRST .. p_pricing_tbl.LAST LOOP
2655: END LOOP;
2656: END Build_pricing_Rec_of_Table;
2657: --
2658: PROCEDURE Build_pricing_Hist_Rec_Table
2659: ( p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
2660: ,p_pricing_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.pricing_attribs_hist_rec_tab
2661: ) IS
2662: BEGIN
2663: FOR i in p_pricing_hist_tbl.FIRST .. p_pricing_hist_tbl.LAST LOOP
2907: END Build_pricing_Hist_Rec_Table;
2908: --
2909: PROCEDURE Build_Ext_Attr_Rec_Table
2910: (
2911: p_ext_attr_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
2912: ,p_ext_attr_rec_tab IN OUT NOCOPY csi_item_instance_grp.extend_attrib_values_rec_tab
2913: ) IS
2914:
2915: BEGIN
2945: END Build_Ext_Attr_Rec_Table;
2946: --
2947: PROCEDURE Build_Ext_Attr_Hist_Rec_Table
2948: (
2949: p_ext_attr_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
2950: ,p_ext_attr_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.ext_attrib_val_hist_rec_tab
2951: ) IS
2952: BEGIN
2953: FOR i in p_ext_attr_hist_tbl.FIRST .. p_ext_attr_hist_tbl.LAST LOOP
3000: END Build_Ext_Attr_Hist_Rec_Table;
3001: --
3002: PROCEDURE Build_Asset_Rec_Table
3003: (
3004: p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3005: ,p_asset_rec_tab IN OUT NOCOPY csi_item_instance_grp.instance_asset_rec_tab
3006: ) IS
3007:
3008: BEGIN
3026: END Build_Asset_Rec_Table;
3027: --
3028: PROCEDURE Build_Asset_Hist_Rec_Table
3029: (
3030: p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3031: ,p_asset_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.ins_asset_history_rec_tab
3032: ) IS
3033: BEGIN
3034: FOR i in p_asset_hist_tbl.FIRST .. p_asset_hist_tbl.LAST LOOP
3090: END Build_Asset_Hist_Rec_Table;
3091: --
3092: PROCEDURE Bulk_Insert
3093: (
3094: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3095: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3096: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3097: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3091: --
3092: PROCEDURE Bulk_Insert
3093: (
3094: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3095: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3096: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3097: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3099: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3092: PROCEDURE Bulk_Insert
3093: (
3094: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3095: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3096: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3097: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3099: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3100: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3093: (
3094: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3095: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3096: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3097: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3099: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3100: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3101: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3094: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3095: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3096: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3097: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3099: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3100: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3101: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3102: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3095: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3096: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3097: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3099: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3100: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3101: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3102: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3096: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3097: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3099: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3100: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3101: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3102: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3104: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3097: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3099: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3100: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3101: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3102: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3104: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3105: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3098: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3099: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3100: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3101: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3102: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3104: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3105: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3106: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3100: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3101: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3102: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3104: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3105: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3106: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3107: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3108: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3101: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3102: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3104: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3105: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3106: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3107: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3108: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3109: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3102: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3104: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3105: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3106: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3107: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3108: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3109: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3110: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3103: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3104: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3105: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3106: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3107: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3108: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3109: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3110: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3111: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3104: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3105: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3106: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3107: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3108: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3109: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3110: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3111: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3112: ,x_return_status OUT NOCOPY VARCHAR2
3105: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3106: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3107: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3108: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3109: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3110: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3111: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3112: ,x_return_status OUT NOCOPY VARCHAR2
3113: ) IS
3106: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3107: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3108: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3109: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3110: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3111: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3112: ,x_return_status OUT NOCOPY VARCHAR2
3113: ) IS
3114: --
3107: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3108: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3109: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3110: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3111: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3112: ,x_return_status OUT NOCOPY VARCHAR2
3113: ) IS
3114: --
3115: l_inst_rec_tab csi_item_instance_grp.instance_rec_tab;
5792: p_api_version IN NUMBER
5793: ,p_commit IN VARCHAR2
5794: ,p_init_msg_list IN VARCHAR2
5795: ,p_validation_level IN NUMBER
5796: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5797: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5798: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5799: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5800: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5793: ,p_commit IN VARCHAR2
5794: ,p_init_msg_list IN VARCHAR2
5795: ,p_validation_level IN NUMBER
5796: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5797: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5798: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5799: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5800: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5801: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5794: ,p_init_msg_list IN VARCHAR2
5795: ,p_validation_level IN NUMBER
5796: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5797: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5798: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5799: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5800: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5801: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5802: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5795: ,p_validation_level IN NUMBER
5796: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5797: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5798: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5799: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5800: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5801: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5802: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5803: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5796: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5797: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5798: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5799: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5800: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5801: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5802: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5803: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5804: ,p_call_from_bom_expl IN VARCHAR2
5797: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5798: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5799: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5800: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5801: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5802: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5803: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5804: ,p_call_from_bom_expl IN VARCHAR2
5805: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
5798: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5799: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5800: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5801: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5802: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5803: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5804: ,p_call_from_bom_expl IN VARCHAR2
5805: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
5806: ,x_return_status OUT NOCOPY VARCHAR2
5799: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5800: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5801: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5802: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5803: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5804: ,p_call_from_bom_expl IN VARCHAR2
5805: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
5806: ,x_return_status OUT NOCOPY VARCHAR2
5807: ,x_msg_count OUT NOCOPY NUMBER
5801: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5802: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5803: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5804: ,p_call_from_bom_expl IN VARCHAR2
5805: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
5806: ,x_return_status OUT NOCOPY VARCHAR2
5807: ,x_msg_count OUT NOCOPY NUMBER
5808: ,x_msg_data OUT NOCOPY VARCHAR2
5809: )
5821: l_account_id NUMBER;
5822: l_party_id NUMBER;
5823: l_party_src_tbl VARCHAR2(30);
5824: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5825: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5826: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5827: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5822: l_party_id NUMBER;
5823: l_party_src_tbl VARCHAR2(30);
5824: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5825: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5826: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5827: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5823: l_party_src_tbl VARCHAR2(30);
5824: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5825: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5826: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5827: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5824: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5825: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5826: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5827: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5832: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5826: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5827: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5832: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5833: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5827: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5832: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5833: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5834: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5832: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5833: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5834: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5835: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5832: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5833: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5834: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5835: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5836: l_build_ctr NUMBER := 0;
5829: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5832: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5833: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5834: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5835: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5836: l_build_ctr NUMBER := 0;
5837: l_party_count NUMBER;
5830: l_build_party_tbl csi_datastructures_pub.party_tbl;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5832: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5833: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5834: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5835: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5836: l_build_ctr NUMBER := 0;
5837: l_party_count NUMBER;
5838: l_account_count NUMBER;
5831: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5832: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5833: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5834: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5835: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5836: l_build_ctr NUMBER := 0;
5837: l_party_count NUMBER;
5838: l_account_count NUMBER;
5839: l_org_count NUMBER;
5857: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5858: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
5859: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
5860: l_acct_id_tbl csi_party_relationships_pvt.acct_id_tbl;
5861: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
5862: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
5863: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5864: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
5865: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
5870: l_asset_count_rec csi_asset_pvt.asset_count_rec;
5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5873: --
5874: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5875: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5876: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5877: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5871: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5873: --
5874: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5875: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5876: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5877: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5872: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5873: --
5874: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5875: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5876: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5877: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5880: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5873: --
5874: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5875: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5876: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5877: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5880: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5881: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5874: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5875: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5876: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5877: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5880: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5881: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5882: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5875: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5876: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5877: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5880: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5881: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5882: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5883: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5876: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5877: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5880: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5881: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5882: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5883: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5877: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5880: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5881: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5882: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5883: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5885: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5878: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5880: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5881: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5882: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5883: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5885: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5886: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5879: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5880: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5881: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5882: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5883: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5885: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5886: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5887: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5881: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5882: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5883: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5885: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5886: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5887: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5888: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5889: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5882: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5883: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5885: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5886: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5887: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5888: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5889: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5890: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5883: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5885: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5886: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5887: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5888: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5889: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5890: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5891: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5884: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5885: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5886: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5887: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5888: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5889: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5890: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5891: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5892: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5885: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5886: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5887: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5888: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5889: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5890: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5891: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5892: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5893: --
5886: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5887: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5888: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5889: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5890: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5891: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5892: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5893: --
5894: l_bulk_inst_count NUMBER := 0;
5887: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5888: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5889: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5890: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5891: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5892: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5893: --
5894: l_bulk_inst_count NUMBER := 0;
5895: l_bulk_pty_count NUMBER := 0;
5888: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5889: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5890: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5891: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5892: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5893: --
5894: l_bulk_inst_count NUMBER := 0;
5895: l_bulk_pty_count NUMBER := 0;
5896: l_bulk_acct_count NUMBER := 0;
6062: -- Create an item instance after validating all the instance attributes.
6063: -- API also validates that exactly one owner is being created for the
6064: -- item instance
6065: -- Grab the internal party id from csi_installed paramters
6066: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6067: csi_gen_utility_pvt.populate_install_param_rec;
6068: END IF;
6069: --
6070: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6066: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6067: csi_gen_utility_pvt.populate_install_param_rec;
6068: END IF;
6069: --
6070: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6071: --
6072: IF l_internal_party_id IS NULL THEN
6073: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
6074: FND_MSG_PUB.ADD;
8232: p_api_version IN NUMBER
8233: ,p_commit IN VARCHAR2
8234: ,p_init_msg_list IN VARCHAR2
8235: ,p_validation_level IN NUMBER
8236: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
8237: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
8238: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
8239: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8233: ,p_commit IN VARCHAR2
8234: ,p_init_msg_list IN VARCHAR2
8235: ,p_validation_level IN NUMBER
8236: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
8237: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
8238: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
8239: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8234: ,p_init_msg_list IN VARCHAR2
8235: ,p_validation_level IN NUMBER
8236: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
8237: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
8238: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
8239: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8242: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
8235: ,p_validation_level IN NUMBER
8236: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
8237: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
8238: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
8239: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8242: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
8243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
8236: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
8237: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
8238: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
8239: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8242: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
8243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
8244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
8237: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
8238: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
8239: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8242: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
8243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
8244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
8245: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
8238: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
8239: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8242: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
8243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
8244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
8245: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
8246: ,x_return_status OUT NOCOPY VARCHAR2
8239: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8242: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
8243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
8244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
8245: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
8246: ,x_return_status OUT NOCOPY VARCHAR2
8247: ,x_msg_count OUT NOCOPY NUMBER
8240: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8242: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
8243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
8244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
8245: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
8246: ,x_return_status OUT NOCOPY VARCHAR2
8247: ,x_msg_count OUT NOCOPY NUMBER
8248: ,x_msg_data OUT NOCOPY VARCHAR2
8241: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
8242: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
8243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
8244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
8245: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
8246: ,x_return_status OUT NOCOPY VARCHAR2
8247: ,x_msg_count OUT NOCOPY NUMBER
8248: ,x_msg_data OUT NOCOPY VARCHAR2
8249: )
8251: IS
8252: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
8253: l_api_version CONSTANT NUMBER := 1.0;
8254: l_debug_level NUMBER;
8255: l_new_instance_rec csi_datastructures_pub.instance_rec;
8256: l_temp_instance_rec csi_datastructures_pub.instance_rec;
8257: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
8258: l_version_label_rec csi_datastructures_pub.version_label_rec;
8259: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
8252: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
8253: l_api_version CONSTANT NUMBER := 1.0;
8254: l_debug_level NUMBER;
8255: l_new_instance_rec csi_datastructures_pub.instance_rec;
8256: l_temp_instance_rec csi_datastructures_pub.instance_rec;
8257: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
8258: l_version_label_rec csi_datastructures_pub.version_label_rec;
8259: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
8260: l_msg_count NUMBER;
8253: l_api_version CONSTANT NUMBER := 1.0;
8254: l_debug_level NUMBER;
8255: l_new_instance_rec csi_datastructures_pub.instance_rec;
8256: l_temp_instance_rec csi_datastructures_pub.instance_rec;
8257: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
8258: l_version_label_rec csi_datastructures_pub.version_label_rec;
8259: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
8260: l_msg_count NUMBER;
8261: l_msg_data VARCHAR2(2000);
8254: l_debug_level NUMBER;
8255: l_new_instance_rec csi_datastructures_pub.instance_rec;
8256: l_temp_instance_rec csi_datastructures_pub.instance_rec;
8257: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
8258: l_version_label_rec csi_datastructures_pub.version_label_rec;
8259: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
8260: l_msg_count NUMBER;
8261: l_msg_data VARCHAR2(2000);
8262: l_msg_index NUMBER;
8255: l_new_instance_rec csi_datastructures_pub.instance_rec;
8256: l_temp_instance_rec csi_datastructures_pub.instance_rec;
8257: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
8258: l_version_label_rec csi_datastructures_pub.version_label_rec;
8259: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
8260: l_msg_count NUMBER;
8261: l_msg_data VARCHAR2(2000);
8262: l_msg_index NUMBER;
8263: l_line_count NUMBER;
8458: WHERE instance_id = p_ins_id;
8459: l_old_ins_csr old_ins_csr%ROWTYPE;
8460: --
8461: l_iface_error_text VARCHAR2(2000);
8462: l_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
8463: l_grp_error_count NUMBER := 0;
8464: l_order_line_id NUMBER;
8465: --
8466: l_owner_party_tbl csi_datastructures_pub.party_tbl;
8462: l_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
8463: l_grp_error_count NUMBER := 0;
8464: l_order_line_id NUMBER;
8465: --
8466: l_owner_party_tbl csi_datastructures_pub.party_tbl;
8467: l_party_tbl csi_datastructures_pub.party_tbl;
8468: l_contact_party_tbl csi_datastructures_pub.party_tbl;
8469: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
8470: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
8463: l_grp_error_count NUMBER := 0;
8464: l_order_line_id NUMBER;
8465: --
8466: l_owner_party_tbl csi_datastructures_pub.party_tbl;
8467: l_party_tbl csi_datastructures_pub.party_tbl;
8468: l_contact_party_tbl csi_datastructures_pub.party_tbl;
8469: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
8470: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
8471: --
8464: l_order_line_id NUMBER;
8465: --
8466: l_owner_party_tbl csi_datastructures_pub.party_tbl;
8467: l_party_tbl csi_datastructures_pub.party_tbl;
8468: l_contact_party_tbl csi_datastructures_pub.party_tbl;
8469: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
8470: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
8471: --
8472: l_upd_party_tbl csi_datastructures_pub.party_tbl;
8465: --
8466: l_owner_party_tbl csi_datastructures_pub.party_tbl;
8467: l_party_tbl csi_datastructures_pub.party_tbl;
8468: l_contact_party_tbl csi_datastructures_pub.party_tbl;
8469: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
8470: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
8471: --
8472: l_upd_party_tbl csi_datastructures_pub.party_tbl;
8473: l_upd_acct_tbl csi_datastructures_pub.party_account_tbl;
8466: l_owner_party_tbl csi_datastructures_pub.party_tbl;
8467: l_party_tbl csi_datastructures_pub.party_tbl;
8468: l_contact_party_tbl csi_datastructures_pub.party_tbl;
8469: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
8470: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
8471: --
8472: l_upd_party_tbl csi_datastructures_pub.party_tbl;
8473: l_upd_acct_tbl csi_datastructures_pub.party_account_tbl;
8474: l_upd_count NUMBER := 0;
8468: l_contact_party_tbl csi_datastructures_pub.party_tbl;
8469: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
8470: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
8471: --
8472: l_upd_party_tbl csi_datastructures_pub.party_tbl;
8473: l_upd_acct_tbl csi_datastructures_pub.party_account_tbl;
8474: l_upd_count NUMBER := 0;
8475: --
8476: l_owner_count NUMBER := 0;
8469: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
8470: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
8471: --
8472: l_upd_party_tbl csi_datastructures_pub.party_tbl;
8473: l_upd_acct_tbl csi_datastructures_pub.party_account_tbl;
8474: l_upd_count NUMBER := 0;
8475: --
8476: l_owner_count NUMBER := 0;
8477: l_party_count NUMBER := 0;
8548: -- Check for the profile option and enable trace
8549: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
8550: -- End enable trace
8551: ****/
8552: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8553: csi_gen_utility_pvt.populate_install_param_rec;
8554: END IF;
8555: --
8556: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8552: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8553: csi_gen_utility_pvt.populate_install_param_rec;
8554: END IF;
8555: --
8556: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8557: --
8558: IF l_internal_party_id IS NULL THEN
8559: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
8560: FND_MSG_PUB.ADD;
9792: p_api_version IN NUMBER
9793: ,p_commit IN VARCHAR2
9794: ,p_init_msg_list IN VARCHAR2
9795: ,p_validation_level IN NUMBER
9796: ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
9797: ,p_expire_children IN VARCHAR2
9798: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9799: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
9800: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
9794: ,p_init_msg_list IN VARCHAR2
9795: ,p_validation_level IN NUMBER
9796: ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
9797: ,p_expire_children IN VARCHAR2
9798: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9799: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
9800: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
9801: ,x_return_status OUT NOCOPY VARCHAR2
9802: ,x_msg_count OUT NOCOPY NUMBER
9795: ,p_validation_level IN NUMBER
9796: ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
9797: ,p_expire_children IN VARCHAR2
9798: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9799: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
9800: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
9801: ,x_return_status OUT NOCOPY VARCHAR2
9802: ,x_msg_count OUT NOCOPY NUMBER
9803: ,x_msg_data OUT NOCOPY VARCHAR2
9796: ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
9797: ,p_expire_children IN VARCHAR2
9798: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9799: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
9800: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
9801: ,x_return_status OUT NOCOPY VARCHAR2
9802: ,x_msg_count OUT NOCOPY NUMBER
9803: ,x_msg_data OUT NOCOPY VARCHAR2
9804: )
9809: l_flag VARCHAR2(1);
9810: l_msg_index NUMBER;
9811: l_msg_count NUMBER;
9812: l_iface_error_text VARCHAR2(2000);
9813: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
9814: l_instance_rec csi_datastructures_pub.instance_rec;
9815: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
9816: l_batch_type VARCHAR2(50);
9817: l_batch_id NUMBER;
9810: l_msg_index NUMBER;
9811: l_msg_count NUMBER;
9812: l_iface_error_text VARCHAR2(2000);
9813: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
9814: l_instance_rec csi_datastructures_pub.instance_rec;
9815: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
9816: l_batch_type VARCHAR2(50);
9817: l_batch_id NUMBER;
9818: --
10037: p_commit IN VARCHAR2,
10038: p_init_msg_list IN VARCHAR2,
10039: p_validation_level IN NUMBER,
10040: p_subject_id IN NUMBER,
10041: x_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
10042: x_return_status OUT NOCOPY VARCHAR2,
10043: x_msg_count OUT NOCOPY NUMBER,
10044: x_msg_data OUT NOCOPY VARCHAR2
10045: ) IS
10156: END Get_All_Parents;
10157: --
10158: PROCEDURE Get_And_Build_Instance_Details
10159: (p_instance_id IN NUMBER
10160: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10161: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
10162: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
10163: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
10164: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
10157: --
10158: PROCEDURE Get_And_Build_Instance_Details
10159: (p_instance_id IN NUMBER
10160: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10161: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
10162: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
10163: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
10164: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
10165: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
10158: PROCEDURE Get_And_Build_Instance_Details
10159: (p_instance_id IN NUMBER
10160: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10161: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
10162: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
10163: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
10164: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
10165: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
10166: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
10159: (p_instance_id IN NUMBER
10160: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10161: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
10162: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
10163: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
10164: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
10165: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
10166: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
10167: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
10160: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10161: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
10162: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
10163: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
10164: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
10165: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
10166: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
10167: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
10168: ,x_return_status OUT NOCOPY VARCHAR2
10161: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
10162: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
10163: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
10164: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
10165: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
10166: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
10167: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
10168: ,x_return_status OUT NOCOPY VARCHAR2
10169: ,x_msg_count OUT NOCOPY NUMBER
10162: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
10163: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
10164: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
10165: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
10166: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
10167: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
10168: ,x_return_status OUT NOCOPY VARCHAR2
10169: ,x_msg_count OUT NOCOPY NUMBER
10170: ,x_msg_data OUT NOCOPY VARCHAR2
10163: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
10164: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
10165: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
10166: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
10167: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
10168: ,x_return_status OUT NOCOPY VARCHAR2
10169: ,x_msg_count OUT NOCOPY NUMBER
10170: ,x_msg_data OUT NOCOPY VARCHAR2
10171: ) IS
10170: ,x_msg_data OUT NOCOPY VARCHAR2
10171: ) IS
10172: --
10173: l_api_name VARCHAR2(30) := 'Get_And_Build_Instance_Details';
10174: l_instance_rec csi_datastructures_pub.instance_header_rec;
10175: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
10176: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
10177: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10171: ) IS
10172: --
10173: l_api_name VARCHAR2(30) := 'Get_And_Build_Instance_Details';
10174: l_instance_rec csi_datastructures_pub.instance_header_rec;
10175: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
10176: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
10177: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10179: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
10172: --
10173: l_api_name VARCHAR2(30) := 'Get_And_Build_Instance_Details';
10174: l_instance_rec csi_datastructures_pub.instance_header_rec;
10175: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
10176: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
10177: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10179: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
10180: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
10173: l_api_name VARCHAR2(30) := 'Get_And_Build_Instance_Details';
10174: l_instance_rec csi_datastructures_pub.instance_header_rec;
10175: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
10176: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
10177: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10179: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
10180: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
10181: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
10174: l_instance_rec csi_datastructures_pub.instance_header_rec;
10175: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
10176: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
10177: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10179: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
10180: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
10181: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
10182: l_party_tbl csi_datastructures_pub.party_tbl;
10175: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
10176: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
10177: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10179: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
10180: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
10181: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
10182: l_party_tbl csi_datastructures_pub.party_tbl;
10183: --
10176: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
10177: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10179: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
10180: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
10181: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
10182: l_party_tbl csi_datastructures_pub.party_tbl;
10183: --
10184: l_ctr NUMBER;
10177: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10179: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
10180: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
10181: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
10182: l_party_tbl csi_datastructures_pub.party_tbl;
10183: --
10184: l_ctr NUMBER;
10185: l_found BOOLEAN;
10178: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
10179: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
10180: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
10181: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
10182: l_party_tbl csi_datastructures_pub.party_tbl;
10183: --
10184: l_ctr NUMBER;
10185: l_found BOOLEAN;
10186: l_msg_index NUMBER;
10609: p_api_version IN NUMBER
10610: ,p_commit IN VARCHAR2
10611: ,p_init_msg_list IN VARCHAR2
10612: ,p_validation_level IN NUMBER
10613: ,p_source_instance_tbl IN csi_datastructures_pub.instance_tbl
10614: ,p_explosion_level IN NUMBER
10615: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10616: ,x_return_status OUT NOCOPY VARCHAR2
10617: ,x_msg_count OUT NOCOPY NUMBER
10611: ,p_init_msg_list IN VARCHAR2
10612: ,p_validation_level IN NUMBER
10613: ,p_source_instance_tbl IN csi_datastructures_pub.instance_tbl
10614: ,p_explosion_level IN NUMBER
10615: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10616: ,x_return_status OUT NOCOPY VARCHAR2
10617: ,x_msg_count OUT NOCOPY NUMBER
10618: ,x_msg_data OUT NOCOPY VARCHAR2
10619: )
10623: l_api_version CONSTANT NUMBER := 1.0;
10624: l_debug_level NUMBER;
10625: l_msg_index NUMBER;
10626: l_msg_count NUMBER;
10627: x_ins_tbl csi_datastructures_pub.instance_tbl;
10628: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10629: l_ins_tbl csi_datastructures_pub.instance_tbl;
10630: l_rel_ctr NUMBER := 0;
10631: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10624: l_debug_level NUMBER;
10625: l_msg_index NUMBER;
10626: l_msg_count NUMBER;
10627: x_ins_tbl csi_datastructures_pub.instance_tbl;
10628: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10629: l_ins_tbl csi_datastructures_pub.instance_tbl;
10630: l_rel_ctr NUMBER := 0;
10631: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10632: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10625: l_msg_index NUMBER;
10626: l_msg_count NUMBER;
10627: x_ins_tbl csi_datastructures_pub.instance_tbl;
10628: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10629: l_ins_tbl csi_datastructures_pub.instance_tbl;
10630: l_rel_ctr NUMBER := 0;
10631: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10632: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10633: p_instance_rec csi_datastructures_pub.instance_rec;
10627: x_ins_tbl csi_datastructures_pub.instance_tbl;
10628: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10629: l_ins_tbl csi_datastructures_pub.instance_tbl;
10630: l_rel_ctr NUMBER := 0;
10631: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10632: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10633: p_instance_rec csi_datastructures_pub.instance_rec;
10634: l_prev_item NUMBER := -9999;
10635: x_msg_index_out NUMBER;
10628: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10629: l_ins_tbl csi_datastructures_pub.instance_tbl;
10630: l_rel_ctr NUMBER := 0;
10631: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10632: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10633: p_instance_rec csi_datastructures_pub.instance_rec;
10634: l_prev_item NUMBER := -9999;
10635: x_msg_index_out NUMBER;
10636: --
10629: l_ins_tbl csi_datastructures_pub.instance_tbl;
10630: l_rel_ctr NUMBER := 0;
10631: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10632: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10633: p_instance_rec csi_datastructures_pub.instance_rec;
10634: l_prev_item NUMBER := -9999;
10635: x_msg_index_out NUMBER;
10636: --
10637: p_party_tbl csi_datastructures_pub.party_tbl;
10633: p_instance_rec csi_datastructures_pub.instance_rec;
10634: l_prev_item NUMBER := -9999;
10635: x_msg_index_out NUMBER;
10636: --
10637: p_party_tbl csi_datastructures_pub.party_tbl;
10638: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10639: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10640: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10641: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10634: l_prev_item NUMBER := -9999;
10635: x_msg_index_out NUMBER;
10636: --
10637: p_party_tbl csi_datastructures_pub.party_tbl;
10638: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10639: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10640: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10641: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10642: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10635: x_msg_index_out NUMBER;
10636: --
10637: p_party_tbl csi_datastructures_pub.party_tbl;
10638: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10639: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10640: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10641: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10642: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10643: l_version_label VARCHAR2(240);
10636: --
10637: p_party_tbl csi_datastructures_pub.party_tbl;
10638: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10639: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10640: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10641: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10642: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10643: l_version_label VARCHAR2(240);
10644: l_ver_label_desc VARCHAR2(240);
10637: p_party_tbl csi_datastructures_pub.party_tbl;
10638: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10639: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10640: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10641: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10642: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10643: l_version_label VARCHAR2(240);
10644: l_ver_label_desc VARCHAR2(240);
10645: --
10638: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10639: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10640: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10641: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10642: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10643: l_version_label VARCHAR2(240);
10644: l_ver_label_desc VARCHAR2(240);
10645: --
10646: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10642: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10643: l_version_label VARCHAR2(240);
10644: l_ver_label_desc VARCHAR2(240);
10645: --
10646: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10647: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10648: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10649: l_grp_ctr NUMBER := 0;
10650: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10643: l_version_label VARCHAR2(240);
10644: l_ver_label_desc VARCHAR2(240);
10645: --
10646: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10647: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10648: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10649: l_grp_ctr NUMBER := 0;
10650: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10651: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10644: l_ver_label_desc VARCHAR2(240);
10645: --
10646: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10647: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10648: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10649: l_grp_ctr NUMBER := 0;
10650: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10651: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10652: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10646: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10647: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10648: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10649: l_grp_ctr NUMBER := 0;
10650: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10651: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10652: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10653: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10654: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10647: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10648: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10649: l_grp_ctr NUMBER := 0;
10650: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10651: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10652: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10653: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10654: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10655: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10648: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10649: l_grp_ctr NUMBER := 0;
10650: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10651: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10652: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10653: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10654: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10655: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10656: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10649: l_grp_ctr NUMBER := 0;
10650: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10651: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10652: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10653: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10654: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10655: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10656: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10657: l_party_ctr NUMBER;
10650: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10651: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10652: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10653: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10654: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10655: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10656: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10657: l_party_ctr NUMBER;
10658: l_ctr NUMBER;
10651: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10652: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10653: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10654: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10655: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10656: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10657: l_party_ctr NUMBER;
10658: l_ctr NUMBER;
10659: l_bom_expl_org_flag VARCHAR2(3);
10652: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10653: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10654: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10655: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10656: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10657: l_party_ctr NUMBER;
10658: l_ctr NUMBER;
10659: l_bom_expl_org_flag VARCHAR2(3);
10660: --
11087: ,p_commit IN VARCHAR2 := fnd_api.g_false
11088: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
11089: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
11090: ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
11091: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
11092: ,x_return_status OUT NOCOPY VARCHAR2
11093: ,x_msg_count OUT NOCOPY NUMBER
11094: ,x_msg_data OUT NOCOPY VARCHAR2
11095: )
11214: ,p_commit IN VARCHAR2
11215: ,p_init_msg_list IN VARCHAR2
11216: ,p_validation_level IN NUMBER
11217: ,p_config_tbl IN csi_cz_int.config_tbl
11218: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
11219: ,x_return_status OUT NOCOPY VARCHAR2
11220: ,x_msg_count OUT NOCOPY NUMBER
11221: ,x_msg_data OUT NOCOPY VARCHAR2
11222: )