2286: l_dummy VARCHAR2(1);
2287: l_return_value BOOLEAN;
2288: l_open_wo_count NUMBER;
2289: -- variables/records needed to call CSI public API to expire instance
2290: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2291: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
2292: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2293: l_csi_transaction_type_id NUMBER;
2294: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2287: l_return_value BOOLEAN;
2288: l_open_wo_count NUMBER;
2289: -- variables/records needed to call CSI public API to expire instance
2290: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2291: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
2292: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2293: l_csi_transaction_type_id NUMBER;
2294: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2295:
2288: l_open_wo_count NUMBER;
2289: -- variables/records needed to call CSI public API to expire instance
2290: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2291: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
2292: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2293: l_csi_transaction_type_id NUMBER;
2294: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2295:
2296: TYPE t_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2290: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2291: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
2292: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2293: l_csi_transaction_type_id NUMBER;
2294: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
2295:
2296: TYPE t_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2297: l_task_id_tbl t_id_tbl;
2298:
2893: l_index NUMBER := 0;
2894: l_transaction_type_id NUMBER;
2895:
2896: -- variables needed for CSI API call
2897: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2898: l_csi_party_rec csi_datastructures_pub.party_rec;
2899: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2900: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2894: l_transaction_type_id NUMBER;
2895:
2896: -- variables needed for CSI API call
2897: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2898: l_csi_party_rec csi_datastructures_pub.party_rec;
2899: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2900: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2895:
2896: -- variables needed for CSI API call
2897: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2898: l_csi_party_rec csi_datastructures_pub.party_rec;
2899: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2900: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2896: -- variables needed for CSI API call
2897: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2898: l_csi_party_rec csi_datastructures_pub.party_rec;
2899: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2900: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2904: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2897: l_csi_instance_rec csi_datastructures_pub.instance_rec;
2898: l_csi_party_rec csi_datastructures_pub.party_rec;
2899: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2900: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2904: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2905: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2898: l_csi_party_rec csi_datastructures_pub.party_rec;
2899: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2900: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2904: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2905: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2906: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2899: l_csi_party_tbl csi_datastructures_pub.party_tbl;
2900: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2904: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2905: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2906: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2907: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2900: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2904: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2905: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2906: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2907: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2908:
2901: l_party_account_rec csi_datastructures_pub.party_account_rec;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2904: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2905: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2906: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2907: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2908:
2909: l_msg_index_out NUMBER;
2902: l_csi_account_tbl csi_datastructures_pub.party_account_tbl;
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2904: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2905: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2906: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2907: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2908:
2909: l_msg_index_out NUMBER;
2910:
2903: l_csi_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
2904: l_csi_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
2905: l_csi_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
2906: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
2907: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2908:
2909: l_msg_index_out NUMBER;
2910:
2911: l_api_name CONSTANT VARCHAR2(30) := 'Create_Instance_in_WIP';