[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: ) RETURN BOOLEAN IS
108: --
109: l_serial_type NUMBER;
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: ) RETURN BOOLEAN IS
108: --
109: l_serial_type NUMBER;
110: l_temp VARCHAR2(1);
288: END Valid_Serial_Number;
289: --
290: FUNCTION Check_Inst_Party_Rules
291: (
292: p_party_tbl IN csi_datastructures_pub.party_tbl
293: ,p_party_rec IN csi_datastructures_pub.party_rec
294: ,p_start_date IN DATE -- Instance start date
295: ,p_end_date IN DATE -- Instance end date
296: ) RETURN BOOLEAN IS
289: --
290: FUNCTION Check_Inst_Party_Rules
291: (
292: p_party_tbl IN csi_datastructures_pub.party_tbl
293: ,p_party_rec IN csi_datastructures_pub.party_rec
294: ,p_start_date IN DATE -- Instance start date
295: ,p_end_date IN DATE -- Instance end date
296: ) RETURN BOOLEAN IS
297: --
294: ,p_start_date IN DATE -- Instance start date
295: ,p_end_date IN DATE -- Instance end date
296: ) RETURN BOOLEAN IS
297: --
298: l_party_rec csi_datastructures_pub.party_rec := p_party_rec;
299: l_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
300: l_count NUMBER := 0;
301: l_primary_pty_count NUMBER := 0;
302: l_primary_con_count NUMBER := 0;
295: ,p_end_date IN DATE -- Instance end date
296: ) RETURN BOOLEAN IS
297: --
298: l_party_rec csi_datastructures_pub.party_rec := p_party_rec;
299: l_party_tbl csi_datastructures_pub.party_tbl := p_party_tbl;
300: l_count NUMBER := 0;
301: l_primary_pty_count NUMBER := 0;
302: l_primary_con_count NUMBER := 0;
303: l_return_status BOOLEAN;
430: END Check_Inst_Party_Rules;
431: --
432: FUNCTION Check_Party_Acct_Rules
433: (
434: p_account_tbl IN csi_datastructures_pub.party_account_tbl
435: ,p_account_rec IN csi_datastructures_pub.party_account_rec
436: ,p_pty_src_table IN VARCHAR2
437: ,p_party_id IN NUMBER
438: ,p_acct_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_id_tbl
431: --
432: FUNCTION Check_Party_Acct_Rules
433: (
434: p_account_tbl IN csi_datastructures_pub.party_account_tbl
435: ,p_account_rec IN csi_datastructures_pub.party_account_rec
436: ,p_pty_src_table IN VARCHAR2
437: ,p_party_id IN NUMBER
438: ,p_acct_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_id_tbl
439: ,p_start_date IN DATE -- Instance Party Start Date
591: RETURN l_return_status;
592: END Check_Party_Acct_Rules;
593: --
594: FUNCTION Check_Org_Rules
595: ( p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
596: ,p_org_units_rec IN csi_datastructures_pub.organization_units_rec
597: ,p_start_date IN DATE
598: ,p_end_date IN DATE
599: ) RETURN BOOLEAN IS
592: END Check_Party_Acct_Rules;
593: --
594: FUNCTION Check_Org_Rules
595: ( p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
596: ,p_org_units_rec IN csi_datastructures_pub.organization_units_rec
597: ,p_start_date IN DATE
598: ,p_end_date IN DATE
599: ) RETURN BOOLEAN IS
600: --
655: END Check_Org_Rules;
656: --
657: FUNCTION Check_Pricing_Rules
658: (
659: p_pricing_rec IN csi_datastructures_pub.pricing_attribs_rec
660: ,p_start_date IN DATE
661: ,p_end_date IN DATE
662: ) RETURN BOOLEAN IS
663: --
698: END Check_Pricing_Rules;
699: --
700: FUNCTION Check_Ext_Rules
701: (
702: p_ext_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
703: ,p_ext_rec IN csi_datastructures_pub.extend_attrib_values_rec
704: ,p_start_date IN DATE
705: ,p_end_date IN DATE
706: ) RETURN BOOLEAN IS
699: --
700: FUNCTION Check_Ext_Rules
701: (
702: p_ext_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
703: ,p_ext_rec IN csi_datastructures_pub.extend_attrib_values_rec
704: ,p_start_date IN DATE
705: ,p_end_date IN DATE
706: ) RETURN BOOLEAN IS
707: --
762: END Check_Ext_Rules;
763: --
764: FUNCTION Check_Asset_Rules
765: (
766: p_asset_rec IN csi_datastructures_pub.instance_asset_rec
767: ,p_start_date IN DATE
768: ,p_end_date IN DATE
769: ) RETURN BOOLEAN IS
770: --
805: END Check_Asset_Rules;
806: --
807: PROCEDURE Build_Instance_History
808: (
809: p_inst_hist_tbl IN OUT NOCOPY csi_datastructures_pub.instance_history_tbl
810: ,p_inst_rec IN csi_datastructures_pub.instance_rec
811: ,p_txn_id IN NUMBER
812: ) IS
813: --
806: --
807: PROCEDURE Build_Instance_History
808: (
809: p_inst_hist_tbl IN OUT NOCOPY csi_datastructures_pub.instance_history_tbl
810: ,p_inst_rec IN csi_datastructures_pub.instance_rec
811: ,p_txn_id IN NUMBER
812: ) IS
813: --
814: l_count NUMBER;
1019: END Build_Instance_History;
1020: --
1021: PROCEDURE Build_Ver_Label_History
1022: (
1023: p_ver_label_history_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1024: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
1025: ,p_txn_id IN NUMBER
1026: ) IS
1027: --
1020: --
1021: PROCEDURE Build_Ver_Label_History
1022: (
1023: p_ver_label_history_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
1024: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
1025: ,p_txn_id IN NUMBER
1026: ) IS
1027: --
1028: l_count NUMBER;
1080: p_ver_label_history_tbl(l_count).NEW_ATTRIBUTE15 := p_version_label_rec.ATTRIBUTE15;
1081: END Build_Ver_Label_History;
1082: --
1083: PROCEDURE Build_Party_History
1084: ( p_party_hist_tbl IN OUT NOCOPY csi_datastructures_pub.party_history_tbl
1085: ,p_party_rec IN csi_datastructures_pub.party_rec
1086: ,p_txn_id IN NUMBER
1087: ) IS
1088: l_count NUMBER;
1081: END Build_Ver_Label_History;
1082: --
1083: PROCEDURE Build_Party_History
1084: ( p_party_hist_tbl IN OUT NOCOPY csi_datastructures_pub.party_history_tbl
1085: ,p_party_rec IN csi_datastructures_pub.party_rec
1086: ,p_txn_id IN NUMBER
1087: ) IS
1088: l_count NUMBER;
1089: l_hist_id NUMBER;
1148: p_party_hist_tbl(l_count).NEW_PREFERRED_FLAG := p_party_rec.PREFERRED_FLAG;
1149: END Build_Party_History;
1150: --
1151: PROCEDURE Build_Account_History
1152: ( p_acct_hist_tbl IN OUT NOCOPY csi_datastructures_pub.account_history_tbl
1153: ,p_acct_rec IN csi_datastructures_pub.party_account_rec
1154: ,p_txn_id IN NUMBER
1155: ) IS
1156: --
1149: END Build_Party_History;
1150: --
1151: PROCEDURE Build_Account_History
1152: ( p_acct_hist_tbl IN OUT NOCOPY csi_datastructures_pub.account_history_tbl
1153: ,p_acct_rec IN csi_datastructures_pub.party_account_rec
1154: ,p_txn_id IN NUMBER
1155: ) IS
1156: --
1157: l_count NUMBER;
1212: END Build_Account_History;
1213: --
1214: PROCEDURE Build_Org_History
1215: (
1216: p_org_hist_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1217: ,p_org_rec IN csi_datastructures_pub.organization_units_rec
1218: ,p_txn_id IN NUMBER
1219: ) IS
1220: --
1213: --
1214: PROCEDURE Build_Org_History
1215: (
1216: p_org_hist_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
1217: ,p_org_rec IN csi_datastructures_pub.organization_units_rec
1218: ,p_txn_id IN NUMBER
1219: ) IS
1220: --
1221: l_count NUMBER;
1272: END Build_Org_History;
1273: --
1274: PROCEDURE Build_Pricing_History
1275: (
1276: p_pricing_hist_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_history_tbl
1277: ,p_pricing_rec IN csi_datastructures_pub.pricing_attribs_rec
1278: ,p_txn_id IN NUMBER
1279: ) IS
1280: --
1273: --
1274: PROCEDURE Build_Pricing_History
1275: (
1276: p_pricing_hist_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_history_tbl
1277: ,p_pricing_rec IN csi_datastructures_pub.pricing_attribs_rec
1278: ,p_txn_id IN NUMBER
1279: ) IS
1280: --
1281: l_count NUMBER;
1530: END Build_Pricing_History;
1531: --
1532: PROCEDURE Build_Ext_Attr_History
1533: (
1534: p_ext_attr_hist_tbl IN OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1535: ,p_ext_attr_rec IN csi_datastructures_pub.extend_attrib_values_rec
1536: ,p_txn_id IN NUMBER
1537: ) IS
1538: --
1531: --
1532: PROCEDURE Build_Ext_Attr_History
1533: (
1534: p_ext_attr_hist_tbl IN OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
1535: ,p_ext_attr_rec IN csi_datastructures_pub.extend_attrib_values_rec
1536: ,p_txn_id IN NUMBER
1537: ) IS
1538: --
1539: l_count NUMBER;
1590: END Build_Ext_Attr_History;
1591: --
1592: PROCEDURE Build_Asset_History
1593: (
1594: p_asset_hist_tbl IN OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1595: ,p_asset_rec IN csi_datastructures_pub.instance_asset_rec
1596: ,p_txn_id IN NUMBER
1597: ) IS
1598: --
1591: --
1592: PROCEDURE Build_Asset_History
1593: (
1594: p_asset_hist_tbl IN OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
1595: ,p_asset_rec IN csi_datastructures_pub.instance_asset_rec
1596: ,p_txn_id IN NUMBER
1597: ) IS
1598: --
1599: l_count NUMBER;
1627: END Build_Asset_History;
1628: --
1629: PROCEDURE Build_Inst_Rec_of_Table
1630: (
1631: p_inst_tbl IN csi_datastructures_pub.instance_tbl
1632: ,p_inst_rec_tab IN OUT NOCOPY csi_item_instance_grp.instance_rec_tab
1633: ) IS
1634: BEGIN
1635: FOR i in p_inst_tbl.FIRST .. p_inst_tbl.LAST LOOP
1746: END LOOP;
1747: END Build_Inst_Rec_of_Table;
1748: --
1749: PROCEDURE Build_Inst_Hist_Rec_of_Table
1750: ( p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
1751: ,p_inst_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.instance_history_rec_tab
1752: ) IS
1753: BEGIN
1754: FOR i in p_inst_hist_tbl.FIRST .. p_inst_hist_tbl.LAST LOOP
2028: END Build_Inst_Hist_Rec_of_Table;
2029: --
2030: PROCEDURE Build_Ver_Label_Rec_of_Table
2031: (
2032: p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
2033: ,p_version_label_rec_tab IN OUT NOCOPY csi_item_instance_grp.version_label_rec_tab
2034: ) IS
2035: BEGIN
2036: FOR i in p_version_label_tbl.FIRST .. p_version_label_tbl.LAST LOOP
2062: END Build_Ver_Label_Rec_of_Table;
2063: --
2064: PROCEDURE Build_Ver_Lbl_Hist_Rec_Table
2065: (
2066: p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
2067: ,p_ver_label_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.ver_label_history_rec_tab
2068: ) IS
2069: BEGIN
2070: FOR i in p_ver_label_hist_tbl.FIRST .. p_ver_label_hist_tbl.LAST LOOP
2119: END LOOP;
2120: END Build_Ver_Lbl_Hist_Rec_Table;
2121: --
2122: PROCEDURE Build_Party_Rec_of_Table
2123: ( p_party_tbl IN csi_datastructures_pub.party_tbl
2124: ,p_party_rec_tab IN OUT NOCOPY csi_item_instance_grp.party_rec_tab
2125: ) IS
2126: BEGIN
2127: FOR i in p_party_tbl.FIRST .. p_party_tbl.LAST LOOP
2159: END LOOP;
2160: END Build_Party_Rec_of_Table;
2161: --
2162: PROCEDURE Build_Party_Hist_Rec_of_Table
2163: ( p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
2164: ,p_party_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.party_history_rec_tab
2165: ) IS
2166: BEGIN
2167: FOR i in p_party_hist_tbl.FIRST .. p_party_hist_tbl.LAST LOOP
2257: END Build_Party_Hist_Rec_of_Table;
2258: --
2259: PROCEDURE Build_Acct_Rec_of_Table
2260: (
2261: p_account_tbl IN csi_datastructures_pub.party_account_tbl
2262: ,p_account_rec_tab IN OUT NOCOPY csi_item_instance_grp.account_rec_tab
2263: ) IS
2264: BEGIN
2265: FOR i in p_account_tbl.FIRST .. p_account_tbl.LAST LOOP
2297: END Build_Acct_Rec_of_Table;
2298: --
2299: PROCEDURE Build_Acct_Hist_Rec_of_Table
2300: (
2301: p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
2302: ,p_acct_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.account_history_rec_tab
2303: ) IS
2304: BEGIN
2305: FOR i in p_acct_hist_tbl.FIRST .. p_acct_hist_tbl.LAST LOOP
2379: END Build_Owner_Pty_Acct_Rec_Table;
2380: --
2381: PROCEDURE Build_Txn_Rec_of_Table
2382: (
2383: p_txn_tbl IN csi_datastructures_pub.transaction_tbl
2384: ,p_txn_rec_tab IN OUT NOCOPY csi_item_instance_grp.transaction_rec_tab
2385: ) IS
2386: BEGIN
2387: FOR i in p_txn_tbl.FIRST .. p_txn_tbl.LAST LOOP
2428: END Build_Txn_Rec_of_Table;
2429: --
2430: PROCEDURE Build_Org_Rec_of_Table
2431: (
2432: p_org_tbl IN csi_datastructures_pub.organization_units_tbl
2433: ,p_org_units_rec_tab IN OUT NOCOPY csi_item_instance_grp.org_units_rec_tab
2434: ) IS
2435: BEGIN
2436: FOR i in p_org_tbl.FIRST .. p_org_tbl.LAST LOOP
2461: END LOOP;
2462: END Build_Org_Rec_of_Table;
2463: --
2464: PROCEDURE Build_Org_Hist_Rec_of_Table
2465: ( p_org_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
2466: ,p_org_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.org_units_history_rec_tab
2467: ) IS
2468: BEGIN
2469: FOR i in p_org_hist_tbl.FIRST .. p_org_hist_tbl.LAST LOOP
2520: END Build_Org_Hist_Rec_of_Table;
2521: --
2522: PROCEDURE Build_pricing_Rec_of_Table
2523: (
2524: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
2525: ,p_pricing_rec_tab IN OUT NOCOPY csi_item_instance_grp.pricing_attribs_rec_tab
2526: ) IS
2527: BEGIN
2528: FOR i in p_pricing_tbl.FIRST .. p_pricing_tbl.LAST LOOP
2652: END LOOP;
2653: END Build_pricing_Rec_of_Table;
2654: --
2655: PROCEDURE Build_pricing_Hist_Rec_Table
2656: ( p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
2657: ,p_pricing_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.pricing_attribs_hist_rec_tab
2658: ) IS
2659: BEGIN
2660: FOR i in p_pricing_hist_tbl.FIRST .. p_pricing_hist_tbl.LAST LOOP
2904: END Build_pricing_Hist_Rec_Table;
2905: --
2906: PROCEDURE Build_Ext_Attr_Rec_Table
2907: (
2908: p_ext_attr_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
2909: ,p_ext_attr_rec_tab IN OUT NOCOPY csi_item_instance_grp.extend_attrib_values_rec_tab
2910: ) IS
2911:
2912: BEGIN
2942: END Build_Ext_Attr_Rec_Table;
2943: --
2944: PROCEDURE Build_Ext_Attr_Hist_Rec_Table
2945: (
2946: p_ext_attr_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
2947: ,p_ext_attr_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.ext_attrib_val_hist_rec_tab
2948: ) IS
2949: BEGIN
2950: FOR i in p_ext_attr_hist_tbl.FIRST .. p_ext_attr_hist_tbl.LAST LOOP
2997: END Build_Ext_Attr_Hist_Rec_Table;
2998: --
2999: PROCEDURE Build_Asset_Rec_Table
3000: (
3001: p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3002: ,p_asset_rec_tab IN OUT NOCOPY csi_item_instance_grp.instance_asset_rec_tab
3003: ) IS
3004:
3005: BEGIN
3023: END Build_Asset_Rec_Table;
3024: --
3025: PROCEDURE Build_Asset_Hist_Rec_Table
3026: (
3027: p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3028: ,p_asset_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.ins_asset_history_rec_tab
3029: ) IS
3030: BEGIN
3031: FOR i in p_asset_hist_tbl.FIRST .. p_asset_hist_tbl.LAST LOOP
3087: END Build_Asset_Hist_Rec_Table;
3088: --
3089: PROCEDURE Bulk_Insert
3090: (
3091: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3092: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3093: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3094: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3088: --
3089: PROCEDURE Bulk_Insert
3090: (
3091: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3092: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3093: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3094: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3089: PROCEDURE Bulk_Insert
3090: (
3091: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3092: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3093: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3094: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3090: (
3091: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3092: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3093: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3094: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3091: p_inst_tbl IN csi_datastructures_pub.instance_tbl
3092: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3093: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3094: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3092: ,p_txn_tbl IN csi_datastructures_pub.transaction_tbl
3093: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3094: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3093: ,p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl
3094: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3094: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3095: ,p_ver_label_hist_tbl IN csi_datastructures_pub.version_label_history_tbl
3096: ,p_party_tbl IN csi_datastructures_pub.party_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3097: ,p_party_hist_tbl IN csi_datastructures_pub.party_history_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3105: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3098: ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3105: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3106: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3099: ,p_acct_hist_tbl IN csi_datastructures_pub.account_history_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3105: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3106: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3107: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3100: ,p_owner_pty_acct_tbl IN csi_item_instance_pvt.owner_pty_acct_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3105: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3106: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3107: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3108: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3101: ,p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3105: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3106: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3107: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3108: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3109: ,x_return_status OUT NOCOPY VARCHAR2
3102: ,p_org_units_hist_tbl IN csi_datastructures_pub.org_units_history_tbl
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3105: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3106: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3107: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3108: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3109: ,x_return_status OUT NOCOPY VARCHAR2
3110: ) IS
3103: ,p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3105: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3106: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3107: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3108: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3109: ,x_return_status OUT NOCOPY VARCHAR2
3110: ) IS
3111: --
3104: ,p_pricing_hist_tbl IN csi_datastructures_pub.pricing_history_tbl
3105: ,p_ext_attr_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
3106: ,p_ext_attr_val_hist_tbl IN csi_datastructures_pub.ext_attrib_val_history_tbl
3107: ,p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
3108: ,p_asset_hist_tbl IN csi_datastructures_pub.ins_asset_history_tbl
3109: ,x_return_status OUT NOCOPY VARCHAR2
3110: ) IS
3111: --
3112: l_inst_rec_tab csi_item_instance_grp.instance_rec_tab;
5789: p_api_version IN NUMBER
5790: ,p_commit IN VARCHAR2
5791: ,p_init_msg_list IN VARCHAR2
5792: ,p_validation_level IN NUMBER
5793: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5794: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5795: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5796: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5797: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5790: ,p_commit IN VARCHAR2
5791: ,p_init_msg_list IN VARCHAR2
5792: ,p_validation_level IN NUMBER
5793: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5794: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5795: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5796: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5797: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5798: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5791: ,p_init_msg_list IN VARCHAR2
5792: ,p_validation_level IN NUMBER
5793: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5794: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5795: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5796: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5797: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5798: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5799: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5792: ,p_validation_level IN NUMBER
5793: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5794: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5795: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5796: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5797: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5798: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5799: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5800: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5793: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
5794: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5795: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5796: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5797: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5798: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5799: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5800: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5801: ,p_call_from_bom_expl IN VARCHAR2
5794: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5795: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5796: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5797: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5798: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5799: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5800: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5801: ,p_call_from_bom_expl IN VARCHAR2
5802: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
5795: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5796: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5797: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5798: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5799: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5800: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5801: ,p_call_from_bom_expl IN VARCHAR2
5802: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
5803: ,x_return_status OUT NOCOPY VARCHAR2
5796: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5797: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5798: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5799: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5800: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5801: ,p_call_from_bom_expl IN VARCHAR2
5802: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
5803: ,x_return_status OUT NOCOPY VARCHAR2
5804: ,x_msg_count OUT NOCOPY NUMBER
5798: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5799: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5800: ,p_txn_tbl IN OUT NOCOPY csi_datastructures_pub.transaction_tbl
5801: ,p_call_from_bom_expl IN VARCHAR2
5802: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
5803: ,x_return_status OUT NOCOPY VARCHAR2
5804: ,x_msg_count OUT NOCOPY NUMBER
5805: ,x_msg_data OUT NOCOPY VARCHAR2
5806: )
5818: l_account_id NUMBER;
5819: l_party_id NUMBER;
5820: l_party_src_tbl VARCHAR2(30);
5821: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5822: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5823: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5824: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5819: l_party_id NUMBER;
5820: l_party_src_tbl VARCHAR2(30);
5821: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5822: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5823: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5824: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5820: l_party_src_tbl VARCHAR2(30);
5821: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5822: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5823: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5824: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5821: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5822: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5823: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5824: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5829: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5822: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5823: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5824: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5829: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5830: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5823: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5824: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5829: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5830: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5831: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5824: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5829: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5830: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5831: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5832: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5829: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5830: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5831: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5832: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5833: l_build_ctr NUMBER := 0;
5826: l_temp_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5829: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5830: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5831: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5832: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5833: l_build_ctr NUMBER := 0;
5834: l_party_count NUMBER;
5827: l_build_party_tbl csi_datastructures_pub.party_tbl;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5829: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5830: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5831: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5832: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5833: l_build_ctr NUMBER := 0;
5834: l_party_count NUMBER;
5835: l_account_count NUMBER;
5828: l_build_account_tbl csi_datastructures_pub.party_account_tbl;
5829: l_build_org_tbl csi_datastructures_pub.organization_units_tbl;
5830: l_build_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5831: l_build_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5832: l_build_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5833: l_build_ctr NUMBER := 0;
5834: l_party_count NUMBER;
5835: l_account_count NUMBER;
5836: l_org_count NUMBER;
5854: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
5855: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
5856: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
5857: l_acct_id_tbl csi_party_relationships_pvt.acct_id_tbl;
5858: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
5859: l_ou_lookup_tbl csi_organization_unit_pvt.lookup_tbl;
5860: l_ou_count_rec csi_organization_unit_pvt.ou_count_rec;
5861: l_ou_id_tbl csi_organization_unit_pvt.ou_id_tbl;
5862: l_ext_id_tbl csi_item_instance_pvt.ext_id_tbl;
5867: l_asset_count_rec csi_asset_pvt.asset_count_rec;
5868: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5869: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5870: --
5871: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5872: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5873: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5874: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5868: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
5869: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5870: --
5871: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5872: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5873: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5874: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5869: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
5870: --
5871: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5872: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5873: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5874: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5870: --
5871: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5872: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5873: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5874: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5871: l_bulk_inst_tbl csi_datastructures_pub.instance_tbl;
5872: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5873: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5874: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5872: l_bulk_version_label_tbl csi_datastructures_pub.version_label_tbl;
5873: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5874: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5873: l_bulk_ver_label_hist_tbl csi_datastructures_pub.version_label_history_tbl;
5874: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5874: l_bulk_inst_hist_tbl csi_datastructures_pub.instance_history_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5875: l_bulk_party_tbl csi_datastructures_pub.party_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5876: l_bulk_party_hist_tbl csi_datastructures_pub.party_history_tbl;
5877: l_bulk_acct_tbl csi_datastructures_pub.party_account_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5878: l_bulk_acct_hist_tbl csi_datastructures_pub.account_history_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5886: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5879: l_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5886: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5887: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5880: x_bulk_txn_tbl csi_datastructures_pub.transaction_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5886: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5887: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5888: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5881: l_owner_pty_acct_tbl csi_item_instance_pvt.owner_pty_acct_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5886: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5887: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5888: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5889: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5882: l_bulk_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5886: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5887: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5888: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5889: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5890: --
5883: l_bulk_org_units_hist_tbl csi_datastructures_pub.org_units_history_tbl;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5886: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5887: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5888: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5889: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5890: --
5891: l_bulk_inst_count NUMBER := 0;
5884: l_bulk_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5886: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5887: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5888: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5889: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5890: --
5891: l_bulk_inst_count NUMBER := 0;
5892: l_bulk_pty_count NUMBER := 0;
5885: l_bulk_pricing_hist_tbl csi_datastructures_pub.pricing_history_tbl;
5886: l_bulk_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5887: l_bulk_ext_attrib_val_hist_tbl csi_datastructures_pub.ext_attrib_val_history_tbl;
5888: l_bulk_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5889: l_bulk_asset_hist_tbl csi_datastructures_pub.ins_asset_history_tbl;
5890: --
5891: l_bulk_inst_count NUMBER := 0;
5892: l_bulk_pty_count NUMBER := 0;
5893: l_bulk_acct_count NUMBER := 0;
6028: -- Create an item instance after validating all the instance attributes.
6029: -- API also validates that exactly one owner is being created for the
6030: -- item instance
6031: -- Grab the internal party id from csi_installed paramters
6032: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6033: csi_gen_utility_pvt.populate_install_param_rec;
6034: END IF;
6035: --
6036: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6032: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6033: csi_gen_utility_pvt.populate_install_param_rec;
6034: END IF;
6035: --
6036: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6037: --
6038: IF l_internal_party_id IS NULL THEN
6039: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
6040: FND_MSG_PUB.ADD;
7695: p_api_version IN NUMBER
7696: ,p_commit IN VARCHAR2
7697: ,p_init_msg_list IN VARCHAR2
7698: ,p_validation_level IN NUMBER
7699: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
7700: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
7701: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
7702: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7696: ,p_commit IN VARCHAR2
7697: ,p_init_msg_list IN VARCHAR2
7698: ,p_validation_level IN NUMBER
7699: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
7700: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
7701: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
7702: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7697: ,p_init_msg_list IN VARCHAR2
7698: ,p_validation_level IN NUMBER
7699: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
7700: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
7701: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
7702: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7705: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
7698: ,p_validation_level IN NUMBER
7699: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
7700: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
7701: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
7702: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7705: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
7706: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7699: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
7700: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
7701: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
7702: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7705: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
7706: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7707: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
7700: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
7701: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
7702: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7705: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
7706: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7707: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
7708: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
7701: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
7702: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7705: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
7706: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7707: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
7708: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
7709: ,x_return_status OUT NOCOPY VARCHAR2
7702: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7705: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
7706: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7707: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
7708: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
7709: ,x_return_status OUT NOCOPY VARCHAR2
7710: ,x_msg_count OUT NOCOPY NUMBER
7703: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7705: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
7706: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7707: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
7708: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
7709: ,x_return_status OUT NOCOPY VARCHAR2
7710: ,x_msg_count OUT NOCOPY NUMBER
7711: ,x_msg_data OUT NOCOPY VARCHAR2
7704: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
7705: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
7706: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7707: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
7708: ,p_grp_upd_error_tbl OUT NOCOPY csi_datastructures_pub.grp_upd_error_tbl
7709: ,x_return_status OUT NOCOPY VARCHAR2
7710: ,x_msg_count OUT NOCOPY NUMBER
7711: ,x_msg_data OUT NOCOPY VARCHAR2
7712: )
7714: IS
7715: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
7716: l_api_version CONSTANT NUMBER := 1.0;
7717: l_debug_level NUMBER;
7718: l_new_instance_rec csi_datastructures_pub.instance_rec;
7719: l_temp_instance_rec csi_datastructures_pub.instance_rec;
7720: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
7721: l_version_label_rec csi_datastructures_pub.version_label_rec;
7722: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
7715: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
7716: l_api_version CONSTANT NUMBER := 1.0;
7717: l_debug_level NUMBER;
7718: l_new_instance_rec csi_datastructures_pub.instance_rec;
7719: l_temp_instance_rec csi_datastructures_pub.instance_rec;
7720: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
7721: l_version_label_rec csi_datastructures_pub.version_label_rec;
7722: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
7723: l_msg_count NUMBER;
7716: l_api_version CONSTANT NUMBER := 1.0;
7717: l_debug_level NUMBER;
7718: l_new_instance_rec csi_datastructures_pub.instance_rec;
7719: l_temp_instance_rec csi_datastructures_pub.instance_rec;
7720: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
7721: l_version_label_rec csi_datastructures_pub.version_label_rec;
7722: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
7723: l_msg_count NUMBER;
7724: l_msg_data VARCHAR2(2000);
7717: l_debug_level NUMBER;
7718: l_new_instance_rec csi_datastructures_pub.instance_rec;
7719: l_temp_instance_rec csi_datastructures_pub.instance_rec;
7720: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
7721: l_version_label_rec csi_datastructures_pub.version_label_rec;
7722: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
7723: l_msg_count NUMBER;
7724: l_msg_data VARCHAR2(2000);
7725: l_msg_index NUMBER;
7718: l_new_instance_rec csi_datastructures_pub.instance_rec;
7719: l_temp_instance_rec csi_datastructures_pub.instance_rec;
7720: l_old_instance_tbl csi_datastructures_pub.instance_tbl;
7721: l_version_label_rec csi_datastructures_pub.version_label_rec;
7722: l_temp_version_label_rec csi_datastructures_pub.version_label_rec;
7723: l_msg_count NUMBER;
7724: l_msg_data VARCHAR2(2000);
7725: l_msg_index NUMBER;
7726: l_line_count NUMBER;
7921: WHERE instance_id = p_ins_id;
7922: l_old_ins_csr old_ins_csr%ROWTYPE;
7923: --
7924: l_iface_error_text VARCHAR2(2000);
7925: l_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
7926: l_grp_error_count NUMBER := 0;
7927: l_order_line_id NUMBER;
7928: --
7929: l_owner_party_tbl csi_datastructures_pub.party_tbl;
7925: l_grp_upd_error_tbl csi_datastructures_pub.grp_upd_error_tbl;
7926: l_grp_error_count NUMBER := 0;
7927: l_order_line_id NUMBER;
7928: --
7929: l_owner_party_tbl csi_datastructures_pub.party_tbl;
7930: l_party_tbl csi_datastructures_pub.party_tbl;
7931: l_contact_party_tbl csi_datastructures_pub.party_tbl;
7932: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
7933: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
7926: l_grp_error_count NUMBER := 0;
7927: l_order_line_id NUMBER;
7928: --
7929: l_owner_party_tbl csi_datastructures_pub.party_tbl;
7930: l_party_tbl csi_datastructures_pub.party_tbl;
7931: l_contact_party_tbl csi_datastructures_pub.party_tbl;
7932: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
7933: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
7934: --
7927: l_order_line_id NUMBER;
7928: --
7929: l_owner_party_tbl csi_datastructures_pub.party_tbl;
7930: l_party_tbl csi_datastructures_pub.party_tbl;
7931: l_contact_party_tbl csi_datastructures_pub.party_tbl;
7932: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
7933: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
7934: --
7935: l_upd_party_tbl csi_datastructures_pub.party_tbl;
7928: --
7929: l_owner_party_tbl csi_datastructures_pub.party_tbl;
7930: l_party_tbl csi_datastructures_pub.party_tbl;
7931: l_contact_party_tbl csi_datastructures_pub.party_tbl;
7932: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
7933: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
7934: --
7935: l_upd_party_tbl csi_datastructures_pub.party_tbl;
7936: l_upd_acct_tbl csi_datastructures_pub.party_account_tbl;
7929: l_owner_party_tbl csi_datastructures_pub.party_tbl;
7930: l_party_tbl csi_datastructures_pub.party_tbl;
7931: l_contact_party_tbl csi_datastructures_pub.party_tbl;
7932: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
7933: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
7934: --
7935: l_upd_party_tbl csi_datastructures_pub.party_tbl;
7936: l_upd_acct_tbl csi_datastructures_pub.party_account_tbl;
7937: l_upd_count NUMBER := 0;
7931: l_contact_party_tbl csi_datastructures_pub.party_tbl;
7932: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
7933: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
7934: --
7935: l_upd_party_tbl csi_datastructures_pub.party_tbl;
7936: l_upd_acct_tbl csi_datastructures_pub.party_account_tbl;
7937: l_upd_count NUMBER := 0;
7938: --
7939: l_owner_count NUMBER := 0;
7932: l_owner_acct_tbl csi_datastructures_pub.party_account_tbl;
7933: l_pty_acct_tbl csi_datastructures_pub.party_account_tbl;
7934: --
7935: l_upd_party_tbl csi_datastructures_pub.party_tbl;
7936: l_upd_acct_tbl csi_datastructures_pub.party_account_tbl;
7937: l_upd_count NUMBER := 0;
7938: --
7939: l_owner_count NUMBER := 0;
7940: l_party_count NUMBER := 0;
8011: -- Check for the profile option and enable trace
8012: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
8013: -- End enable trace
8014: ****/
8015: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8016: csi_gen_utility_pvt.populate_install_param_rec;
8017: END IF;
8018: --
8019: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8015: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8016: csi_gen_utility_pvt.populate_install_param_rec;
8017: END IF;
8018: --
8019: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8020: --
8021: IF l_internal_party_id IS NULL THEN
8022: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
8023: FND_MSG_PUB.ADD;
9237: p_api_version IN NUMBER
9238: ,p_commit IN VARCHAR2
9239: ,p_init_msg_list IN VARCHAR2
9240: ,p_validation_level IN NUMBER
9241: ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
9242: ,p_expire_children IN VARCHAR2
9243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
9245: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
9239: ,p_init_msg_list IN VARCHAR2
9240: ,p_validation_level IN NUMBER
9241: ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
9242: ,p_expire_children IN VARCHAR2
9243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
9245: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
9246: ,x_return_status OUT NOCOPY VARCHAR2
9247: ,x_msg_count OUT NOCOPY NUMBER
9240: ,p_validation_level IN NUMBER
9241: ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
9242: ,p_expire_children IN VARCHAR2
9243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
9245: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
9246: ,x_return_status OUT NOCOPY VARCHAR2
9247: ,x_msg_count OUT NOCOPY NUMBER
9248: ,x_msg_data OUT NOCOPY VARCHAR2
9241: ,p_instance_tbl IN csi_datastructures_pub.instance_tbl
9242: ,p_expire_children IN VARCHAR2
9243: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9244: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
9245: ,p_grp_error_tbl OUT NOCOPY csi_datastructures_pub.grp_error_tbl
9246: ,x_return_status OUT NOCOPY VARCHAR2
9247: ,x_msg_count OUT NOCOPY NUMBER
9248: ,x_msg_data OUT NOCOPY VARCHAR2
9249: )
9254: l_flag VARCHAR2(1);
9255: l_msg_index NUMBER;
9256: l_msg_count NUMBER;
9257: l_iface_error_text VARCHAR2(2000);
9258: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
9259: l_instance_rec csi_datastructures_pub.instance_rec;
9260: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
9261: l_batch_type VARCHAR2(50);
9262: l_batch_id NUMBER;
9255: l_msg_index NUMBER;
9256: l_msg_count NUMBER;
9257: l_iface_error_text VARCHAR2(2000);
9258: l_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
9259: l_instance_rec csi_datastructures_pub.instance_rec;
9260: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
9261: l_batch_type VARCHAR2(50);
9262: l_batch_id NUMBER;
9263: --
9482: p_commit IN VARCHAR2,
9483: p_init_msg_list IN VARCHAR2,
9484: p_validation_level IN NUMBER,
9485: p_subject_id IN NUMBER,
9486: x_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
9487: x_return_status OUT NOCOPY VARCHAR2,
9488: x_msg_count OUT NOCOPY NUMBER,
9489: x_msg_data OUT NOCOPY VARCHAR2
9490: ) IS
9601: END Get_All_Parents;
9602: --
9603: PROCEDURE Get_And_Build_Instance_Details
9604: (p_instance_id IN NUMBER
9605: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9606: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
9607: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
9608: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
9609: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
9602: --
9603: PROCEDURE Get_And_Build_Instance_Details
9604: (p_instance_id IN NUMBER
9605: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9606: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
9607: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
9608: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
9609: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
9610: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
9603: PROCEDURE Get_And_Build_Instance_Details
9604: (p_instance_id IN NUMBER
9605: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9606: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
9607: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
9608: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
9609: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
9610: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
9611: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
9604: (p_instance_id IN NUMBER
9605: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9606: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
9607: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
9608: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
9609: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
9610: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
9611: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
9612: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
9605: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
9606: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
9607: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
9608: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
9609: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
9610: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
9611: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
9612: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
9613: ,x_return_status OUT NOCOPY VARCHAR2
9606: ,p_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
9607: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
9608: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
9609: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
9610: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
9611: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
9612: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
9613: ,x_return_status OUT NOCOPY VARCHAR2
9614: ,x_msg_count OUT NOCOPY NUMBER
9607: ,p_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl
9608: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
9609: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
9610: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
9611: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
9612: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
9613: ,x_return_status OUT NOCOPY VARCHAR2
9614: ,x_msg_count OUT NOCOPY NUMBER
9615: ,x_msg_data OUT NOCOPY VARCHAR2
9608: ,p_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl
9609: ,p_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl
9610: ,p_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
9611: ,p_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
9612: ,p_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
9613: ,x_return_status OUT NOCOPY VARCHAR2
9614: ,x_msg_count OUT NOCOPY NUMBER
9615: ,x_msg_data OUT NOCOPY VARCHAR2
9616: ) IS
9615: ,x_msg_data OUT NOCOPY VARCHAR2
9616: ) IS
9617: --
9618: l_api_name VARCHAR2(30) := 'Get_And_Build_Instance_Details';
9619: l_instance_rec csi_datastructures_pub.instance_header_rec;
9620: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
9621: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
9622: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9616: ) IS
9617: --
9618: l_api_name VARCHAR2(30) := 'Get_And_Build_Instance_Details';
9619: l_instance_rec csi_datastructures_pub.instance_header_rec;
9620: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
9621: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
9622: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9624: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
9617: --
9618: l_api_name VARCHAR2(30) := 'Get_And_Build_Instance_Details';
9619: l_instance_rec csi_datastructures_pub.instance_header_rec;
9620: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
9621: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
9622: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9624: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
9625: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
9618: l_api_name VARCHAR2(30) := 'Get_And_Build_Instance_Details';
9619: l_instance_rec csi_datastructures_pub.instance_header_rec;
9620: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
9621: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
9622: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9624: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
9625: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
9626: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
9619: l_instance_rec csi_datastructures_pub.instance_header_rec;
9620: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
9621: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
9622: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9624: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
9625: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
9626: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
9627: l_party_tbl csi_datastructures_pub.party_tbl;
9620: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
9621: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
9622: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9624: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
9625: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
9626: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
9627: l_party_tbl csi_datastructures_pub.party_tbl;
9628: --
9621: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
9622: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9624: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
9625: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
9626: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
9627: l_party_tbl csi_datastructures_pub.party_tbl;
9628: --
9629: l_ctr NUMBER;
9622: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9624: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
9625: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
9626: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
9627: l_party_tbl csi_datastructures_pub.party_tbl;
9628: --
9629: l_ctr NUMBER;
9630: l_found BOOLEAN;
9623: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
9624: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
9625: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
9626: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
9627: l_party_tbl csi_datastructures_pub.party_tbl;
9628: --
9629: l_ctr NUMBER;
9630: l_found BOOLEAN;
9631: l_msg_index NUMBER;
10054: p_api_version IN NUMBER
10055: ,p_commit IN VARCHAR2
10056: ,p_init_msg_list IN VARCHAR2
10057: ,p_validation_level IN NUMBER
10058: ,p_source_instance_tbl IN csi_datastructures_pub.instance_tbl
10059: ,p_explosion_level IN NUMBER
10060: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10061: ,x_return_status OUT NOCOPY VARCHAR2
10062: ,x_msg_count OUT NOCOPY NUMBER
10056: ,p_init_msg_list IN VARCHAR2
10057: ,p_validation_level IN NUMBER
10058: ,p_source_instance_tbl IN csi_datastructures_pub.instance_tbl
10059: ,p_explosion_level IN NUMBER
10060: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10061: ,x_return_status OUT NOCOPY VARCHAR2
10062: ,x_msg_count OUT NOCOPY NUMBER
10063: ,x_msg_data OUT NOCOPY VARCHAR2
10064: )
10068: l_api_version CONSTANT NUMBER := 1.0;
10069: l_debug_level NUMBER;
10070: l_msg_index NUMBER;
10071: l_msg_count NUMBER;
10072: x_ins_tbl csi_datastructures_pub.instance_tbl;
10073: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10074: l_ins_tbl csi_datastructures_pub.instance_tbl;
10075: l_rel_ctr NUMBER := 0;
10076: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10069: l_debug_level NUMBER;
10070: l_msg_index NUMBER;
10071: l_msg_count NUMBER;
10072: x_ins_tbl csi_datastructures_pub.instance_tbl;
10073: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10074: l_ins_tbl csi_datastructures_pub.instance_tbl;
10075: l_rel_ctr NUMBER := 0;
10076: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10077: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10070: l_msg_index NUMBER;
10071: l_msg_count NUMBER;
10072: x_ins_tbl csi_datastructures_pub.instance_tbl;
10073: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10074: l_ins_tbl csi_datastructures_pub.instance_tbl;
10075: l_rel_ctr NUMBER := 0;
10076: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10077: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10078: p_instance_rec csi_datastructures_pub.instance_rec;
10072: x_ins_tbl csi_datastructures_pub.instance_tbl;
10073: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10074: l_ins_tbl csi_datastructures_pub.instance_tbl;
10075: l_rel_ctr NUMBER := 0;
10076: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10077: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10078: p_instance_rec csi_datastructures_pub.instance_rec;
10079: l_prev_item NUMBER := -9999;
10080: x_msg_index_out NUMBER;
10073: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10074: l_ins_tbl csi_datastructures_pub.instance_tbl;
10075: l_rel_ctr NUMBER := 0;
10076: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10077: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10078: p_instance_rec csi_datastructures_pub.instance_rec;
10079: l_prev_item NUMBER := -9999;
10080: x_msg_index_out NUMBER;
10081: --
10074: l_ins_tbl csi_datastructures_pub.instance_tbl;
10075: l_rel_ctr NUMBER := 0;
10076: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
10077: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10078: p_instance_rec csi_datastructures_pub.instance_rec;
10079: l_prev_item NUMBER := -9999;
10080: x_msg_index_out NUMBER;
10081: --
10082: p_party_tbl csi_datastructures_pub.party_tbl;
10078: p_instance_rec csi_datastructures_pub.instance_rec;
10079: l_prev_item NUMBER := -9999;
10080: x_msg_index_out NUMBER;
10081: --
10082: p_party_tbl csi_datastructures_pub.party_tbl;
10083: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10084: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10085: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10086: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10079: l_prev_item NUMBER := -9999;
10080: x_msg_index_out NUMBER;
10081: --
10082: p_party_tbl csi_datastructures_pub.party_tbl;
10083: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10084: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10085: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10086: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10087: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10080: x_msg_index_out NUMBER;
10081: --
10082: p_party_tbl csi_datastructures_pub.party_tbl;
10083: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10084: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10085: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10086: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10087: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10088: l_version_label VARCHAR2(240);
10081: --
10082: p_party_tbl csi_datastructures_pub.party_tbl;
10083: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10084: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10085: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10086: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10087: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10088: l_version_label VARCHAR2(240);
10089: l_ver_label_desc VARCHAR2(240);
10082: p_party_tbl csi_datastructures_pub.party_tbl;
10083: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10084: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10085: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10086: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10087: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10088: l_version_label VARCHAR2(240);
10089: l_ver_label_desc VARCHAR2(240);
10090: --
10083: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10084: p_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10085: p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10086: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10087: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10088: l_version_label VARCHAR2(240);
10089: l_ver_label_desc VARCHAR2(240);
10090: --
10091: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10087: p_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10088: l_version_label VARCHAR2(240);
10089: l_ver_label_desc VARCHAR2(240);
10090: --
10091: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10092: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10093: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10094: l_grp_ctr NUMBER := 0;
10095: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10088: l_version_label VARCHAR2(240);
10089: l_ver_label_desc VARCHAR2(240);
10090: --
10091: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10092: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10093: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10094: l_grp_ctr NUMBER := 0;
10095: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10096: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10089: l_ver_label_desc VARCHAR2(240);
10090: --
10091: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10092: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10093: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10094: l_grp_ctr NUMBER := 0;
10095: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10096: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10097: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10091: p_grp_error_tbl csi_datastructures_pub.grp_error_tbl;
10092: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10093: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10094: l_grp_ctr NUMBER := 0;
10095: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10096: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10097: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10098: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10099: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10092: p_txn_tbl csi_datastructures_pub.transaction_tbl;
10093: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10094: l_grp_ctr NUMBER := 0;
10095: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10096: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10097: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10098: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10099: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10100: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10093: l_grp_ins_tbl csi_datastructures_pub.instance_tbl;
10094: l_grp_ctr NUMBER := 0;
10095: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10096: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10097: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10098: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10099: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10100: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10101: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10094: l_grp_ctr NUMBER := 0;
10095: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10096: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10097: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10098: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10099: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10100: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10101: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10102: l_party_ctr NUMBER;
10095: l_grp_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10096: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10097: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10098: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10099: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10100: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10101: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10102: l_party_ctr NUMBER;
10103: l_ctr NUMBER;
10096: l_grp_party_tbl csi_datastructures_pub.party_tbl;
10097: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10098: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10099: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10100: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10101: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10102: l_party_ctr NUMBER;
10103: l_ctr NUMBER;
10104: --
10097: l_grp_account_tbl csi_datastructures_pub.party_account_tbl;
10098: l_grp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
10099: l_grp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
10100: l_grp_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10101: l_grp_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
10102: l_party_ctr NUMBER;
10103: l_ctr NUMBER;
10104: --
10105: BEGIN
10512: ,p_commit IN VARCHAR2 := fnd_api.g_false
10513: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
10514: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
10515: ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
10516: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10517: ,x_return_status OUT NOCOPY VARCHAR2
10518: ,x_msg_count OUT NOCOPY NUMBER
10519: ,x_msg_data OUT NOCOPY VARCHAR2
10520: )
10639: ,p_commit IN VARCHAR2
10640: ,p_init_msg_list IN VARCHAR2
10641: ,p_validation_level IN NUMBER
10642: ,p_config_tbl IN csi_cz_int.config_tbl
10643: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10644: ,x_return_status OUT NOCOPY VARCHAR2
10645: ,x_msg_count OUT NOCOPY NUMBER
10646: ,x_msg_data OUT NOCOPY VARCHAR2
10647: )