2528:
2529: l_csi_owner_rec l_csi_owner_csr%ROWTYPE;
2530:
2531:
2532: l_instance_rec csi_datastructures_pub.instance_rec;
2533: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2534: l_party_tbl csi_datastructures_pub.party_tbl;
2535: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2529: l_csi_owner_rec l_csi_owner_csr%ROWTYPE;
2530:
2531:
2532: l_instance_rec csi_datastructures_pub.instance_rec;
2533: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2534: l_party_tbl csi_datastructures_pub.party_tbl;
2535: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2537: l_organization_units_tbl csi_datastructures_pub.organization_units_tbl;
2530:
2531:
2532: l_instance_rec csi_datastructures_pub.instance_rec;
2533: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2534: l_party_tbl csi_datastructures_pub.party_tbl;
2535: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2537: l_organization_units_tbl csi_datastructures_pub.organization_units_tbl;
2538: l_instance_Asset_tbl csi_datastructures_pub.instance_asset_tbl;
2531:
2532: l_instance_rec csi_datastructures_pub.instance_rec;
2533: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2534: l_party_tbl csi_datastructures_pub.party_tbl;
2535: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2537: l_organization_units_tbl csi_datastructures_pub.organization_units_tbl;
2538: l_instance_Asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_transaction_rec csi_datastructures_pub.transaction_rec;
2532: l_instance_rec csi_datastructures_pub.instance_rec;
2533: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2534: l_party_tbl csi_datastructures_pub.party_tbl;
2535: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2537: l_organization_units_tbl csi_datastructures_pub.organization_units_tbl;
2538: l_instance_Asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_transaction_rec csi_datastructures_pub.transaction_rec;
2540: l_id_tbl csi_datastructures_pub.id_tbl;
2533: l_extend_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2534: l_party_tbl csi_datastructures_pub.party_tbl;
2535: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2537: l_organization_units_tbl csi_datastructures_pub.organization_units_tbl;
2538: l_instance_Asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_transaction_rec csi_datastructures_pub.transaction_rec;
2540: l_id_tbl csi_datastructures_pub.id_tbl;
2541:
2534: l_party_tbl csi_datastructures_pub.party_tbl;
2535: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2537: l_organization_units_tbl csi_datastructures_pub.organization_units_tbl;
2538: l_instance_Asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_transaction_rec csi_datastructures_pub.transaction_rec;
2540: l_id_tbl csi_datastructures_pub.id_tbl;
2541:
2542: l_update_required varchar2(1) default 'N';
2535: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2537: l_organization_units_tbl csi_datastructures_pub.organization_units_tbl;
2538: l_instance_Asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_transaction_rec csi_datastructures_pub.transaction_rec;
2540: l_id_tbl csi_datastructures_pub.id_tbl;
2541:
2542: l_update_required varchar2(1) default 'N';
2543: l_count NUMBER default 0;
2536: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2537: l_organization_units_tbl csi_datastructures_pub.organization_units_tbl;
2538: l_instance_Asset_tbl csi_datastructures_pub.instance_asset_tbl;
2539: l_transaction_rec csi_datastructures_pub.transaction_rec;
2540: l_id_tbl csi_datastructures_pub.id_tbl;
2541:
2542: l_update_required varchar2(1) default 'N';
2543: l_count NUMBER default 0;
2544:
2542: l_update_required varchar2(1) default 'N';
2543: l_count NUMBER default 0;
2544:
2545: --instance query recs
2546: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
2547: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
2548: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
2549: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
2550: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
2543: l_count NUMBER default 0;
2544:
2545: --instance query recs
2546: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
2547: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
2548: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
2549: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
2550: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
2551:
2544:
2545: --instance query recs
2546: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
2547: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
2548: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
2549: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
2550: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
2551:
2552: begin
2545: --instance query recs
2546: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
2547: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
2548: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
2549: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
2550: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
2551:
2552: begin
2553:
2546: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
2547: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
2548: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
2549: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
2550: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
2551:
2552: begin
2553:
2554: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3160: l_orig_fin_ast_cle_id okc_k_lines_b.id%type;
3161: l_instance_id okc_k_items.id%type;
3162: l_instance_cle_id okc_k_items.cle_id%type;
3163:
3164: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3165: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3166:
3167: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3168: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
3161: l_instance_id okc_k_items.id%type;
3162: l_instance_cle_id okc_k_items.cle_id%type;
3163:
3164: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3165: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3166:
3167: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3168: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
3169: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
3163:
3164: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3165: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3166:
3167: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3168: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
3169: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
3170: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3164: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3165: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3166:
3167: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3168: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
3169: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
3170: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3172: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3165: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3166:
3167: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3168: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
3169: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
3170: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3172: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3173: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3166:
3167: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3168: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
3169: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
3170: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3172: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3173: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3174: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3167: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
3168: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
3169: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
3170: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3172: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3173: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3174: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3175: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
3168: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
3169: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
3170: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3172: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3173: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3174: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3175: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
3176: l_account_tbl party_account_tbl_type;
3169: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
3170: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3172: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3173: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3174: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3175: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
3176: l_account_tbl party_account_tbl_type;
3177:
3170: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3172: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3173: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3174: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3175: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
3176: l_account_tbl party_account_tbl_type;
3177:
3178: -- gboomina Bug 5362977 - Start
3171: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
3172: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
3173: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
3174: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3175: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
3176: l_account_tbl party_account_tbl_type;
3177:
3178: -- gboomina Bug 5362977 - Start
3179: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3178: -- gboomina Bug 5362977 - Start
3179: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3180: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3181: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3182: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3183: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3184: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3185: l_model_line_qty okc_k_items.number_of_items%TYPE;
3186: l_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3179: l_rbk_model_line_qty okc_k_items.number_of_items%TYPE;
3180: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3181: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3182: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3183: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3184: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3185: l_model_line_qty okc_k_items.number_of_items%TYPE;
3186: l_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3187: x_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3180: l_rbk_inv_item_id okc_k_items.object1_id1%TYPE;
3181: l_rbk_inv_org_id okc_k_items.object1_id2%TYPE;
3182: l_instance_query_temp_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3183: l_instance_header_temp_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3184: l_instance_temp_rec CSI_DATASTRUCTURES_PUB.instance_rec;
3185: l_model_line_qty okc_k_items.number_of_items%TYPE;
3186: l_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3187: x_cim_rec okl_okc_migration_pvt.cimv_rec_type;
3188: -- gboomina Bug 5362977 - End
3204: l_klev_rec okl_kle_pvt.klev_rec_type;
3205: x_clev_rec okl_okc_migration_pvt.clev_rec_type;
3206: x_klev_rec okl_kle_pvt.klev_rec_type;
3207:
3208: l_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3209: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3210: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
3211: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
3212: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
3205: x_clev_rec okl_okc_migration_pvt.clev_rec_type;
3206: x_klev_rec okl_kle_pvt.klev_rec_type;
3207:
3208: l_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3209: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3210: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
3211: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
3212: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
3213: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3206: x_klev_rec okl_kle_pvt.klev_rec_type;
3207:
3208: l_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3209: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3210: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
3211: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
3212: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
3213: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3214:
3207:
3208: l_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3209: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3210: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
3211: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
3212: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
3213: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3214:
3215: BEGIN
3208: l_transaction_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
3209: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3210: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
3211: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
3212: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
3213: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3214:
3215: BEGIN
3216:
3209: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
3210: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
3211: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
3212: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
3213: l_instance_header_rec CSI_DATASTRUCTURES_PUB.instance_header_rec;
3214:
3215: BEGIN
3216:
3217: x_return_status := OKL_API.G_RET_STS_SUCCESS;