[Home] [Help]
19: /*-------------------------------------------------------------*/
20:
21: PROCEDURE Build_Inst_Hist_Rec_of_Table
22: (
23: p_inst_hist_tbl IN csi_datastructures_pub.instance_history_tbl ,
24: p_inst_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.instance_history_rec_tab )
25: IS
26: BEGIN
27: FOR i in p_inst_hist_tbl.FIRST .. p_inst_hist_tbl.LAST
507: /*---------------------------------------------------------*/
508:
509: PROCEDURE Initialize_inst_rec
510: (
511: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,
512: p_instance_hist_id IN NUMBER ,
513: x_nearest_full_dump IN OUT NOCOPY DATE
514: ) IS
515:
726: /*---------------------------------------------------*/
727:
728: PROCEDURE Initialize_inst_rec_no_dump
729: (
730: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,
731: p_instance_id IN NUMBER ,
732: x_first_no_dump IN OUT NOCOPY DATE
733: ) IS
734:
955: /*---------------------------------------------------------*/
956:
957: PROCEDURE Construct_inst_from_hist
958: (
959: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,
960: p_time_stamp IN DATE
961: ) IS
962:
963: l_nearest_full_dump DATE := p_time_stamp;
1857: -- is to avoid large memory usage in the SGA.
1858: PROCEDURE Construct_inst_header_rec
1859: (
1860: p_inst_id IN NUMBER,
1861: x_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl
1862: ) IS
1863:
1864: l_inst_header_cursor_id INTEGER;
1865: l_rows_processed NUMBER;
1862: ) IS
1863:
1864: l_inst_header_cursor_id INTEGER;
1865: l_rows_processed NUMBER;
1866: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
1867: l_count NUMBER := 0;
1868:
1869: l_select_stmt VARCHAR2(2000) := ' select instance_id, instance_number, external_reference, '||
1870: ' inventory_item_id ,inventory_revision ,inv_master_organization_id, '||
2161: /* for the Dynamic SQL */
2162: /*----------------------------------------------------------*/
2163:
2164: PROCEDURE Resolve_id_columns
2165: (p_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl)
2166:
2167: IS
2168:
2169: l_acct_lookup_type VARCHAR2(30) := 'CSI_ACCOUNTING_CLASS_CODE';
2929:
2930: PROCEDURE Define_Inst_Columns
2931: (
2932: p_get_inst_cursor_id IN NUMBER,
2933: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
2934: ) IS
2935:
2936: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2937:
2932: p_get_inst_cursor_id IN NUMBER,
2933: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
2934: ) IS
2935:
2936: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2937:
2938: BEGIN
2939:
2940: dbms_sql.define_column(p_get_inst_cursor_id, 1, l_instance_header_rec.instance_id);
2949: /*---------------------------------------------------------*/
2950:
2951: PROCEDURE Bind_Inst_variable
2952: (
2953: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
2954: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
2955: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
2956: p_transaction_id IN NUMBER,
2957: p_cur_get_inst_rel IN NUMBER
2950:
2951: PROCEDURE Bind_Inst_variable
2952: (
2953: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
2954: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
2955: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
2956: p_transaction_id IN NUMBER,
2957: p_cur_get_inst_rel IN NUMBER
2958: ) IS
2951: PROCEDURE Bind_Inst_variable
2952: (
2953: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
2954: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
2955: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
2956: p_transaction_id IN NUMBER,
2957: p_cur_get_inst_rel IN NUMBER
2958: ) IS
2959: BEGIN
3213: /*-----------------------------------------------------------*/
3214:
3215: PROCEDURE Gen_Inst_Where_Clause
3216: (
3217: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
3218: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
3219: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
3220: p_transaction_id IN NUMBER,
3221: x_select_stmt OUT NOCOPY VARCHAR2,
3214:
3215: PROCEDURE Gen_Inst_Where_Clause
3216: (
3217: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
3218: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
3219: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
3220: p_transaction_id IN NUMBER,
3221: x_select_stmt OUT NOCOPY VARCHAR2,
3222: p_active_instance_only IN VARCHAR2
3215: PROCEDURE Gen_Inst_Where_Clause
3216: (
3217: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
3218: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
3219: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
3220: p_transaction_id IN NUMBER,
3221: x_select_stmt OUT NOCOPY VARCHAR2,
3222: p_active_instance_only IN VARCHAR2
3223: ) IS
4246:
4247: PROCEDURE Get_Instance_Col_Values
4248: (
4249: p_get_instance_cur_id IN NUMBER,
4250: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
4251: ) IS
4252:
4253: BEGIN
4254: dbms_sql.column_value(p_get_instance_cur_id, 1, x_instance_rec.instance_id);
4375: (
4376: p_get_instance_cur_id IN NUMBER
4377: ) IS
4378:
4379: l_instance_rec csi_datastructures_pub.instance_header_rec;
4380:
4381: BEGIN
4382: dbms_sql.define_column(p_get_instance_cur_id, 1, l_instance_rec.instance_id);
4383: dbms_sql.define_column(p_get_instance_cur_id, 2, l_instance_rec.instance_number,30);
4498: /*---------------------------------------------------------*/
4499:
4500: PROCEDURE Bind_Instance_variable
4501: (
4502: p_instance_rec IN csi_datastructures_pub.instance_header_rec,
4503: p_cur_get_instance_rel IN NUMBER
4504: ) IS
4505:
4506: BEGIN
4525: p_api_version IN NUMBER
4526: ,p_commit IN VARCHAR2
4527: ,p_init_msg_list IN VARCHAR2
4528: ,p_validation_level IN NUMBER
4529: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
4530: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4531: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
4532: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4533: ,x_return_status OUT NOCOPY VARCHAR2
4526: ,p_commit IN VARCHAR2
4527: ,p_init_msg_list IN VARCHAR2
4528: ,p_validation_level IN NUMBER
4529: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
4530: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4531: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
4532: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4533: ,x_return_status OUT NOCOPY VARCHAR2
4534: ,x_msg_count OUT NOCOPY NUMBER
4527: ,p_init_msg_list IN VARCHAR2
4528: ,p_validation_level IN NUMBER
4529: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
4530: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4531: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
4532: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4533: ,x_return_status OUT NOCOPY VARCHAR2
4534: ,x_msg_count OUT NOCOPY NUMBER
4535: ,x_msg_data OUT NOCOPY VARCHAR2
4528: ,p_validation_level IN NUMBER
4529: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
4530: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4531: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
4532: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4533: ,x_return_status OUT NOCOPY VARCHAR2
4534: ,x_msg_count OUT NOCOPY NUMBER
4535: ,x_msg_data OUT NOCOPY VARCHAR2
4536: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4546: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ITEM_INSTANCE_PVT';
4547: l_api_version CONSTANT NUMBER := 1.0;
4548: l_debug_level NUMBER;
4549: l_instance_id NUMBER;
4550: l_party_owner_rec csi_datastructures_pub.party_rec;
4551: l_csi_item_instance_h_id NUMBER;
4552: l_old_oks_cp_rec OKS_IBINT_PUB.CP_REC_TYPE;
4553: l_new_oks_cp_rec OKS_IBINT_PUB.CP_REC_TYPE;
4554: l_ctr_grp_id_template NUMBER;
4558: l_msg_count NUMBER;
4559: l_msg_data VARCHAR2(100);
4560: l_msg_index NUMBER;
4561: l_line_count NUMBER;
4562: l_version_label_rec csi_datastructures_pub.version_label_rec;
4563: l_process_flag BOOLEAN := TRUE;
4564: l_return_value BOOLEAN;
4565: l_owner NUMBER;
4566: l_owner_count NUMBER := 0;
4594: l_component_ins_type VARCHAR2(1):=NULL ;
4595: l_config_hdr_id NUMBER;
4596: l_config_rev_nbr NUMBER;
4597: l_terminated_flag VARCHAR2(1);
4598: l_check_instance_rec csi_datastructures_pub.instance_rec;
4599: l_prior_txn_id NUMBER;
4600: l_ins_flag VARCHAR2(1);
4601: l_eam_item BOOLEAN := FALSE;
4602: l_eam_item_type NUMBER;
5344: FND_MSG_PUB.Add;
5345: RAISE fnd_api.g_exc_error;
5346: END IF;
5347: --
5348: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5349: csi_gen_utility_pvt.populate_install_param_rec;
5350: END IF;
5351: --
5352: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5348: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5349: csi_gen_utility_pvt.populate_install_param_rec;
5350: END IF;
5351: --
5352: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5353: --
5354: IF l_int_party_id IS NULL THEN
5355: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5356: FND_MSG_PUB.ADD;
6558: /* the columns related to instance */
6559: /* are changing */
6560: /*---------------------------------------------------*/
6561:
6562: FUNCTION Anything_To_Update(p_instance_rec csi_datastructures_pub.instance_rec)
6563:
6564: RETURN BOOLEAN
6565: IS
6566:
6798: ,p_init_msg_list IN VARCHAR2
6799: ,p_validation_level IN NUMBER
6800: ,p_instance_id IN NUMBER
6801: ,p_instance_expiry_flag IN VARCHAR2
6802: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6803: ,x_acct_class_code OUT NOCOPY VARCHAR2
6804: ,x_return_status OUT NOCOPY VARCHAR2
6805: ,x_msg_count OUT NOCOPY NUMBER
6806: ,x_msg_data OUT NOCOPY VARCHAR2
6814: l_acct_class_code VARCHAR2(10);
6815: l_accounting_class VARCHAR2(10);
6816: l_loc_type_code VARCHAR2(30);
6817: --l_obj_ver_num NUMBER;
6818: l_instance_rec csi_datastructures_pub.instance_rec;
6819: l_instance_id_lst csi_datastructures_pub.id_tbl ;
6820: x_msg_index_out NUMBER;
6821: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6822: l_location_tbl csi_item_instance_pvt.location_tbl;
6815: l_accounting_class VARCHAR2(10);
6816: l_loc_type_code VARCHAR2(30);
6817: --l_obj_ver_num NUMBER;
6818: l_instance_rec csi_datastructures_pub.instance_rec;
6819: l_instance_id_lst csi_datastructures_pub.id_tbl ;
6820: x_msg_index_out NUMBER;
6821: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6822: l_location_tbl csi_item_instance_pvt.location_tbl;
6823: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6999: (p_api_version IN NUMBER,
7000: p_commit IN VARCHAR2,
7001: p_init_msg_list IN VARCHAR2,
7002: p_validation_level IN NUMBER,
7003: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
7004: p_original_status_id IN NUMBER,
7005: p_original_system_id IN NUMBER,
7006: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7007: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
7002: p_validation_level IN NUMBER,
7003: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
7004: p_original_status_id IN NUMBER,
7005: p_original_system_id IN NUMBER,
7006: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7007: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
7008: x_return_status OUT NOCOPY VARCHAR2,
7009: p_unexpire IN VARCHAR2,
7010: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
7003: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
7004: p_original_status_id IN NUMBER,
7005: p_original_system_id IN NUMBER,
7006: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7007: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
7008: x_return_status OUT NOCOPY VARCHAR2,
7009: p_unexpire IN VARCHAR2,
7010: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
7011: p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_tbl,
7018: l_api_version CONSTANT NUMBER := 1.0;
7019: l_debug_level NUMBER;
7020: l_instance_id NUMBER;
7021: l_dummy NUMBER;
7022: l_instance_rec csi_datastructures_pub.instance_rec:=p_instance_rec;
7023: l_object_version_number NUMBER;
7024: l_return_value BOOLEAN;
7025: l_csi_item_instance_h_id NUMBER;
7026: l_full_dump_frequency NUMBER;
7027: l_mod_value NUMBER;
7028: l_dump_flag VARCHAR2(1);
7029: l_msg_index NUMBER;
7030: l_msg_count NUMBER;
7031: l_instance_hist_rec csi_datastructures_pub.instance_history_rec;
7032: --Start of:Added for bug 5615169
7033: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7034: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7035: l_ciih_blk_ins_cnt NUMBER := 0;
7029: l_msg_index NUMBER;
7030: l_msg_count NUMBER;
7031: l_instance_hist_rec csi_datastructures_pub.instance_history_rec;
7032: --Start of:Added for bug 5615169
7033: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7034: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7035: l_ciih_blk_ins_cnt NUMBER := 0;
7036: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7037: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7376: l_ins_hist_id NUMBER;
7377: l_ins_hist_csr ins_hist_csr%ROWTYPE;
7378: l_last_vld_organization_id NUMBER;
7379: l_child_temp VARCHAR2(1);
7380: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
7381: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
7382: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
7383: l_vld_org_id NUMBER;
7384: PROCESS_NEXT EXCEPTION;
7377: l_ins_hist_csr ins_hist_csr%ROWTYPE;
7378: l_last_vld_organization_id NUMBER;
7379: l_child_temp VARCHAR2(1);
7380: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
7381: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
7382: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
7383: l_vld_org_id NUMBER;
7384: PROCESS_NEXT EXCEPTION;
7385: l_instance_status_id NUMBER;
7442: p_init_msg_list );
7443: END IF;
7444:
7445: -- Start API body
7446: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7447: csi_gen_utility_pvt.populate_install_param_rec;
7448: END IF;
7449: --
7450: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7446: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7447: csi_gen_utility_pvt.populate_install_param_rec;
7448: END IF;
7449: --
7450: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7451: --
7452: IF l_internal_party_id IS NULL THEN
7453: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
7454: FND_MSG_PUB.ADD;
7778: );
7779:
7780: -- Get the full_dump_frequency from csi_install_parameter
7781: --
7782: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7783: csi_gen_utility_pvt.populate_install_param_rec;
7784: END IF;
7785: --
7786: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
7782: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7783: csi_gen_utility_pvt.populate_install_param_rec;
7784: END IF;
7785: --
7786: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
7787: --
7788: IF l_full_dump_frequency IS NULL THEN
7789: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
7790: FND_MSG_PUB.ADD;
10197: --Start of:Added for Bug:5615169
10198: IF l_inst_hist_tbl_blk_ins.count > 0 THEN -- BUG#6203160
10199: --Do the ciih bulk insert
10200: --Convert PL/SQl table to column table
10201: build_inst_hist_rec_of_table ( p_inst_hist_tbl => l_inst_hist_tbl_blk_ins -- csi_datastructures_pub.instance_history_tbl
10202: ,p_inst_hist_rec_tab => l_inst_hist_rec_tab -- csi_item_instance_grp.instance_history_rec_tab
10203: );
10204: --Do the actual bulk Insert
10205: -- Modified OLD_LAST_OE_AGREEMENT_ID, NEW_LAST_OE_AGREEMENT_ID for the bug 6967129
10833: END IF;
10834: --
10835: csi_gen_utility_pvt.put_line('Begin Call_to_Contracts : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
10836: csi_gen_utility_pvt.put_line('Contracts Transaction Type: '||p_transaction_type);
10837: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10838: csi_gen_utility_pvt.populate_install_param_rec;
10839: END IF;
10840: --
10841: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
10837: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10838: csi_gen_utility_pvt.populate_install_param_rec;
10839: END IF;
10840: --
10841: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
10842: --
10843: IF l_internal_party_id IS NULL THEN
10844: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
10845: FND_MSG_PUB.ADD;
11312: RAISE fnd_api.g_exc_error;
11313: END Call_to_Contracts;
11314:
11315: PROCEDURE update_txn_status(
11316: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
11317: x_return_status OUT nocopy varchar2)
11318: IS
11319: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
11320: l_msg_count number;
11358: p_api_version IN NUMBER
11359: ,p_commit IN VARCHAR2
11360: ,p_init_msg_list IN VARCHAR2
11361: ,p_validation_level IN NUMBER
11362: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
11363: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
11364: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
11365: ,x_return_status OUT NOCOPY VARCHAR2
11366: ,x_msg_count OUT NOCOPY NUMBER
11359: ,p_commit IN VARCHAR2
11360: ,p_init_msg_list IN VARCHAR2
11361: ,p_validation_level IN NUMBER
11362: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
11363: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
11364: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
11365: ,x_return_status OUT NOCOPY VARCHAR2
11366: ,x_msg_count OUT NOCOPY NUMBER
11367: ,x_msg_data OUT NOCOPY VARCHAR2
11360: ,p_init_msg_list IN VARCHAR2
11361: ,p_validation_level IN NUMBER
11362: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
11363: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
11364: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
11365: ,x_return_status OUT NOCOPY VARCHAR2
11366: ,x_msg_count OUT NOCOPY NUMBER
11367: ,x_msg_data OUT NOCOPY VARCHAR2
11368: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11379: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
11380: l_api_version CONSTANT NUMBER := 1.0;
11381: l_debug_level NUMBER;
11382: l_instance_id NUMBER;
11383: l_mod_curr_instance_rec csi_datastructures_pub.instance_rec;
11384: l_party_tbl csi_datastructures_pub.party_tbl;
11385: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11386: l_dummy VARCHAR2(1);
11387: l_instance_rec csi_datastructures_pub.instance_rec;
11380: l_api_version CONSTANT NUMBER := 1.0;
11381: l_debug_level NUMBER;
11382: l_instance_id NUMBER;
11383: l_mod_curr_instance_rec csi_datastructures_pub.instance_rec;
11384: l_party_tbl csi_datastructures_pub.party_tbl;
11385: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11386: l_dummy VARCHAR2(1);
11387: l_instance_rec csi_datastructures_pub.instance_rec;
11388: l_get_instance_rec csi_datastructures_pub.instance_rec;
11381: l_debug_level NUMBER;
11382: l_instance_id NUMBER;
11383: l_mod_curr_instance_rec csi_datastructures_pub.instance_rec;
11384: l_party_tbl csi_datastructures_pub.party_tbl;
11385: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11386: l_dummy VARCHAR2(1);
11387: l_instance_rec csi_datastructures_pub.instance_rec;
11388: l_get_instance_rec csi_datastructures_pub.instance_rec;
11389: l_check_instance_rec csi_datastructures_pub.instance_rec;
11383: l_mod_curr_instance_rec csi_datastructures_pub.instance_rec;
11384: l_party_tbl csi_datastructures_pub.party_tbl;
11385: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11386: l_dummy VARCHAR2(1);
11387: l_instance_rec csi_datastructures_pub.instance_rec;
11388: l_get_instance_rec csi_datastructures_pub.instance_rec;
11389: l_check_instance_rec csi_datastructures_pub.instance_rec;
11390: l_version_label_rec csi_datastructures_pub.version_label_rec;
11391: l_object_version_number NUMBER;
11384: l_party_tbl csi_datastructures_pub.party_tbl;
11385: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11386: l_dummy VARCHAR2(1);
11387: l_instance_rec csi_datastructures_pub.instance_rec;
11388: l_get_instance_rec csi_datastructures_pub.instance_rec;
11389: l_check_instance_rec csi_datastructures_pub.instance_rec;
11390: l_version_label_rec csi_datastructures_pub.version_label_rec;
11391: l_object_version_number NUMBER;
11392: l_return_value BOOLEAN;
11385: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11386: l_dummy VARCHAR2(1);
11387: l_instance_rec csi_datastructures_pub.instance_rec;
11388: l_get_instance_rec csi_datastructures_pub.instance_rec;
11389: l_check_instance_rec csi_datastructures_pub.instance_rec;
11390: l_version_label_rec csi_datastructures_pub.version_label_rec;
11391: l_object_version_number NUMBER;
11392: l_return_value BOOLEAN;
11393: l_csi_item_instance_h_id NUMBER;
11386: l_dummy VARCHAR2(1);
11387: l_instance_rec csi_datastructures_pub.instance_rec;
11388: l_get_instance_rec csi_datastructures_pub.instance_rec;
11389: l_check_instance_rec csi_datastructures_pub.instance_rec;
11390: l_version_label_rec csi_datastructures_pub.version_label_rec;
11391: l_object_version_number NUMBER;
11392: l_return_value BOOLEAN;
11393: l_csi_item_instance_h_id NUMBER;
11394: l_full_dump_frequency NUMBER;
11404: l_dump_flag VARCHAR2(1);
11405: l_msg_index NUMBER;
11406: l_msg_count NUMBER;
11407: l_msg_dummy NUMBER;
11408: l_party_rec csi_datastructures_pub.party_rec;
11409: l_party_owner_rec csi_datastructures_pub.party_rec;
11410: l_location_type_code VARCHAR2(20);
11411: l_location_id NUMBER;
11412: l_inv_organization_id NUMBER;
11405: l_msg_index NUMBER;
11406: l_msg_count NUMBER;
11407: l_msg_dummy NUMBER;
11408: l_party_rec csi_datastructures_pub.party_rec;
11409: l_party_owner_rec csi_datastructures_pub.party_rec;
11410: l_location_type_code VARCHAR2(20);
11411: l_location_id NUMBER;
11412: l_inv_organization_id NUMBER;
11413: l_inv_subinventory_name VARCHAR2(10);
11436: -- Counter ref r12 changes
11437: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.DFF_REC_TYPE;
11438: l_delete_status VARCHAR2(1);
11439: l_exists VARCHAR2(1);
11440: l_instance_hist_rec csi_datastructures_pub.instance_history_rec;
11441: l_prior_txn_id NUMBER;
11442: l_oe_line_id NUMBER;
11443: l_install_date DATE;
11444: l_current_val NUMBER;
11445: l_txn_status varchar2(10) := 'COMPLETE';
11446: l_part_or_serial_change BOOLEAN := FALSE; --6176621
11447: l_number_open_ro NUMBER;
11448: --
11449: l_mtl_txn_tbl CSI_DATASTRUCTURES_PUB.MTL_TXN_TBL; -- Added for the bug 6875664, base bug 6531599
11450: CURSOR CTR_GROUP(p_src_object_id IN NUMBER) IS
11451: SELECT group_id
11452: FROM csi_ctr_item_associations
11453: WHERE inventory_item_id = p_src_object_id;
13313: END IF;
13314:
13315: -- Following code has been added for operational_status_code
13316: -- If owner is Internal then
13317: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
13318: --
13319: IF l_int_party_id IS NULL THEN
13320: select internal_party_id
13321: into l_int_party_id
14637: END IF;
14638:
14639: -- Get the full_dump_frequency from csi_install_parameter
14640: --
14641: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
14642: csi_gen_utility_pvt.populate_install_param_rec;
14643: END IF;
14644: --
14645: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
14641: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
14642: csi_gen_utility_pvt.populate_install_param_rec;
14643: END IF;
14644: --
14645: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
14646: --
14647: IF l_full_dump_frequency IS NULL THEN
14648: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
14649: FND_MSG_PUB.ADD;
18832: ( p_api_version IN NUMBER,
18833: p_commit IN VARCHAR2,
18834: p_init_msg_list IN VARCHAR2,
18835: p_validation_level IN NUMBER,
18836: p_instance_rec IN csi_datastructures_pub.instance_rec,
18837: p_expire_children IN VARCHAR2,
18838: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
18839: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
18840: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
18834: p_init_msg_list IN VARCHAR2,
18835: p_validation_level IN NUMBER,
18836: p_instance_rec IN csi_datastructures_pub.instance_rec,
18837: p_expire_children IN VARCHAR2,
18838: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
18839: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
18840: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
18841: x_return_status OUT NOCOPY VARCHAR2,
18842: x_msg_count OUT NOCOPY NUMBER,
18835: p_validation_level IN NUMBER,
18836: p_instance_rec IN csi_datastructures_pub.instance_rec,
18837: p_expire_children IN VARCHAR2,
18838: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
18839: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
18840: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
18841: x_return_status OUT NOCOPY VARCHAR2,
18842: x_msg_count OUT NOCOPY NUMBER,
18843: x_msg_data OUT NOCOPY VARCHAR2
18846: l_api_version CONSTANT NUMBER := 1.0;
18847: l_debug_level NUMBER;
18848: l_instance_id NUMBER;
18849: l_dummy NUMBER;
18850: l_instance_rec csi_datastructures_pub.instance_rec:=p_instance_rec;
18851: l_object_version_number NUMBER;
18852: l_return_value BOOLEAN;
18853: l_csi_item_instance_h_id NUMBER;
18854: l_full_dump_frequency NUMBER;
18853: l_csi_item_instance_h_id NUMBER;
18854: l_full_dump_frequency NUMBER;
18855: l_mod_value NUMBER;
18856: l_dump_flag VARCHAR2(1);
18857: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
18858: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
18859: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
18860:
18861: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS
18854: l_full_dump_frequency NUMBER;
18855: l_mod_value NUMBER;
18856: l_dump_flag VARCHAR2(1);
18857: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
18858: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
18859: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
18860:
18861: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS
18862: SELECT
19334: RAISE FND_API.G_EXC_ERROR;
19335: END IF;
19336:
19337: -- Get the full_dump_frequency from csi_install_parameter
19338: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
19339: csi_gen_utility_pvt.populate_install_param_rec;
19340: END IF;
19341: --
19342: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
19338: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
19339: csi_gen_utility_pvt.populate_install_param_rec;
19340: END IF;
19341: --
19342: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
19343: --
19344: IF l_full_dump_frequency IS NULL THEN
19345: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
19346: FND_MSG_PUB.ADD;
19933: p_api_version IN NUMBER
19934: ,p_commit IN VARCHAR2
19935: ,p_init_msg_list IN VARCHAR2
19936: ,p_validation_level IN NUMBER
19937: ,p_instance_rec IN csi_datastructures_pub.instance_rec
19938: ,p_expire_children IN VARCHAR2
19939: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
19940: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
19941: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
19935: ,p_init_msg_list IN VARCHAR2
19936: ,p_validation_level IN NUMBER
19937: ,p_instance_rec IN csi_datastructures_pub.instance_rec
19938: ,p_expire_children IN VARCHAR2
19939: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
19940: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
19941: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
19942: ,x_return_status OUT NOCOPY VARCHAR2
19943: ,x_msg_count OUT NOCOPY NUMBER
19936: ,p_validation_level IN NUMBER
19937: ,p_instance_rec IN csi_datastructures_pub.instance_rec
19938: ,p_expire_children IN VARCHAR2
19939: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
19940: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
19941: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
19942: ,x_return_status OUT NOCOPY VARCHAR2
19943: ,x_msg_count OUT NOCOPY NUMBER
19944: ,x_msg_data OUT NOCOPY VARCHAR2
19948: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_ITEM_NSTANCE';
19949: l_api_version CONSTANT NUMBER := 1.0;
19950: l_debug_level NUMBER;
19951: l_instance_id NUMBER;
19952: l_instance_rec csi_datastructures_pub.instance_rec;
19953: l_temp_instance_rec csi_datastructures_pub.instance_rec;
19954: l_csi_item_instance_h_id NUMBER;
19955: l_full_dump_frequency NUMBER;
19956: l_mod_value NUMBER;
19949: l_api_version CONSTANT NUMBER := 1.0;
19950: l_debug_level NUMBER;
19951: l_instance_id NUMBER;
19952: l_instance_rec csi_datastructures_pub.instance_rec;
19953: l_temp_instance_rec csi_datastructures_pub.instance_rec;
19954: l_csi_item_instance_h_id NUMBER;
19955: l_full_dump_frequency NUMBER;
19956: l_mod_value NUMBER;
19957: l_dump_flag VARCHAR2(1);
19956: l_mod_value NUMBER;
19957: l_dump_flag VARCHAR2(1);
19958: l_dummy NUMBER;
19959: -- Added variables for bug 6788183
19960: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
19961: l_instance_id_lst csi_datastructures_pub.id_tbl;
19962: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
19963: l_msg_data VARCHAR2(2000);
19964:
19957: l_dump_flag VARCHAR2(1);
19958: l_dummy NUMBER;
19959: -- Added variables for bug 6788183
19960: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
19961: l_instance_id_lst csi_datastructures_pub.id_tbl;
19962: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
19963: l_msg_data VARCHAR2(2000);
19964:
19965: CURSOR get_instance_rec(p_instance_id IN NUMBER) IS
20224:
20225: DECLARE
20226: l_dummy NUMBER;
20227: l_has_unexpired_children BOOLEAN;
20228: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
20229: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
20230: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
20231: BEGIN
20232: p_rel_query_rec.object_id := p_instance_rec.instance_id;
20225: DECLARE
20226: l_dummy NUMBER;
20227: l_has_unexpired_children BOOLEAN;
20228: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
20229: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
20230: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
20231: BEGIN
20232: p_rel_query_rec.object_id := p_instance_rec.instance_id;
20233: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
20591: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
20592:
20593: -- Get the full_dump_frequency from csi_install_parameter
20594: --
20595: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
20596: csi_gen_utility_pvt.populate_install_param_rec;
20597: END IF;
20598: --
20599: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
20595: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
20596: csi_gen_utility_pvt.populate_install_param_rec;
20597: END IF;
20598: --
20599: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
20600: --
20601: IF l_full_dump_frequency IS NULL THEN
20602: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
20603: FND_MSG_PUB.ADD;
21427: p_api_version IN NUMBER
21428: ,p_commit IN VARCHAR2
21429: ,p_init_msg_list IN VARCHAR2
21430: ,p_validation_level IN NUMBER
21431: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
21432: ,p_quantity1 IN NUMBER
21433: ,p_quantity2 IN NUMBER
21434: ,p_copy_ext_attribs IN VARCHAR2
21435: ,p_copy_org_assignments IN VARCHAR2
21437: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
21438: ,p_copy_accounts IN VARCHAR2
21439: ,p_copy_asset_assignments IN VARCHAR2
21440: ,p_copy_pricing_attribs IN VARCHAR2
21441: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
21442: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
21443: ,x_return_status OUT NOCOPY VARCHAR2
21444: ,x_msg_count OUT NOCOPY NUMBER
21445: ,x_msg_data OUT NOCOPY VARCHAR2
21438: ,p_copy_accounts IN VARCHAR2
21439: ,p_copy_asset_assignments IN VARCHAR2
21440: ,p_copy_pricing_attribs IN VARCHAR2
21441: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
21442: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
21443: ,x_return_status OUT NOCOPY VARCHAR2
21444: ,x_msg_count OUT NOCOPY NUMBER
21445: ,x_msg_data OUT NOCOPY VARCHAR2
21446: )
21452: l_serialized NUMBER;
21453: l_return_value BOOLEAN;
21454: l_object_version_number NUMBER;
21455: l_quantity NUMBER;
21456: l_instance_id_lst csi_datastructures_pub.id_tbl;
21457: l_new_instance_rec csi_datastructures_pub.instance_rec;
21458: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
21459: l_msg_data VARCHAR2(2000);
21460: l_msg_index NUMBER;
21453: l_return_value BOOLEAN;
21454: l_object_version_number NUMBER;
21455: l_quantity NUMBER;
21456: l_instance_id_lst csi_datastructures_pub.id_tbl;
21457: l_new_instance_rec csi_datastructures_pub.instance_rec;
21458: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
21459: l_msg_data VARCHAR2(2000);
21460: l_msg_index NUMBER;
21461: l_msg_count NUMBER;
21454: l_object_version_number NUMBER;
21455: l_quantity NUMBER;
21456: l_instance_id_lst csi_datastructures_pub.id_tbl;
21457: l_new_instance_rec csi_datastructures_pub.instance_rec;
21458: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
21459: l_msg_data VARCHAR2(2000);
21460: l_msg_index NUMBER;
21461: l_msg_count NUMBER;
21462: x_msg_index_out NUMBER;
21462: x_msg_index_out NUMBER;
21463: l_old_oks_cp_rec oks_ibint_pub.cp_rec_type;
21464: l_new_oks_cp_rec oks_ibint_pub.cp_rec_type;
21465: l_transaction_type VARCHAR2(10);
21466: l_source_instance_rec csi_datastructures_pub.instance_rec := p_source_instance_rec;
21467: l_contracts_status VARCHAR2(3);
21468: l_new_instance_rec1 csi_datastructures_pub.instance_rec;
21469: l_internal_party_id NUMBER;
21470: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21464: l_new_oks_cp_rec oks_ibint_pub.cp_rec_type;
21465: l_transaction_type VARCHAR2(10);
21466: l_source_instance_rec csi_datastructures_pub.instance_rec := p_source_instance_rec;
21467: l_contracts_status VARCHAR2(3);
21468: l_new_instance_rec1 csi_datastructures_pub.instance_rec;
21469: l_internal_party_id NUMBER;
21470: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21471: l_location_tbl csi_item_instance_pvt.location_tbl;
21472: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21471: l_location_tbl csi_item_instance_pvt.location_tbl;
21472: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21473: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21474: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21475: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21476: --
21477: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
21478: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
21479: l_batch_type VARCHAR2(50);
21932: p_api_version IN NUMBER
21933: ,p_commit IN VARCHAR2
21934: ,p_init_msg_list IN VARCHAR2
21935: ,p_validation_level IN NUMBER
21936: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
21937: ,p_copy_ext_attribs IN VARCHAR2
21938: ,p_copy_org_assignments IN VARCHAR2
21939: ,p_copy_parties IN VARCHAR2
21940: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
21940: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
21941: ,p_copy_accounts IN VARCHAR2
21942: ,p_copy_asset_assignments IN VARCHAR2
21943: ,p_copy_pricing_attribs IN VARCHAR2
21944: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
21945: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
21946: ,x_return_status OUT NOCOPY VARCHAR2
21947: ,x_msg_count OUT NOCOPY NUMBER
21948: ,x_msg_data OUT NOCOPY VARCHAR2
21941: ,p_copy_accounts IN VARCHAR2
21942: ,p_copy_asset_assignments IN VARCHAR2
21943: ,p_copy_pricing_attribs IN VARCHAR2
21944: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
21945: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
21946: ,x_return_status OUT NOCOPY VARCHAR2
21947: ,x_msg_count OUT NOCOPY NUMBER
21948: ,x_msg_data OUT NOCOPY VARCHAR2
21949: )
21964: l_serialized NUMBER;
21965: l_return_value BOOLEAN;
21966: l_object_version_number NUMBER;
21967: l_quantity NUMBER;
21968: l_instance_id_lst csi_datastructures_pub.id_tbl;
21969: l_new_instance_rec csi_datastructures_pub.instance_rec;
21970: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
21971: l_count NUMBER;
21972: l_msg_data VARCHAR2(2000);
21965: l_return_value BOOLEAN;
21966: l_object_version_number NUMBER;
21967: l_quantity NUMBER;
21968: l_instance_id_lst csi_datastructures_pub.id_tbl;
21969: l_new_instance_rec csi_datastructures_pub.instance_rec;
21970: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
21971: l_count NUMBER;
21972: l_msg_data VARCHAR2(2000);
21973: l_msg_index NUMBER;
21966: l_object_version_number NUMBER;
21967: l_quantity NUMBER;
21968: l_instance_id_lst csi_datastructures_pub.id_tbl;
21969: l_new_instance_rec csi_datastructures_pub.instance_rec;
21970: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
21971: l_count NUMBER;
21972: l_msg_data VARCHAR2(2000);
21973: l_msg_index NUMBER;
21974: l_msg_count NUMBER;
21980: l_location_tbl csi_item_instance_pvt.location_tbl;
21981: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21982: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21983: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21984: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21985: --
21986: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
21987: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
21988: l_batch_type VARCHAR2(50);
22441: /*----------------------------------------------------------*/
22442:
22443: PROCEDURE Initialize_ver_rec_no_dump
22444: (
22445: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,
22446: p_version_label_id IN NUMBER ,
22447: x_no_dump IN OUT NOCOPY DATE
22448: ) IS
22449:
22517: /*----------------------------------------------------------*/
22518:
22519: PROCEDURE Initialize_ver_rec
22520: (
22521: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,
22522: p_version_label_hist_id IN NUMBER ,
22523: x_nearest_full_dump IN OUT NOCOPY DATE
22524: ) IS
22525:
22587: /*----------------------------------------------------------*/
22588:
22589: PROCEDURE Construct_ver_from_hist
22590: (
22591: x_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl,
22592: p_time_stamp IN DATE
22593: ) IS
22594:
22595: l_nearest_full_dump DATE := p_time_stamp;
22837:
22838: PROCEDURE Get_Ver_Column_Values
22839: (
22840: p_get_ver_cursor_id IN NUMBER ,
22841: x_ver_label_query_rec OUT NOCOPY csi_datastructures_pub.version_label_rec
22842: ) IS
22843: BEGIN
22844:
22845: dbms_sql.column_value(p_get_ver_cursor_id, 1, x_ver_label_query_rec.version_label_id);
22880: (
22881: p_get_ver_cursor_id IN NUMBER
22882: ) IS
22883:
22884: l_ver_label_rec csi_datastructures_pub.version_label_rec;
22885:
22886: BEGIN
22887:
22888: dbms_sql.define_column(p_get_ver_cursor_id, 1, l_ver_label_rec.version_label_id);
22918: /* cluase for Party relationship */
22919: /*----------------------------------------------------------*/
22920: PROCEDURE Bind_Ver_variable
22921: (
22922: p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec,
22923: p_get_ver_cursor_id IN NUMBER
22924: ) IS
22925:
22926: BEGIN
22953: /* cluase for Party relationship */
22954: /*----------------------------------------------------------*/
22955:
22956: PROCEDURE Gen_Ver_Where_Clause
22957: ( p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec
22958: ,x_where_clause OUT NOCOPY VARCHAR2
22959: ) IS
22960:
22961: BEGIN
23032: ( p_api_version IN NUMBER
23033: ,p_commit IN VARCHAR2
23034: ,p_init_msg_list IN VARCHAR2
23035: ,p_validation_level IN NUMBER
23036: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
23037: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
23038: ,x_return_status OUT NOCOPY VARCHAR2
23039: ,x_msg_count OUT NOCOPY NUMBER
23040: ,x_msg_data OUT NOCOPY VARCHAR2
23033: ,p_commit IN VARCHAR2
23034: ,p_init_msg_list IN VARCHAR2
23035: ,p_validation_level IN NUMBER
23036: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
23037: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
23038: ,x_return_status OUT NOCOPY VARCHAR2
23039: ,x_msg_count OUT NOCOPY NUMBER
23040: ,x_msg_data OUT NOCOPY VARCHAR2
23041: ) IS
23044: l_api_version CONSTANT NUMBER := 1.0 ;
23045: l_debug_level NUMBER ;
23046: l_process_flag BOOLEAN := TRUE ;
23047: l_msg_index NUMBER ;
23048: l_version_label_rec csi_datastructures_pub.version_label_rec;
23049: l_version_label_hist_id NUMBER ;
23050: l_flag VARCHAR2(1) :='N';
23051:
23052: BEGIN
23342: ( p_api_version IN NUMBER
23343: ,p_commit IN VARCHAR2
23344: ,p_init_msg_list IN VARCHAR2
23345: ,p_validation_level IN NUMBER
23346: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
23347: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
23348: ,p_call_transaction IN VARCHAR2
23349: ,x_return_status OUT NOCOPY VARCHAR2
23350: ,x_msg_count OUT NOCOPY NUMBER
23343: ,p_commit IN VARCHAR2
23344: ,p_init_msg_list IN VARCHAR2
23345: ,p_validation_level IN NUMBER
23346: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
23347: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
23348: ,p_call_transaction IN VARCHAR2
23349: ,x_return_status OUT NOCOPY VARCHAR2
23350: ,x_msg_count OUT NOCOPY NUMBER
23351: ,x_msg_data OUT NOCOPY VARCHAR2
23353:
23354: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_LABEL';
23355: l_api_version CONSTANT NUMBER := 1.0;
23356: l_debug_level NUMBER;
23357: l_version_label_rec csi_datastructures_pub.version_label_rec;
23358: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
23359: l_temp_ver_label_rec csi_datastructures_pub.version_label_rec;
23360: l_msg_index NUMBER;
23361: l_OBJECT_VERSION_NUMBER NUMBER;
23354: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_LABEL';
23355: l_api_version CONSTANT NUMBER := 1.0;
23356: l_debug_level NUMBER;
23357: l_version_label_rec csi_datastructures_pub.version_label_rec;
23358: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
23359: l_temp_ver_label_rec csi_datastructures_pub.version_label_rec;
23360: l_msg_index NUMBER;
23361: l_OBJECT_VERSION_NUMBER NUMBER;
23362: l_mod_value NUMBER;
23355: l_api_version CONSTANT NUMBER := 1.0;
23356: l_debug_level NUMBER;
23357: l_version_label_rec csi_datastructures_pub.version_label_rec;
23358: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
23359: l_temp_ver_label_rec csi_datastructures_pub.version_label_rec;
23360: l_msg_index NUMBER;
23361: l_OBJECT_VERSION_NUMBER NUMBER;
23362: l_mod_value NUMBER;
23363: l_version_label_hist_id NUMBER;
23363: l_version_label_hist_id NUMBER;
23364: x_msg_index_out NUMBER;
23365: l_full_dump_frequency NUMBER;
23366: l_flag VARCHAR2(1) :='N';
23367: l_ver_label_hist_rec csi_datastructures_pub.version_label_history_rec;
23368:
23369: CURSOR get_curr_ver_label_rec (p_ver_label_id IN NUMBER) IS
23370: SELECT
23371: VERSION_LABEL_ID ,
23553: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
23554:
23555: -- Get the full_dump_frequency from csi_install_parameter
23556: --
23557: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
23558: csi_gen_utility_pvt.populate_install_param_rec;
23559: END IF;
23560: --
23561: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
23557: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
23558: csi_gen_utility_pvt.populate_install_param_rec;
23559: END IF;
23560: --
23561: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
23562: --
23563: IF l_full_dump_frequency IS NULL THEN
23564: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
23565: FND_MSG_PUB.ADD;
24468: ( p_api_version IN NUMBER
24469: ,p_commit IN VARCHAR2
24470: ,p_init_msg_list IN VARCHAR2
24471: ,p_validation_level IN NUMBER
24472: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
24473: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
24474: ,x_return_status OUT NOCOPY VARCHAR2
24475: ,x_msg_count OUT NOCOPY NUMBER
24476: ,x_msg_data OUT NOCOPY VARCHAR2
24469: ,p_commit IN VARCHAR2
24470: ,p_init_msg_list IN VARCHAR2
24471: ,p_validation_level IN NUMBER
24472: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
24473: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
24474: ,x_return_status OUT NOCOPY VARCHAR2
24475: ,x_msg_count OUT NOCOPY NUMBER
24476: ,x_msg_data OUT NOCOPY VARCHAR2
24477: ) IS
24477: ) IS
24478: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_VERSION_LABEL';
24479: l_api_version CONSTANT NUMBER := 1.0;
24480: l_debug_level NUMBER;
24481: l_version_label_rec csi_datastructures_pub.version_label_rec;
24482: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
24483: l_msg_index NUMBER;
24484: l_OBJECT_VERSION_NUMBER NUMBER;
24485: l_mod_value NUMBER;
24478: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_VERSION_LABEL';
24479: l_api_version CONSTANT NUMBER := 1.0;
24480: l_debug_level NUMBER;
24481: l_version_label_rec csi_datastructures_pub.version_label_rec;
24482: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
24483: l_msg_index NUMBER;
24484: l_OBJECT_VERSION_NUMBER NUMBER;
24485: l_mod_value NUMBER;
24486: l_version_label_hist_id NUMBER;
24664: -- Generate a unique instance_party_history_id from the sequence
24665: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
24666:
24667: -- Get the full_dump_frequency from csi_install_parameter
24668: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
24669: csi_gen_utility_pvt.populate_install_param_rec;
24670: END IF;
24671: --
24672: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
24668: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
24669: csi_gen_utility_pvt.populate_install_param_rec;
24670: END IF;
24671: --
24672: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
24673: --
24674: IF l_full_dump_frequency IS NULL THEN
24675: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
24676: FND_MSG_PUB.ADD;
24851: /*----------------------------------------------------------*/
24852:
24853: PROCEDURE Initialize_ext_rec_no_dump
24854: (
24855: x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,
24856: p_ext_id IN NUMBER,
24857: x_no_dump IN OUT NOCOPY DATE
24858: ) IS
24859:
24921: /*----------------------------------------------------------*/
24922:
24923: PROCEDURE Initialize_ext_rec
24924: (
24925: x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,
24926: p_ext_h_id IN NUMBER,
24927: x_nearest_full_dump IN OUT NOCOPY DATE
24928: ) IS
24929:
24987: /* from the history */
24988: /*----------------------------------------------------------*/
24989:
24990: PROCEDURE Construct_ext_from_hist
24991: ( x_ext_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
24992: p_time_stamp IN DATE
24993: ) IS
24994:
24995: l_nearest_full_dump DATE := p_time_stamp;
24993: ) IS
24994:
24995: l_nearest_full_dump DATE := p_time_stamp;
24996: l_att_val_hist_id NUMBER;
24997: l_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
24998: l_ext_count NUMBER := 0;
24999: --
25000: Process_next EXCEPTION;
25001:
25240: PROCEDURE Define_ext_Columns
25241: ( p_get_ext_cursor_id IN NUMBER
25242: )
25243: IS
25244: l_ext_rec csi_datastructures_pub.extend_attrib_values_rec;
25245:
25246: BEGIN
25247: dbms_sql.define_column(p_get_ext_cursor_id, 1, l_ext_rec.attribute_value_id);
25248: dbms_sql.define_column(p_get_ext_cursor_id, 2, l_ext_rec.attribute_id);
25278: /*----------------------------------------------------------*/
25279:
25280: PROCEDURE Get_ext_Column_Values
25281: (p_get_ext_cursor_id IN NUMBER,
25282: x_ext_rec OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
25283: )
25284: IS
25285: BEGIN
25286: dbms_sql.column_value(p_get_ext_cursor_id, 1, x_ext_rec.attribute_value_id);
25319: /* for the Dynamic SQL */
25320: /*----------------------------------------------------------*/
25321:
25322: PROCEDURE Bind_ext_variable
25323: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec,
25324: p_cur_get_ext IN NUMBER
25325: )
25326: IS
25327: BEGIN
25352: /* clause for Extended Attributes units */
25353: /*----------------------------------------------------------*/
25354:
25355: PROCEDURE Gen_ext_Where_Clause
25356: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
25357: ,x_where_clause OUT NOCOPY VARCHAR2
25358: ) IS
25359:
25360: BEGIN
25415: p_api_version IN NUMBER
25416: ,p_commit IN VARCHAR2
25417: ,p_init_msg_list IN VARCHAR2
25418: ,p_validation_level IN NUMBER
25419: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
25420: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
25421: ,x_return_status OUT NOCOPY VARCHAR2
25422: ,x_msg_count OUT NOCOPY NUMBER
25423: ,x_msg_data OUT NOCOPY VARCHAR2
25416: ,p_commit IN VARCHAR2
25417: ,p_init_msg_list IN VARCHAR2
25418: ,p_validation_level IN NUMBER
25419: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
25420: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
25421: ,x_return_status OUT NOCOPY VARCHAR2
25422: ,x_msg_count OUT NOCOPY NUMBER
25423: ,x_msg_data OUT NOCOPY VARCHAR2
25424: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
25996: p_api_version IN NUMBER
25997: ,p_commit IN VARCHAR2
25998: ,p_init_msg_list IN VARCHAR2
25999: ,p_validation_level IN NUMBER
26000: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
26001: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
26002: ,x_return_status OUT NOCOPY VARCHAR2
26003: ,x_msg_count OUT NOCOPY NUMBER
26004: ,x_msg_data OUT NOCOPY VARCHAR2
25997: ,p_commit IN VARCHAR2
25998: ,p_init_msg_list IN VARCHAR2
25999: ,p_validation_level IN NUMBER
26000: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
26001: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
26002: ,x_return_status OUT NOCOPY VARCHAR2
26003: ,x_msg_count OUT NOCOPY NUMBER
26004: ,x_msg_data OUT NOCOPY VARCHAR2
26005: )
26015: l_attribute_value_id NUMBER:= p_ext_attrib_rec.attribute_value_id;
26016: l_attribute_value_h_id NUMBER;
26017: l_dump_frequency NUMBER;
26018: l_dump_frequency_flag VARCHAR2(30);
26019: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26020: l_temp_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26021: l_ext_att_hist_rec csi_datastructures_pub.ext_attrib_val_history_rec;
26022:
26023: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26016: l_attribute_value_h_id NUMBER;
26017: l_dump_frequency NUMBER;
26018: l_dump_frequency_flag VARCHAR2(30);
26019: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26020: l_temp_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26021: l_ext_att_hist_rec csi_datastructures_pub.ext_attrib_val_history_rec;
26022:
26023: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26024: SELECT *
26017: l_dump_frequency NUMBER;
26018: l_dump_frequency_flag VARCHAR2(30);
26019: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26020: l_temp_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26021: l_ext_att_hist_rec csi_datastructures_pub.ext_attrib_val_history_rec;
26022:
26023: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26024: SELECT *
26025: FROM csi_iea_values_h
27088: ( p_api_version IN NUMBER
27089: ,p_commit IN VARCHAR2
27090: ,p_init_msg_list IN VARCHAR2
27091: ,p_validation_level IN NUMBER
27092: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
27093: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
27094: ,x_return_status OUT NOCOPY VARCHAR2
27095: ,x_msg_count OUT NOCOPY NUMBER
27096: ,x_msg_data OUT NOCOPY VARCHAR2
27089: ,p_commit IN VARCHAR2
27090: ,p_init_msg_list IN VARCHAR2
27091: ,p_validation_level IN NUMBER
27092: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
27093: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
27094: ,x_return_status OUT NOCOPY VARCHAR2
27095: ,x_msg_count OUT NOCOPY NUMBER
27096: ,x_msg_data OUT NOCOPY VARCHAR2
27097: )
27101: l_api_version CONSTANT NUMBER := 1.0;
27102: l_debug_level NUMBER;
27103: l_msg_index NUMBER;
27104: l_msg_count NUMBER;
27105: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
27106: BEGIN
27107:
27108: -- Standard Start of API savepoint
27109: SAVEPOINT expire_extended_attrib_values;
27281: p_api_version IN NUMBER
27282: ,p_commit IN VARCHAR2
27283: ,p_init_msg_list IN VARCHAR2
27284: ,p_validation_level IN NUMBER
27285: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
27286: ,p_copy_ext_attribs IN VARCHAR2
27287: ,p_copy_org_assignments IN VARCHAR2
27288: ,p_copy_parties IN VARCHAR2
27289: ,p_copy_contacts IN VARCHAR2
27291: ,p_copy_asset_assignments IN VARCHAR2
27292: ,p_copy_pricing_attribs IN VARCHAR2
27293: ,p_call_from_split IN VARCHAR2
27294: ,p_call_from_bom_expl IN VARCHAR2
27295: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
27296: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
27297: ,x_return_status OUT NOCOPY VARCHAR2
27298: ,x_msg_count OUT NOCOPY NUMBER
27299: ,x_msg_data OUT NOCOPY VARCHAR2
27292: ,p_copy_pricing_attribs IN VARCHAR2
27293: ,p_call_from_split IN VARCHAR2
27294: ,p_call_from_bom_expl IN VARCHAR2
27295: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
27296: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
27297: ,x_return_status OUT NOCOPY VARCHAR2
27298: ,x_msg_count OUT NOCOPY NUMBER
27299: ,x_msg_data OUT NOCOPY VARCHAR2
27300: )
27302: IS
27303: l_api_name CONSTANT VARCHAR2(30) := 'copy_single_item_instance';
27304: l_api_version CONSTANT NUMBER := 1.0;
27305: l_debug_level NUMBER;
27306: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27307: l_new_instance_rec csi_datastructures_pub.instance_rec;
27308: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27309: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27303: l_api_name CONSTANT VARCHAR2(30) := 'copy_single_item_instance';
27304: l_api_version CONSTANT NUMBER := 1.0;
27305: l_debug_level NUMBER;
27306: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27307: l_new_instance_rec csi_datastructures_pub.instance_rec;
27308: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27309: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27304: l_api_version CONSTANT NUMBER := 1.0;
27305: l_debug_level NUMBER;
27306: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27307: l_new_instance_rec csi_datastructures_pub.instance_rec;
27308: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27309: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27305: l_debug_level NUMBER;
27306: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27307: l_new_instance_rec csi_datastructures_pub.instance_rec;
27308: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27309: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27306: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27307: l_new_instance_rec csi_datastructures_pub.instance_rec;
27308: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27309: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27307: l_new_instance_rec csi_datastructures_pub.instance_rec;
27308: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27309: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27308: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27309: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27309: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27310: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27311: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27312: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27313: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27314: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27315: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27316: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27324: l_party_input_tbl csi_datastructures_pub.party_tbl;
27317: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27324: l_party_input_tbl csi_datastructures_pub.party_tbl;
27325: l_new_party_tbl csi_datastructures_pub.party_tbl;
27318: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27324: l_party_input_tbl csi_datastructures_pub.party_tbl;
27325: l_new_party_tbl csi_datastructures_pub.party_tbl;
27326: l_contact_tbl csi_datastructures_pub.party_tbl;
27319: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27324: l_party_input_tbl csi_datastructures_pub.party_tbl;
27325: l_new_party_tbl csi_datastructures_pub.party_tbl;
27326: l_contact_tbl csi_datastructures_pub.party_tbl;
27327: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27320: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27324: l_party_input_tbl csi_datastructures_pub.party_tbl;
27325: l_new_party_tbl csi_datastructures_pub.party_tbl;
27326: l_contact_tbl csi_datastructures_pub.party_tbl;
27327: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27328: l_contact_found_flag BOOLEAN := FALSE;
27321: l_party_query_rec csi_datastructures_pub.party_query_rec;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27324: l_party_input_tbl csi_datastructures_pub.party_tbl;
27325: l_new_party_tbl csi_datastructures_pub.party_tbl;
27326: l_contact_tbl csi_datastructures_pub.party_tbl;
27327: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27328: l_contact_found_flag BOOLEAN := FALSE;
27329: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27322: l_party_tbl csi_datastructures_pub.party_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27324: l_party_input_tbl csi_datastructures_pub.party_tbl;
27325: l_new_party_tbl csi_datastructures_pub.party_tbl;
27326: l_contact_tbl csi_datastructures_pub.party_tbl;
27327: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27328: l_contact_found_flag BOOLEAN := FALSE;
27329: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27330: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27323: l_original_party_tbl csi_datastructures_pub.party_tbl;
27324: l_party_input_tbl csi_datastructures_pub.party_tbl;
27325: l_new_party_tbl csi_datastructures_pub.party_tbl;
27326: l_contact_tbl csi_datastructures_pub.party_tbl;
27327: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27328: l_contact_found_flag BOOLEAN := FALSE;
27329: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27330: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27331: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27325: l_new_party_tbl csi_datastructures_pub.party_tbl;
27326: l_contact_tbl csi_datastructures_pub.party_tbl;
27327: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27328: l_contact_found_flag BOOLEAN := FALSE;
27329: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27330: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27331: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27332: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27333: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27326: l_contact_tbl csi_datastructures_pub.party_tbl;
27327: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27328: l_contact_found_flag BOOLEAN := FALSE;
27329: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27330: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27331: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27332: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27333: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27334: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27327: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27328: l_contact_found_flag BOOLEAN := FALSE;
27329: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27330: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27331: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27332: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27333: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27334: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27335: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27328: l_contact_found_flag BOOLEAN := FALSE;
27329: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27330: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27331: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27332: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27333: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27334: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27335: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27336: l_msg_index NUMBER;
27329: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27330: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27331: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27332: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27333: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27334: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27335: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27336: l_msg_index NUMBER;
27337: l_msg_count NUMBER;
27330: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27331: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27332: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27333: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27334: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27335: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27336: l_msg_index NUMBER;
27337: l_msg_count NUMBER;
27338: l_attribute_level VARCHAR2(30);
27331: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27332: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27333: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27334: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27335: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27336: l_msg_index NUMBER;
27337: l_msg_count NUMBER;
27338: l_attribute_level VARCHAR2(30);
27339: l_vld_org_id NUMBER;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27351: l_version_label VARCHAR2(30);
27352: l_version_label_rec csi_datastructures_pub.version_label_rec;
27353: l_obj_id NUMBER;
27354: --
27355: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
27356: l_batch_type VARCHAR2(50);
29029: IF x_new_instance_tbl(1).instance_id IS NOT NULL AND
29030: x_new_instance_tbl(1).instance_id <> fnd_api.g_miss_num
29031: THEN
29032: -- Added by sk for fixing bug 2245976
29033: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
29034: csi_gen_utility_pvt.populate_install_param_rec;
29035: END IF;
29036: --
29037: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
29033: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
29034: csi_gen_utility_pvt.populate_install_param_rec;
29035: END IF;
29036: --
29037: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
29038: --
29039: IF l_internal_party_id IS NULL THEN
29040: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
29041: FND_MSG_PUB.ADD;
29193: p_api_version IN NUMBER
29194: ,p_commit IN VARCHAR2
29195: ,p_init_msg_list IN VARCHAR2
29196: ,p_validation_level IN NUMBER
29197: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
29198: ,p_explosion_level IN NUMBER
29199: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
29200: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
29201: ,p_create_instance IN VARCHAR2
29195: ,p_init_msg_list IN VARCHAR2
29196: ,p_validation_level IN NUMBER
29197: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
29198: ,p_explosion_level IN NUMBER
29199: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
29200: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
29201: ,p_create_instance IN VARCHAR2
29202: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
29203: ,x_return_status OUT NOCOPY VARCHAR2
29196: ,p_validation_level IN NUMBER
29197: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
29198: ,p_explosion_level IN NUMBER
29199: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
29200: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
29201: ,p_create_instance IN VARCHAR2
29202: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
29203: ,x_return_status OUT NOCOPY VARCHAR2
29204: ,x_msg_count OUT NOCOPY NUMBER
29198: ,p_explosion_level IN NUMBER
29199: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
29200: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
29201: ,p_create_instance IN VARCHAR2
29202: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
29203: ,x_return_status OUT NOCOPY VARCHAR2
29204: ,x_msg_count OUT NOCOPY NUMBER
29205: ,x_msg_data OUT NOCOPY VARCHAR2
29206: )
29223: l_csi_explode_bom VARCHAR2(30) := fnd_profile.value('CSI_EXPLODE_BOM');
29224: l_csi_bom_explosion_level NUMBER;
29225: l_ins_count NUMBER := 0;
29226: l_curr_parent VARCHAR2(240);
29227: x_ins_tbl csi_datastructures_pub.instance_tbl;
29228: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29229: l_source_instance_rec csi_datastructures_pub.instance_rec;
29230: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29231: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29224: l_csi_bom_explosion_level NUMBER;
29225: l_ins_count NUMBER := 0;
29226: l_curr_parent VARCHAR2(240);
29227: x_ins_tbl csi_datastructures_pub.instance_tbl;
29228: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29229: l_source_instance_rec csi_datastructures_pub.instance_rec;
29230: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29231: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29232: l_rel_count NUMBER := 0;
29225: l_ins_count NUMBER := 0;
29226: l_curr_parent VARCHAR2(240);
29227: x_ins_tbl csi_datastructures_pub.instance_tbl;
29228: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29229: l_source_instance_rec csi_datastructures_pub.instance_rec;
29230: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29231: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29232: l_rel_count NUMBER := 0;
29233: l_count NUMBER;
29226: l_curr_parent VARCHAR2(240);
29227: x_ins_tbl csi_datastructures_pub.instance_tbl;
29228: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29229: l_source_instance_rec csi_datastructures_pub.instance_rec;
29230: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29231: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29232: l_rel_count NUMBER := 0;
29233: l_count NUMBER;
29234: l_prev_parent VARCHAR2(240);
29227: x_ins_tbl csi_datastructures_pub.instance_tbl;
29228: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29229: l_source_instance_rec csi_datastructures_pub.instance_rec;
29230: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29231: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29232: l_rel_count NUMBER := 0;
29233: l_count NUMBER;
29234: l_prev_parent VARCHAR2(240);
29235: l_prev_child VARCHAR2(240);
29776: ,p_commit IN VARCHAR2
29777: ,p_init_msg_list IN VARCHAR2
29778: ,p_validation_level IN NUMBER
29779: ,p_transaction_id IN NUMBER
29780: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
29781: ,x_return_status OUT NOCOPY VARCHAR2
29782: ,x_msg_count OUT NOCOPY NUMBER
29783: ,x_msg_data OUT NOCOPY VARCHAR2
29784: ) IS
29786: SELECT *
29787: FROM csi_item_instances_h
29788: WHERE transaction_id = p_txn_id;
29789:
29790: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
29791: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
29792: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29793: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29794: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
29787: FROM csi_item_instances_h
29788: WHERE transaction_id = p_txn_id;
29789:
29790: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
29791: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
29792: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29793: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29794: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
29795: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
29788: WHERE transaction_id = p_txn_id;
29789:
29790: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
29791: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
29792: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29793: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29794: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
29795: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
29796: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
29789:
29790: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
29791: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
29792: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29793: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29794: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
29795: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
29796: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
29797: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
29790: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
29791: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
29792: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29793: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29794: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
29795: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
29796: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
29797: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
29798: l_api_version CONSTANT NUMBER := 1.0;
29791: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
29792: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29793: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29794: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
29795: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
29796: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
29797: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
29798: l_api_version CONSTANT NUMBER := 1.0;
29799: i NUMBER := 0;
29792: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29793: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
29794: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
29795: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
29796: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
29797: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
29798: l_api_version CONSTANT NUMBER := 1.0;
29799: i NUMBER := 0;
29800: l_time_stamp DATE;
29797: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
29798: l_api_version CONSTANT NUMBER := 1.0;
29799: i NUMBER := 0;
29800: l_time_stamp DATE;
29801: l_instance_rec csi_datastructures_pub.instance_header_rec;
29802: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
29803: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
29804: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
29805: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
29798: l_api_version CONSTANT NUMBER := 1.0;
29799: i NUMBER := 0;
29800: l_time_stamp DATE;
29801: l_instance_rec csi_datastructures_pub.instance_header_rec;
29802: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
29803: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
29804: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
29805: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
29806: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
29799: i NUMBER := 0;
29800: l_time_stamp DATE;
29801: l_instance_rec csi_datastructures_pub.instance_header_rec;
29802: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
29803: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
29804: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
29805: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
29806: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
29807: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
29800: l_time_stamp DATE;
29801: l_instance_rec csi_datastructures_pub.instance_header_rec;
29802: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
29803: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
29804: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
29805: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
29806: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
29807: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
29808: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
29801: l_instance_rec csi_datastructures_pub.instance_header_rec;
29802: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
29803: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
29804: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
29805: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
29806: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
29807: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
29808: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
29809: BEGIN
29802: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
29803: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
29804: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
29805: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
29806: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
29807: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
29808: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
29809: BEGIN
29810: /*
29803: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
29804: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
29805: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
29806: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
29807: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
29808: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
29809: BEGIN
29810: /*
29811: IF fnd_api.to_boolean(p_commit)
29804: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
29805: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
29806: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
29807: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
29808: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
29809: BEGIN
29810: /*
29811: IF fnd_api.to_boolean(p_commit)
29812: THEN
31686: ,p_commit IN VARCHAR2
31687: ,p_init_msg_list IN VARCHAR2
31688: ,p_validation_level IN NUMBER
31689: ,p_transaction_id IN NUMBER
31690: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
31691: ,x_return_status OUT NOCOPY VARCHAR2
31692: ,x_msg_count OUT NOCOPY NUMBER
31693: ,x_msg_data OUT NOCOPY VARCHAR2
31694: ) IS
31744: WHERE ieh.transaction_id = p_txn_id
31745: AND ieh.attribute_value_id = ie.attribute_value_id
31746: AND ie.attribute_id= iea.attribute_id;
31747:
31748: l_old_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
31749: l_new_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
31750: l_ext_header_rec csi_datastructures_pub.ext_attrib_val_history_rec;
31751: l_temp_ext_rec csi_datastructures_pub.ext_attrib_val_history_rec;
31752: l_api_name CONSTANT VARCHAR2(30) := 'get_ext_attrib_val_hist';
31745: AND ieh.attribute_value_id = ie.attribute_value_id
31746: AND ie.attribute_id= iea.attribute_id;
31747:
31748: l_old_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
31749: l_new_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
31750: l_ext_header_rec csi_datastructures_pub.ext_attrib_val_history_rec;
31751: l_temp_ext_rec csi_datastructures_pub.ext_attrib_val_history_rec;
31752: l_api_name CONSTANT VARCHAR2(30) := 'get_ext_attrib_val_hist';
31753: l_api_version CONSTANT NUMBER := 1.0;
31746: AND ie.attribute_id= iea.attribute_id;
31747:
31748: l_old_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
31749: l_new_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
31750: l_ext_header_rec csi_datastructures_pub.ext_attrib_val_history_rec;
31751: l_temp_ext_rec csi_datastructures_pub.ext_attrib_val_history_rec;
31752: l_api_name CONSTANT VARCHAR2(30) := 'get_ext_attrib_val_hist';
31753: l_api_version CONSTANT NUMBER := 1.0;
31754: i NUMBER := 0;
31747:
31748: l_old_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
31749: l_new_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
31750: l_ext_header_rec csi_datastructures_pub.ext_attrib_val_history_rec;
31751: l_temp_ext_rec csi_datastructures_pub.ext_attrib_val_history_rec;
31752: l_api_name CONSTANT VARCHAR2(30) := 'get_ext_attrib_val_hist';
31753: l_api_version CONSTANT NUMBER := 1.0;
31754: i NUMBER := 0;
31755: BEGIN
32070: ( p_api_version IN NUMBER
32071: ,p_commit IN VARCHAR2
32072: ,p_init_msg_list IN VARCHAR2
32073: ,p_validation_level IN NUMBER
32074: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
32075: ,p_copy_ext_attribs IN VARCHAR2
32076: ,p_copy_org_assignments IN VARCHAR2
32077: ,p_copy_parties IN VARCHAR2
32078: ,p_copy_contacts IN VARCHAR2
32080: ,p_copy_asset_assignments IN VARCHAR2
32081: ,p_copy_pricing_attribs IN VARCHAR2
32082: ,p_copy_inst_children IN VARCHAR2
32083: ,p_call_from_split IN VARCHAR2 -- Added
32084: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
32085: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
32086: ,x_return_status OUT NOCOPY VARCHAR2
32087: ,x_msg_count OUT NOCOPY NUMBER
32088: ,x_msg_data OUT NOCOPY VARCHAR2
32081: ,p_copy_pricing_attribs IN VARCHAR2
32082: ,p_copy_inst_children IN VARCHAR2
32083: ,p_call_from_split IN VARCHAR2 -- Added
32084: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
32085: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
32086: ,x_return_status OUT NOCOPY VARCHAR2
32087: ,x_msg_count OUT NOCOPY NUMBER
32088: ,x_msg_data OUT NOCOPY VARCHAR2
32089: )
32096: l_msg_index NUMBER;
32097: l_msg_count NUMBER;
32098: x_msg_index_out NUMBER;
32099: j NUMBER := 1;
32100: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32101: l_new_instance_rec csi_datastructures_pub.instance_rec;
32102: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32103: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32097: l_msg_count NUMBER;
32098: x_msg_index_out NUMBER;
32099: j NUMBER := 1;
32100: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32101: l_new_instance_rec csi_datastructures_pub.instance_rec;
32102: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32103: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32098: x_msg_index_out NUMBER;
32099: j NUMBER := 1;
32100: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32101: l_new_instance_rec csi_datastructures_pub.instance_rec;
32102: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32103: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32099: j NUMBER := 1;
32100: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32101: l_new_instance_rec csi_datastructures_pub.instance_rec;
32102: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32103: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32100: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32101: l_new_instance_rec csi_datastructures_pub.instance_rec;
32102: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32103: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32101: l_new_instance_rec csi_datastructures_pub.instance_rec;
32102: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32103: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32102: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32103: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32103: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32104: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32105: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32106: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32107: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32108: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32109: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32110: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32111: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32119: l_party_input_tbl csi_datastructures_pub.party_tbl;
32112: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32119: l_party_input_tbl csi_datastructures_pub.party_tbl;
32120: l_new_party_tbl csi_datastructures_pub.party_tbl;
32113: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32119: l_party_input_tbl csi_datastructures_pub.party_tbl;
32120: l_new_party_tbl csi_datastructures_pub.party_tbl;
32121: l_contact_tbl csi_datastructures_pub.party_tbl;
32114: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32119: l_party_input_tbl csi_datastructures_pub.party_tbl;
32120: l_new_party_tbl csi_datastructures_pub.party_tbl;
32121: l_contact_tbl csi_datastructures_pub.party_tbl;
32122: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32115: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32119: l_party_input_tbl csi_datastructures_pub.party_tbl;
32120: l_new_party_tbl csi_datastructures_pub.party_tbl;
32121: l_contact_tbl csi_datastructures_pub.party_tbl;
32122: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32123: l_contact_found_flag BOOLEAN := FALSE;
32116: l_party_query_rec csi_datastructures_pub.party_query_rec;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32119: l_party_input_tbl csi_datastructures_pub.party_tbl;
32120: l_new_party_tbl csi_datastructures_pub.party_tbl;
32121: l_contact_tbl csi_datastructures_pub.party_tbl;
32122: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32123: l_contact_found_flag BOOLEAN := FALSE;
32124: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32117: l_party_tbl csi_datastructures_pub.party_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32119: l_party_input_tbl csi_datastructures_pub.party_tbl;
32120: l_new_party_tbl csi_datastructures_pub.party_tbl;
32121: l_contact_tbl csi_datastructures_pub.party_tbl;
32122: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32123: l_contact_found_flag BOOLEAN := FALSE;
32124: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32125: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32118: l_original_party_tbl csi_datastructures_pub.party_tbl;
32119: l_party_input_tbl csi_datastructures_pub.party_tbl;
32120: l_new_party_tbl csi_datastructures_pub.party_tbl;
32121: l_contact_tbl csi_datastructures_pub.party_tbl;
32122: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32123: l_contact_found_flag BOOLEAN := FALSE;
32124: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32125: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32126: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32120: l_new_party_tbl csi_datastructures_pub.party_tbl;
32121: l_contact_tbl csi_datastructures_pub.party_tbl;
32122: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32123: l_contact_found_flag BOOLEAN := FALSE;
32124: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32125: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32126: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32127: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32121: l_contact_tbl csi_datastructures_pub.party_tbl;
32122: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32123: l_contact_found_flag BOOLEAN := FALSE;
32124: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32125: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32126: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32127: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32122: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32123: l_contact_found_flag BOOLEAN := FALSE;
32124: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32125: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32126: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32127: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32123: l_contact_found_flag BOOLEAN := FALSE;
32124: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32125: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32126: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32127: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32124: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32125: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32126: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32127: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32132: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32125: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32126: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32127: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32132: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32133: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32126: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32127: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32132: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32133: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32134: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32127: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32132: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32133: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32134: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32135: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32128: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32132: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32133: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32134: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32135: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32136: l_parent_object_found_flag VARCHAR2(1);
32129: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32132: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32133: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32134: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32135: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32136: l_parent_object_found_flag VARCHAR2(1);
32137: l_attribute_level VARCHAR2(30);
32130: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32132: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32133: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32134: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32135: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32136: l_parent_object_found_flag VARCHAR2(1);
32137: l_attribute_level VARCHAR2(30);
32138: l_temp_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32131: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32132: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32133: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32134: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32135: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32136: l_parent_object_found_flag VARCHAR2(1);
32137: l_attribute_level VARCHAR2(30);
32138: l_temp_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32139: l_pty_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32134: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32135: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32136: l_parent_object_found_flag VARCHAR2(1);
32137: l_attribute_level VARCHAR2(30);
32138: l_temp_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32139: l_pty_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32140: k NUMBER;
32141: l_vld_org_id NUMBER;
32142: l_internal_party_id NUMBER;
32135: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32136: l_parent_object_found_flag VARCHAR2(1);
32137: l_attribute_level VARCHAR2(30);
32138: l_temp_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32139: l_pty_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32140: k NUMBER;
32141: l_vld_org_id NUMBER;
32142: l_internal_party_id NUMBER;
32143: l_party_id NUMBER;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32159: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32160: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32161: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
32162: l_obj_id NUMBER;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32159: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32160: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32161: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
32162: l_obj_id NUMBER;
32163: --
32156: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32159: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32160: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32161: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
32162: l_obj_id NUMBER;
32163: --
32164: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
33785: IF x_new_instance_tbl(1).instance_id IS NOT NULL AND
33786: x_new_instance_tbl(1).instance_id <> fnd_api.g_miss_num
33787: THEN
33788: -- Added by sk for fixing bug 2245976
33789: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
33790: csi_gen_utility_pvt.populate_install_param_rec;
33791: END IF;
33792: --
33793: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
33789: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
33790: csi_gen_utility_pvt.populate_install_param_rec;
33791: END IF;
33792: --
33793: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
33794: --
33795: IF l_internal_party_id IS NULL THEN
33796: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
33797: FND_MSG_PUB.ADD;
34206: ,p_commit IN VARCHAR2
34207: ,p_init_msg_list IN VARCHAR2
34208: ,p_validation_level IN NUMBER
34209: ,p_transaction_id IN NUMBER
34210: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
34211: ,x_return_status OUT NOCOPY VARCHAR2
34212: ,x_msg_count OUT NOCOPY NUMBER
34213: ,x_msg_data OUT NOCOPY VARCHAR2
34214: )IS
34445: ,p_commit IN VARCHAR2
34446: ,p_init_msg_list IN VARCHAR2
34447: ,p_validation_level IN NUMBER
34448: ,p_instance_id IN NUMBER
34449: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
34450: ,x_return_status OUT NOCOPY VARCHAR2
34451: ,x_msg_count OUT NOCOPY NUMBER
34452: ,x_msg_data OUT NOCOPY VARCHAR2
34453: )IS
34455: l_api_name CONSTANT VARCHAR2(30) := 'GET_INSTANCE_LINK_LOCATIONS';
34456: l_api_version CONSTANT NUMBER := 1.0;
34457: l_debug_level NUMBER;
34458: l_flag VARCHAR2(1) := 'N';
34459: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
34460:
34461: BEGIN
34462: -- Standard Start of API savepoint
34463: -- SAVEPOINT get_instance_link_locations;
34613: p_api_version IN NUMBER
34614: ,p_commit IN VARCHAR2
34615: ,p_init_msg_list IN VARCHAR2
34616: ,p_validation_level IN NUMBER
34617: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
34618: ,x_return_status OUT NOCOPY VARCHAR2
34619: ,x_msg_count OUT NOCOPY NUMBER
34620: ,x_msg_data OUT NOCOPY VARCHAR2)
34621: IS
34631: l_return_status VARCHAR2(1);
34632: l_msg_data VARCHAR2(2000);
34633: l_msg_count NUMBER;
34634: l_msg_index NUMBER;
34635: l_version_label_rec csi_datastructures_pub.version_label_rec;
34636: l_temp_label_rec csi_datastructures_pub.version_label_rec;
34637: BEGIN
34638: SAVEPOINT Update_version_time;
34639:
34632: l_msg_data VARCHAR2(2000);
34633: l_msg_count NUMBER;
34634: l_msg_index NUMBER;
34635: l_version_label_rec csi_datastructures_pub.version_label_rec;
34636: l_temp_label_rec csi_datastructures_pub.version_label_rec;
34637: BEGIN
34638: SAVEPOINT Update_version_time;
34639:
34640: x_return_status := FND_API.G_RET_STS_SUCCESS;
34789: ,p_commit IN VARCHAR2
34790: ,p_init_msg_list IN VARCHAR2
34791: ,p_validation_level IN NUMBER
34792: ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
34793: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
34794: ,x_return_status OUT NOCOPY VARCHAR2
34795: ,x_msg_count OUT NOCOPY NUMBER
34796: ,x_msg_data OUT NOCOPY VARCHAR2
34797: )
34802: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
34803: l_root_node NUMBER;
34804: l_config_tbl csi_cz_int.config_tbl := px_config_tbl;
34805: l_count NUMBER;
34806: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
34807: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
34808: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
34809: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.config_tbl;
34810: l_root NUMBER:=0;
34804: l_config_tbl csi_cz_int.config_tbl := px_config_tbl;
34805: l_count NUMBER;
34806: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
34807: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
34808: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
34809: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.config_tbl;
34810: l_root NUMBER:=0;
34811: l_found VARCHAR2(1):='N';
34812: l_root_hdr_id NUMBER;
35563: ,p_init_msg_list IN VARCHAR2
35564: ,p_validation_level IN NUMBER
35565: ,p_config_tbl IN csi_cz_int.config_tbl
35566: ,p_unlock_all IN VARCHAR2
35567: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
35568: ,x_return_status OUT NOCOPY VARCHAR2
35569: ,x_msg_count OUT NOCOPY NUMBER
35570: ,x_msg_data OUT NOCOPY VARCHAR2
35571: )
35572: AS
35573: l_api_name CONSTANT VARCHAR2(30) := 'UNLOCK_ITEM_INSTANCES';
35574: l_api_version CONSTANT NUMBER := 1.0;
35575: l_csi_debug_level NUMBER;
35576: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
35577: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
35578: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
35579: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
35580: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35574: l_api_version CONSTANT NUMBER := 1.0;
35575: l_csi_debug_level NUMBER;
35576: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
35577: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
35578: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
35579: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
35580: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35581: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;
35582: l_unlock_count NUMBER;