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,
2282: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
2283: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
2284:
2285: --Variables needed for CSI API call
2286: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2287: l_csi_party_rec csi_datastructures_pub.party_rec;
2288: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2289: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2283: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
2284:
2285: --Variables needed for CSI API call
2286: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2287: l_csi_party_rec csi_datastructures_pub.party_rec;
2288: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2289: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2284:
2285: --Variables needed for CSI API call
2286: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2287: l_csi_party_rec csi_datastructures_pub.party_rec;
2288: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2289: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2285: --Variables needed for CSI API call
2286: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2287: l_csi_party_rec csi_datastructures_pub.party_rec;
2288: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2289: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2286: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2287: l_csi_party_rec csi_datastructures_pub.party_rec;
2288: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2289: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2287: l_csi_party_rec csi_datastructures_pub.party_rec;
2288: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2289: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2288: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2289: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2296: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2289: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2296: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2297: l_party_account_rec csi_datastructures_pub.party_account_rec;
2290: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2296: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2297: l_party_account_rec csi_datastructures_pub.party_account_rec;
2298: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2291: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2296: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2297: l_party_account_rec csi_datastructures_pub.party_account_rec;
2298: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2299: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2292: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2296: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2297: l_party_account_rec csi_datastructures_pub.party_account_rec;
2298: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2299: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2300:
2293: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2296: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2297: l_party_account_rec csi_datastructures_pub.party_account_rec;
2298: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2299: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2300:
2301: CURSOR check_uc_header IS
2294: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2296: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2297: l_party_account_rec csi_datastructures_pub.party_account_rec;
2298: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2299: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2300:
2301: CURSOR check_uc_header IS
2302: SELECT A.unit_config_header_id,
2295: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2296: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2297: l_party_account_rec csi_datastructures_pub.party_account_rec;
2298: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2299: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2300:
2301: CURSOR check_uc_header IS
2302: SELECT A.unit_config_header_id,
2303: A.object_version_number,
3353: l_interchange_type_code ahl_item_associations_b.interchange_type_code%TYPE;
3354: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
3355:
3356: --Variables needed for CSI API call
3357: l_csi_party_rec csi_datastructures_pub.party_rec;
3358: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3359: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3360: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3354: l_interchange_reason ahl_item_associations_tl.interchange_reason%TYPE;
3355:
3356: --Variables needed for CSI API call
3357: l_csi_party_rec csi_datastructures_pub.party_rec;
3358: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3359: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3360: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3355:
3356: --Variables needed for CSI API call
3357: l_csi_party_rec csi_datastructures_pub.party_rec;
3358: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3359: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3360: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3356: --Variables needed for CSI API call
3357: l_csi_party_rec csi_datastructures_pub.party_rec;
3358: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3359: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3360: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3364: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3357: l_csi_party_rec csi_datastructures_pub.party_rec;
3358: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3359: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3360: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3364: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3365: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3358: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
3359: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3360: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3364: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3365: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3366: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3359: l_csi_relationship_new_rec csi_datastructures_pub.ii_relationship_rec; -- SATHAPLI::FP ER 6504147, 18-Nov-2008
3360: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3364: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3365: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3366: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3367: l_party_account_rec csi_datastructures_pub.party_account_rec;
3360: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3364: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3365: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3366: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3367: l_party_account_rec csi_datastructures_pub.party_account_rec;
3368: l_serial_number csi_item_instances.serial_number%TYPE;
3361: l_csi_party_tbl csi_datastructures_pub.party_tbl;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3364: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3365: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3366: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3367: l_party_account_rec csi_datastructures_pub.party_account_rec;
3368: l_serial_number csi_item_instances.serial_number%TYPE;
3369: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
3362: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3364: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3365: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3366: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3367: l_party_account_rec csi_datastructures_pub.party_account_rec;
3368: l_serial_number csi_item_instances.serial_number%TYPE;
3369: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
3370: l_serial_number_tag csi_iea_values.attribute_value%TYPE;
3363: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
3364: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
3365: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
3366: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
3367: l_party_account_rec csi_datastructures_pub.party_account_rec;
3368: l_serial_number csi_item_instances.serial_number%TYPE;
3369: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
3370: l_serial_number_tag csi_iea_values.attribute_value%TYPE;
3371:
3373: l_transaction_type_id NUMBER;
3374: l_attribute_id NUMBER;
3375: l_attribute_value_id NUMBER;
3376: l_attribute_value csi_iea_values.attribute_value%TYPE;
3377: l_csi_instance_rec csi_datastructures_pub.instance_rec;
3378: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
3379: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
3380: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3381:
3374: l_attribute_id NUMBER;
3375: l_attribute_value_id NUMBER;
3376: l_attribute_value csi_iea_values.attribute_value%TYPE;
3377: l_csi_instance_rec csi_datastructures_pub.instance_rec;
3378: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
3379: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
3380: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3381:
3382: CURSOR check_uc_header IS
3375: l_attribute_value_id NUMBER;
3376: l_attribute_value csi_iea_values.attribute_value%TYPE;
3377: l_csi_instance_rec csi_datastructures_pub.instance_rec;
3378: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
3379: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
3380: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3381:
3382: CURSOR check_uc_header IS
3383: SELECT A.unit_config_header_id,
3376: l_attribute_value csi_iea_values.attribute_value%TYPE;
3377: l_csi_instance_rec csi_datastructures_pub.instance_rec;
3378: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
3379: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
3380: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3381:
3382: CURSOR check_uc_header IS
3383: SELECT A.unit_config_header_id,
3384: A.object_version_number,
6260: l_new_csi_instance_ovn NUMBER;
6261: l_end_date DATE;
6262:
6263: -- Variables needed for CSI API call
6264: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6265: l_csi_party_rec csi_datastructures_pub.party_rec;
6266: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6267: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6261: l_end_date DATE;
6262:
6263: -- Variables needed for CSI API call
6264: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6265: l_csi_party_rec csi_datastructures_pub.party_rec;
6266: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6267: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6262:
6263: -- Variables needed for CSI API call
6264: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6265: l_csi_party_rec csi_datastructures_pub.party_rec;
6266: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6267: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6263: -- Variables needed for CSI API call
6264: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6265: l_csi_party_rec csi_datastructures_pub.party_rec;
6266: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6267: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6264: l_csi_instance_rec csi_datastructures_pub.instance_rec;
6265: l_csi_party_rec csi_datastructures_pub.party_rec;
6266: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6267: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6265: l_csi_party_rec csi_datastructures_pub.party_rec;
6266: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6267: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6266: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
6267: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6274: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6267: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6274: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6275: l_party_account_rec csi_datastructures_pub.party_account_rec;
6268: l_csi_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6274: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6275: l_party_account_rec csi_datastructures_pub.party_account_rec;
6276: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6269: l_csi_party_tbl csi_datastructures_pub.party_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6274: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6275: l_party_account_rec csi_datastructures_pub.party_account_rec;
6276: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6277: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6270: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6274: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6275: l_party_account_rec csi_datastructures_pub.party_account_rec;
6276: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6277: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6278: --
6271: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6274: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6275: l_party_account_rec csi_datastructures_pub.party_account_rec;
6276: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6277: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6278: --
6279:
6272: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6274: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6275: l_party_account_rec csi_datastructures_pub.party_account_rec;
6276: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6277: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6278: --
6279:
6280: BEGIN
6273: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
6274: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
6275: l_party_account_rec csi_datastructures_pub.party_account_rec;
6276: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
6277: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6278: --
6279:
6280: BEGIN
6281: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN