376: l_api_version CONSTANT NUMBER := 1.0;
377: l_return_status VARCHAR2(1);
378: l_msg_count NUMBER;
379: l_msg_data VARCHAR2(2000);
380: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
381: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
382: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
383: l_subject_id NUMBER;
384: l_object_id NUMBER;
377: l_return_status VARCHAR2(1);
378: l_msg_count NUMBER;
379: l_msg_data VARCHAR2(2000);
380: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
381: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
382: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
383: l_subject_id NUMBER;
384: l_object_id NUMBER;
385: l_csi_relationship_id NUMBER;
378: l_msg_count NUMBER;
379: l_msg_data VARCHAR2(2000);
380: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
381: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
382: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
383: l_subject_id NUMBER;
384: l_object_id NUMBER;
385: l_csi_relationship_id NUMBER;
386: l_object_version_number NUMBER;
707: l_api_version CONSTANT NUMBER := 1.0;
708: l_return_status VARCHAR2(1);
709: l_msg_count NUMBER;
710: l_msg_data VARCHAR2(2000);
711: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
712: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
713: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
714: l_csi_instance_rec csi_datastructures_pub.instance_rec;
715: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
708: l_return_status VARCHAR2(1);
709: l_msg_count NUMBER;
710: l_msg_data VARCHAR2(2000);
711: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
712: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
713: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
714: l_csi_instance_rec csi_datastructures_pub.instance_rec;
715: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
716: l_subject_id NUMBER;
709: l_msg_count NUMBER;
710: l_msg_data VARCHAR2(2000);
711: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
712: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
713: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
714: l_csi_instance_rec csi_datastructures_pub.instance_rec;
715: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
716: l_subject_id NUMBER;
717: l_object_id NUMBER;
710: l_msg_data VARCHAR2(2000);
711: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
712: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
713: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
714: l_csi_instance_rec csi_datastructures_pub.instance_rec;
715: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
716: l_subject_id NUMBER;
717: l_object_id NUMBER;
718: l_csi_relationship_id NUMBER;
711: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
712: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
713: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
714: l_csi_instance_rec csi_datastructures_pub.instance_rec;
715: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
716: l_subject_id NUMBER;
717: l_object_id NUMBER;
718: l_csi_relationship_id NUMBER;
719: l_object_version_number NUMBER;
1321: l_item_assoc_id NUMBER;
1322: l_end_date DATE;
1323:
1324: --Variables needed for CSI API call
1325: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1326: l_csi_party_rec csi_datastructures_pub.party_rec;
1327: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1328: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1322: l_end_date DATE;
1323:
1324: --Variables needed for CSI API call
1325: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1326: l_csi_party_rec csi_datastructures_pub.party_rec;
1327: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1328: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1323:
1324: --Variables needed for CSI API call
1325: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1326: l_csi_party_rec csi_datastructures_pub.party_rec;
1327: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1328: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1324: --Variables needed for CSI API call
1325: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1326: l_csi_party_rec csi_datastructures_pub.party_rec;
1327: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1328: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1325: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1326: l_csi_party_rec csi_datastructures_pub.party_rec;
1327: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1328: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1333: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1326: l_csi_party_rec csi_datastructures_pub.party_rec;
1327: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1328: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1333: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1334: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1327: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1328: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1333: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1334: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1335: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1328: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1333: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1334: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1335: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1336: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1329: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1333: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1334: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1335: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1336: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1337:
1330: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1333: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1334: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1335: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1336: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1337:
1338: --Variables used for creating extended attributes.
1331: l_csi_party_tbl csi_datastructures_pub.party_tbl;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1333: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1334: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1335: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1336: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1337:
1338: --Variables used for creating extended attributes.
1339: l_attribute_id NUMBER;
1332: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
1333: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1334: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1335: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1336: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1337:
1338: --Variables used for creating extended attributes.
1339: l_attribute_id NUMBER;
1340: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
1336: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1337:
1338: --Variables used for creating extended attributes.
1339: l_attribute_id NUMBER;
1340: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
1341: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
1342: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1343: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
1344:
1337:
1338: --Variables used for creating extended attributes.
1339: l_attribute_id NUMBER;
1340: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
1341: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
1342: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1343: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
1344:
1345: CURSOR check_uc_header IS
1338: --Variables used for creating extended attributes.
1339: l_attribute_id NUMBER;
1340: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
1341: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
1342: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1343: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
1344:
1345: CURSOR check_uc_header IS
1346: SELECT unit_config_header_id,
1339: l_attribute_id NUMBER;
1340: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
1341: l_csi_extend_attrib_rec1 csi_datastructures_pub.extend_attrib_values_rec;
1342: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1343: l_csi_ext_attrib_values_tbl1 csi_datastructures_pub.extend_attrib_values_tbl;
1344:
1345: CURSOR check_uc_header IS
1346: SELECT unit_config_header_id,
1347: object_version_number,
2281: l_position_ref_meaning fnd_lookups.meaning%TYPE;
2282: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
2283:
2284: --Variables needed for CSI API call
2285: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2286: l_csi_party_rec csi_datastructures_pub.party_rec;
2287: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2288: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2282: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
2283:
2284: --Variables needed for CSI API call
2285: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2286: l_csi_party_rec csi_datastructures_pub.party_rec;
2287: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2288: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2283:
2284: --Variables needed for CSI API call
2285: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2286: l_csi_party_rec csi_datastructures_pub.party_rec;
2287: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2288: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2284: --Variables needed for CSI API call
2285: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2286: l_csi_party_rec csi_datastructures_pub.party_rec;
2287: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2288: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2285: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2286: l_csi_party_rec csi_datastructures_pub.party_rec;
2287: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2288: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2286: l_csi_party_rec csi_datastructures_pub.party_rec;
2287: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2288: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2287: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2288: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2295: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2288: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2295: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2296: l_party_account_rec csi_datastructures_pub.party_account_rec;
2289: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2295: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2296: l_party_account_rec csi_datastructures_pub.party_account_rec;
2297: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2290: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2295: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2296: l_party_account_rec csi_datastructures_pub.party_account_rec;
2297: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2298: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2291: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2295: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2296: l_party_account_rec csi_datastructures_pub.party_account_rec;
2297: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2298: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2299:
2292: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2295: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2296: l_party_account_rec csi_datastructures_pub.party_account_rec;
2297: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2298: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2299:
2300: CURSOR check_uc_header IS
2293: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2295: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2296: l_party_account_rec csi_datastructures_pub.party_account_rec;
2297: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2298: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2299:
2300: CURSOR check_uc_header IS
2301: SELECT A.unit_config_header_id,
2294: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2295: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2296: l_party_account_rec csi_datastructures_pub.party_account_rec;
2297: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2298: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2299:
2300: CURSOR check_uc_header IS
2301: SELECT A.unit_config_header_id,
2302: A.object_version_number,
3342: l_position_ref_meaning fnd_lookups.meaning%TYPE;
3343: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3344:
3345: --Variables needed for CSI API call
3346: l_csi_party_rec csi_datastructures_pub.party_rec;
3347: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3348: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3349: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3343: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3344:
3345: --Variables needed for CSI API call
3346: l_csi_party_rec csi_datastructures_pub.party_rec;
3347: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3348: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3349: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3344:
3345: --Variables needed for CSI API call
3346: l_csi_party_rec csi_datastructures_pub.party_rec;
3347: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3348: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3349: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3345: --Variables needed for CSI API call
3346: l_csi_party_rec csi_datastructures_pub.party_rec;
3347: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3348: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3349: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3346: l_csi_party_rec csi_datastructures_pub.party_rec;
3347: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3348: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3349: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3347: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3348: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3349: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3355: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3348: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3349: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3355: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3356: l_party_account_rec csi_datastructures_pub.party_account_rec;
3349: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3355: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3356: l_party_account_rec csi_datastructures_pub.party_account_rec;
3357: l_serial_number csi_item_instances.serial_number%TYPE;
3350: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3355: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3356: l_party_account_rec csi_datastructures_pub.party_account_rec;
3357: l_serial_number csi_item_instances.serial_number%TYPE;
3358: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
3351: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3355: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3356: l_party_account_rec csi_datastructures_pub.party_account_rec;
3357: l_serial_number csi_item_instances.serial_number%TYPE;
3358: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
3359: l_serial_number_tag csi_iea_values.attribute_value%TYPE;
3352: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3353: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3354: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3355: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3356: l_party_account_rec csi_datastructures_pub.party_account_rec;
3357: l_serial_number csi_item_instances.serial_number%TYPE;
3358: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
3359: l_serial_number_tag csi_iea_values.attribute_value%TYPE;
3360:
3362: l_transaction_type_id NUMBER;
3363: l_attribute_id NUMBER;
3364: l_attribute_value_id NUMBER;
3365: l_attribute_value csi_iea_values.attribute_value%TYPE;
3366: l_csi_instance_rec csi_datastructures_pub.instance_rec;
3367: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
3368: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
3369: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3370:
3363: l_attribute_id NUMBER;
3364: l_attribute_value_id NUMBER;
3365: l_attribute_value csi_iea_values.attribute_value%TYPE;
3366: l_csi_instance_rec csi_datastructures_pub.instance_rec;
3367: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
3368: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
3369: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3370:
3371: CURSOR check_uc_header IS
3364: l_attribute_value_id NUMBER;
3365: l_attribute_value csi_iea_values.attribute_value%TYPE;
3366: l_csi_instance_rec csi_datastructures_pub.instance_rec;
3367: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
3368: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
3369: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3370:
3371: CURSOR check_uc_header IS
3372: SELECT A.unit_config_header_id,
3365: l_attribute_value csi_iea_values.attribute_value%TYPE;
3366: l_csi_instance_rec csi_datastructures_pub.instance_rec;
3367: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
3368: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
3369: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3370:
3371: CURSOR check_uc_header IS
3372: SELECT A.unit_config_header_id,
3373: A.object_version_number,
6153: l_new_csi_instance_ovn NUMBER;
6154: l_end_date DATE;
6155:
6156: -- Variables needed for CSI API call
6157: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6158: l_csi_party_rec csi_datastructures_pub.party_rec;
6159: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6160: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6154: l_end_date DATE;
6155:
6156: -- Variables needed for CSI API call
6157: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6158: l_csi_party_rec csi_datastructures_pub.party_rec;
6159: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6160: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6155:
6156: -- Variables needed for CSI API call
6157: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6158: l_csi_party_rec csi_datastructures_pub.party_rec;
6159: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6160: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6156: -- Variables needed for CSI API call
6157: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6158: l_csi_party_rec csi_datastructures_pub.party_rec;
6159: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6160: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6157: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6158: l_csi_party_rec csi_datastructures_pub.party_rec;
6159: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6160: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6158: l_csi_party_rec csi_datastructures_pub.party_rec;
6159: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6160: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6159: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6160: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6167: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6160: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6167: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6168: l_party_account_rec csi_datastructures_pub.party_account_rec;
6161: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6167: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6168: l_party_account_rec csi_datastructures_pub.party_account_rec;
6169: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6162: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6167: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6168: l_party_account_rec csi_datastructures_pub.party_account_rec;
6169: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6170: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6163: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6167: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6168: l_party_account_rec csi_datastructures_pub.party_account_rec;
6169: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6170: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6171: --
6164: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6167: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6168: l_party_account_rec csi_datastructures_pub.party_account_rec;
6169: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6170: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6171: --
6172:
6165: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6167: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6168: l_party_account_rec csi_datastructures_pub.party_account_rec;
6169: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6170: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6171: --
6172:
6173: BEGIN
6166: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6167: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6168: l_party_account_rec csi_datastructures_pub.party_account_rec;
6169: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6170: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6171: --
6172:
6173: BEGIN
6174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN