[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';
2948:
2949: PROCEDURE Define_Inst_Columns
2950: (
2951: p_get_inst_cursor_id IN NUMBER,
2952: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
2953: ) IS
2954:
2955: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2956:
2951: p_get_inst_cursor_id IN NUMBER,
2952: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
2953: ) IS
2954:
2955: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
2956:
2957: BEGIN
2958:
2959: dbms_sql.define_column(p_get_inst_cursor_id, 1, l_instance_header_rec.instance_id);
2968: /*---------------------------------------------------------*/
2969:
2970: PROCEDURE Bind_Inst_variable
2971: (
2972: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
2973: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
2974: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
2975: p_transaction_id IN NUMBER,
2976: p_cur_get_inst_rel IN NUMBER
2969:
2970: PROCEDURE Bind_Inst_variable
2971: (
2972: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
2973: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
2974: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
2975: p_transaction_id IN NUMBER,
2976: p_cur_get_inst_rel IN NUMBER
2977: ) IS
2970: PROCEDURE Bind_Inst_variable
2971: (
2972: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
2973: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
2974: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
2975: p_transaction_id IN NUMBER,
2976: p_cur_get_inst_rel IN NUMBER
2977: ) IS
2978: BEGIN
3232: /*-----------------------------------------------------------*/
3233:
3234: PROCEDURE Gen_Inst_Where_Clause
3235: (
3236: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
3237: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
3238: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
3239: p_transaction_id IN NUMBER,
3240: x_select_stmt OUT NOCOPY VARCHAR2,
3233:
3234: PROCEDURE Gen_Inst_Where_Clause
3235: (
3236: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
3237: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
3238: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
3239: p_transaction_id IN NUMBER,
3240: x_select_stmt OUT NOCOPY VARCHAR2,
3241: p_active_instance_only IN VARCHAR2
3234: PROCEDURE Gen_Inst_Where_Clause
3235: (
3236: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
3237: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
3238: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
3239: p_transaction_id IN NUMBER,
3240: x_select_stmt OUT NOCOPY VARCHAR2,
3241: p_active_instance_only IN VARCHAR2
3242: ) IS
4265:
4266: PROCEDURE Get_Instance_Col_Values
4267: (
4268: p_get_instance_cur_id IN NUMBER,
4269: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
4270: ) IS
4271:
4272: BEGIN
4273: dbms_sql.column_value(p_get_instance_cur_id, 1, x_instance_rec.instance_id);
4394: (
4395: p_get_instance_cur_id IN NUMBER
4396: ) IS
4397:
4398: l_instance_rec csi_datastructures_pub.instance_header_rec;
4399:
4400: BEGIN
4401: dbms_sql.define_column(p_get_instance_cur_id, 1, l_instance_rec.instance_id);
4402: dbms_sql.define_column(p_get_instance_cur_id, 2, l_instance_rec.instance_number,30);
4517: /*---------------------------------------------------------*/
4518:
4519: PROCEDURE Bind_Instance_variable
4520: (
4521: p_instance_rec IN csi_datastructures_pub.instance_header_rec,
4522: p_cur_get_instance_rel IN NUMBER
4523: ) IS
4524:
4525: BEGIN
4544: p_api_version IN NUMBER
4545: ,p_commit IN VARCHAR2
4546: ,p_init_msg_list IN VARCHAR2
4547: ,p_validation_level IN NUMBER
4548: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
4549: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4550: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
4551: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4552: ,x_return_status OUT NOCOPY VARCHAR2
4545: ,p_commit IN VARCHAR2
4546: ,p_init_msg_list IN VARCHAR2
4547: ,p_validation_level IN NUMBER
4548: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
4549: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4550: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
4551: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4552: ,x_return_status OUT NOCOPY VARCHAR2
4553: ,x_msg_count OUT NOCOPY NUMBER
4546: ,p_init_msg_list IN VARCHAR2
4547: ,p_validation_level IN NUMBER
4548: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
4549: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4550: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
4551: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4552: ,x_return_status OUT NOCOPY VARCHAR2
4553: ,x_msg_count OUT NOCOPY NUMBER
4554: ,x_msg_data OUT NOCOPY VARCHAR2
4547: ,p_validation_level IN NUMBER
4548: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
4549: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4550: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
4551: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4552: ,x_return_status OUT NOCOPY VARCHAR2
4553: ,x_msg_count OUT NOCOPY NUMBER
4554: ,x_msg_data OUT NOCOPY VARCHAR2
4555: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4565: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ITEM_INSTANCE_PVT';
4566: l_api_version CONSTANT NUMBER := 1.0;
4567: l_debug_level NUMBER;
4568: l_instance_id NUMBER;
4569: l_party_owner_rec csi_datastructures_pub.party_rec;
4570: l_csi_item_instance_h_id NUMBER;
4571: l_old_oks_cp_rec OKS_IBINT_PUB.CP_REC_TYPE;
4572: l_new_oks_cp_rec OKS_IBINT_PUB.CP_REC_TYPE;
4573: l_ctr_grp_id_template NUMBER;
4577: l_msg_count NUMBER;
4578: l_msg_data VARCHAR2(100);
4579: l_msg_index NUMBER;
4580: l_line_count NUMBER;
4581: l_version_label_rec csi_datastructures_pub.version_label_rec;
4582: l_process_flag BOOLEAN := TRUE;
4583: l_return_value BOOLEAN;
4584: l_owner NUMBER;
4585: l_owner_count NUMBER := 0;
4614: l_component_ins_type VARCHAR2(1):=NULL ;
4615: l_config_hdr_id NUMBER;
4616: l_config_rev_nbr NUMBER;
4617: l_terminated_flag VARCHAR2(1);
4618: l_check_instance_rec csi_datastructures_pub.instance_rec;
4619: l_prior_txn_id NUMBER;
4620: l_ins_flag VARCHAR2(1);
4621: l_eam_item BOOLEAN := FALSE;
4622: l_eam_item_type NUMBER;
4627: l_gen_object_id NUMBER;
4628: l_equipment_type NUMBER;
4629: --
4630: -- Added variables for bug 8516781, FP bug 8551918
4631: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4632: l_instance_id_lst csi_datastructures_pub.id_tbl;
4633: l_msg_data VARCHAR2(2000);
4634:
4635: l_transaction_type_id NUMBER := 0;
4628: l_equipment_type NUMBER;
4629: --
4630: -- Added variables for bug 8516781, FP bug 8551918
4631: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4632: l_instance_id_lst csi_datastructures_pub.id_tbl;
4633: l_msg_data VARCHAR2(2000);
4634:
4635: l_transaction_type_id NUMBER := 0;
4636: l_serial_tagged NUMBER := 1;
5377: FND_MSG_PUB.Add;
5378: RAISE fnd_api.g_exc_error;
5379: END IF;
5380: --
5381: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5382: csi_gen_utility_pvt.populate_install_param_rec;
5383: END IF;
5384: --
5385: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5381: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5382: csi_gen_utility_pvt.populate_install_param_rec;
5383: END IF;
5384: --
5385: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5386: --
5387: IF l_int_party_id IS NULL THEN
5388: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5389: FND_MSG_PUB.ADD;
6635: /* the columns related to instance */
6636: /* are changing */
6637: /*---------------------------------------------------*/
6638:
6639: FUNCTION Anything_To_Update(p_instance_rec csi_datastructures_pub.instance_rec)
6640:
6641: RETURN BOOLEAN
6642: IS
6643:
6875: ,p_init_msg_list IN VARCHAR2
6876: ,p_validation_level IN NUMBER
6877: ,p_instance_id IN NUMBER
6878: ,p_instance_expiry_flag IN VARCHAR2
6879: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6880: ,x_acct_class_code OUT NOCOPY VARCHAR2
6881: ,x_return_status OUT NOCOPY VARCHAR2
6882: ,x_msg_count OUT NOCOPY NUMBER
6883: ,x_msg_data OUT NOCOPY VARCHAR2
6891: l_acct_class_code VARCHAR2(10);
6892: l_accounting_class VARCHAR2(10);
6893: l_loc_type_code VARCHAR2(30);
6894: --l_obj_ver_num NUMBER;
6895: l_instance_rec csi_datastructures_pub.instance_rec;
6896: l_instance_id_lst csi_datastructures_pub.id_tbl ;
6897: x_msg_index_out NUMBER;
6898: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6899: l_location_tbl csi_item_instance_pvt.location_tbl;
6892: l_accounting_class VARCHAR2(10);
6893: l_loc_type_code VARCHAR2(30);
6894: --l_obj_ver_num NUMBER;
6895: l_instance_rec csi_datastructures_pub.instance_rec;
6896: l_instance_id_lst csi_datastructures_pub.id_tbl ;
6897: x_msg_index_out NUMBER;
6898: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6899: l_location_tbl csi_item_instance_pvt.location_tbl;
6900: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
7080: (p_api_version IN NUMBER,
7081: p_commit IN VARCHAR2,
7082: p_init_msg_list IN VARCHAR2,
7083: p_validation_level IN NUMBER,
7084: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
7085: p_original_status_id IN NUMBER,
7086: p_original_system_id IN NUMBER,
7087: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7088: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
7083: p_validation_level IN NUMBER,
7084: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
7085: p_original_status_id IN NUMBER,
7086: p_original_system_id IN NUMBER,
7087: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7088: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
7089: x_return_status OUT NOCOPY VARCHAR2,
7090: p_unexpire IN VARCHAR2,
7091: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
7084: p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
7085: p_original_status_id IN NUMBER,
7086: p_original_system_id IN NUMBER,
7087: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7088: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
7089: x_return_status OUT NOCOPY VARCHAR2,
7090: p_unexpire IN VARCHAR2,
7091: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
7092: p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_tbl,
7099: l_api_version CONSTANT NUMBER := 1.0;
7100: l_debug_level NUMBER;
7101: l_instance_id NUMBER;
7102: l_dummy NUMBER;
7103: l_instance_rec csi_datastructures_pub.instance_rec:=p_instance_rec;
7104: l_object_version_number NUMBER;
7105: l_return_value BOOLEAN;
7106: l_csi_item_instance_h_id NUMBER;
7107: l_full_dump_frequency NUMBER;
7108: l_mod_value NUMBER;
7109: l_dump_flag VARCHAR2(1);
7110: l_msg_index NUMBER;
7111: l_msg_count NUMBER;
7112: l_instance_hist_rec csi_datastructures_pub.instance_history_rec;
7113: --Start of:Added for bug 5615169
7114: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7115: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7116: l_ciih_blk_ins_cnt NUMBER := 0;
7110: l_msg_index NUMBER;
7111: l_msg_count NUMBER;
7112: l_instance_hist_rec csi_datastructures_pub.instance_history_rec;
7113: --Start of:Added for bug 5615169
7114: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7115: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7116: l_ciih_blk_ins_cnt NUMBER := 0;
7117: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7118: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7461: l_ins_hist_id NUMBER;
7462: l_ins_hist_csr ins_hist_csr%ROWTYPE;
7463: l_last_vld_organization_id NUMBER;
7464: l_child_temp VARCHAR2(1);
7465: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
7466: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
7467: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
7468: l_vld_org_id NUMBER;
7469: PROCESS_NEXT EXCEPTION;
7462: l_ins_hist_csr ins_hist_csr%ROWTYPE;
7463: l_last_vld_organization_id NUMBER;
7464: l_child_temp VARCHAR2(1);
7465: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
7466: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
7467: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
7468: l_vld_org_id NUMBER;
7469: PROCESS_NEXT EXCEPTION;
7470: l_instance_status_id NUMBER;
7528: p_init_msg_list );
7529: END IF;
7530:
7531: -- Start API body
7532: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7533: csi_gen_utility_pvt.populate_install_param_rec;
7534: END IF;
7535: --
7536: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7532: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7533: csi_gen_utility_pvt.populate_install_param_rec;
7534: END IF;
7535: --
7536: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7537: --
7538: IF l_internal_party_id IS NULL THEN
7539: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
7540: FND_MSG_PUB.ADD;
7993: END IF; --p_instance_rec.ACCOUNTING_CLASS_CODE
7994: END IF;
7995: -- Get the full_dump_frequency from csi_install_parameter
7996: --
7997: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7998: csi_gen_utility_pvt.populate_install_param_rec;
7999: END IF;
8000: --
8001: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
7997: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7998: csi_gen_utility_pvt.populate_install_param_rec;
7999: END IF;
8000: --
8001: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
8002: --
8003: IF l_full_dump_frequency IS NULL THEN
8004: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
8005: FND_MSG_PUB.ADD;
10444: --Start of:Added for Bug:5615169
10445: IF l_inst_hist_tbl_blk_ins.count > 0 THEN -- BUG#6203160
10446: --Do the ciih bulk insert
10447: --Convert PL/SQl table to column table
10448: build_inst_hist_rec_of_table ( p_inst_hist_tbl => l_inst_hist_tbl_blk_ins -- csi_datastructures_pub.instance_history_tbl
10449: ,p_inst_hist_rec_tab => l_inst_hist_rec_tab -- csi_item_instance_grp.instance_history_rec_tab
10450: );
10451: --Do the actual bulk Insert
10452: -- Modified OLD_LAST_OE_AGREEMENT_ID, NEW_LAST_OE_AGREEMENT_ID for the bug 6967129
11086: END IF;
11087: --
11088: csi_gen_utility_pvt.put_line('Begin Call_to_Contracts : '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
11089: csi_gen_utility_pvt.put_line('Contracts Transaction Type: '||p_transaction_type);
11090: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
11091: csi_gen_utility_pvt.populate_install_param_rec;
11092: END IF;
11093: --
11094: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
11090: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
11091: csi_gen_utility_pvt.populate_install_param_rec;
11092: END IF;
11093: --
11094: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
11095: --
11096: IF l_internal_party_id IS NULL THEN
11097: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
11098: FND_MSG_PUB.ADD;
11603: RAISE fnd_api.g_exc_error;
11604: END Call_to_Contracts;
11605:
11606: PROCEDURE update_txn_status(
11607: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
11608: x_return_status OUT nocopy varchar2)
11609: IS
11610: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
11611: l_msg_count number;
11649: p_api_version IN NUMBER
11650: ,p_commit IN VARCHAR2
11651: ,p_init_msg_list IN VARCHAR2
11652: ,p_validation_level IN NUMBER
11653: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
11654: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
11655: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
11656: ,x_return_status OUT NOCOPY VARCHAR2
11657: ,x_msg_count OUT NOCOPY NUMBER
11650: ,p_commit IN VARCHAR2
11651: ,p_init_msg_list IN VARCHAR2
11652: ,p_validation_level IN NUMBER
11653: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
11654: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
11655: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
11656: ,x_return_status OUT NOCOPY VARCHAR2
11657: ,x_msg_count OUT NOCOPY NUMBER
11658: ,x_msg_data OUT NOCOPY VARCHAR2
11651: ,p_init_msg_list IN VARCHAR2
11652: ,p_validation_level IN NUMBER
11653: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
11654: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
11655: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
11656: ,x_return_status OUT NOCOPY VARCHAR2
11657: ,x_msg_count OUT NOCOPY NUMBER
11658: ,x_msg_data OUT NOCOPY VARCHAR2
11659: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11670: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
11671: l_api_version CONSTANT NUMBER := 1.0;
11672: l_debug_level NUMBER;
11673: l_instance_id NUMBER;
11674: l_mod_curr_instance_rec csi_datastructures_pub.instance_rec;
11675: l_party_tbl csi_datastructures_pub.party_tbl;
11676: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11677: l_dummy VARCHAR2(1);
11678: l_instance_rec csi_datastructures_pub.instance_rec;
11671: l_api_version CONSTANT NUMBER := 1.0;
11672: l_debug_level NUMBER;
11673: l_instance_id NUMBER;
11674: l_mod_curr_instance_rec csi_datastructures_pub.instance_rec;
11675: l_party_tbl csi_datastructures_pub.party_tbl;
11676: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11677: l_dummy VARCHAR2(1);
11678: l_instance_rec csi_datastructures_pub.instance_rec;
11679: l_get_instance_rec csi_datastructures_pub.instance_rec;
11672: l_debug_level NUMBER;
11673: l_instance_id NUMBER;
11674: l_mod_curr_instance_rec csi_datastructures_pub.instance_rec;
11675: l_party_tbl csi_datastructures_pub.party_tbl;
11676: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11677: l_dummy VARCHAR2(1);
11678: l_instance_rec csi_datastructures_pub.instance_rec;
11679: l_get_instance_rec csi_datastructures_pub.instance_rec;
11680: l_check_instance_rec csi_datastructures_pub.instance_rec;
11674: l_mod_curr_instance_rec csi_datastructures_pub.instance_rec;
11675: l_party_tbl csi_datastructures_pub.party_tbl;
11676: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11677: l_dummy VARCHAR2(1);
11678: l_instance_rec csi_datastructures_pub.instance_rec;
11679: l_get_instance_rec csi_datastructures_pub.instance_rec;
11680: l_check_instance_rec csi_datastructures_pub.instance_rec;
11681: l_version_label_rec csi_datastructures_pub.version_label_rec;
11682: l_object_version_number NUMBER;
11675: l_party_tbl csi_datastructures_pub.party_tbl;
11676: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11677: l_dummy VARCHAR2(1);
11678: l_instance_rec csi_datastructures_pub.instance_rec;
11679: l_get_instance_rec csi_datastructures_pub.instance_rec;
11680: l_check_instance_rec csi_datastructures_pub.instance_rec;
11681: l_version_label_rec csi_datastructures_pub.version_label_rec;
11682: l_object_version_number NUMBER;
11683: l_return_value BOOLEAN;
11676: l_asset_tbl csi_datastructures_pub.instance_asset_rec;
11677: l_dummy VARCHAR2(1);
11678: l_instance_rec csi_datastructures_pub.instance_rec;
11679: l_get_instance_rec csi_datastructures_pub.instance_rec;
11680: l_check_instance_rec csi_datastructures_pub.instance_rec;
11681: l_version_label_rec csi_datastructures_pub.version_label_rec;
11682: l_object_version_number NUMBER;
11683: l_return_value BOOLEAN;
11684: l_csi_item_instance_h_id NUMBER;
11677: l_dummy VARCHAR2(1);
11678: l_instance_rec csi_datastructures_pub.instance_rec;
11679: l_get_instance_rec csi_datastructures_pub.instance_rec;
11680: l_check_instance_rec csi_datastructures_pub.instance_rec;
11681: l_version_label_rec csi_datastructures_pub.version_label_rec;
11682: l_object_version_number NUMBER;
11683: l_return_value BOOLEAN;
11684: l_csi_item_instance_h_id NUMBER;
11685: l_full_dump_frequency NUMBER;
11695: l_dump_flag VARCHAR2(1);
11696: l_msg_index NUMBER;
11697: l_msg_count NUMBER;
11698: l_msg_dummy NUMBER;
11699: l_party_rec csi_datastructures_pub.party_rec;
11700: l_party_owner_rec csi_datastructures_pub.party_rec;
11701: l_location_type_code VARCHAR2(20);
11702: l_location_id NUMBER;
11703: l_inv_organization_id NUMBER;
11696: l_msg_index NUMBER;
11697: l_msg_count NUMBER;
11698: l_msg_dummy NUMBER;
11699: l_party_rec csi_datastructures_pub.party_rec;
11700: l_party_owner_rec csi_datastructures_pub.party_rec;
11701: l_location_type_code VARCHAR2(20);
11702: l_location_id NUMBER;
11703: l_inv_organization_id NUMBER;
11704: l_inv_subinventory_name VARCHAR2(10);
11727: -- Counter ref r12 changes
11728: l_desc_flex CSI_CTR_DATASTRUCTURES_PUB.DFF_REC_TYPE;
11729: l_delete_status VARCHAR2(1);
11730: l_exists VARCHAR2(1);
11731: l_instance_hist_rec csi_datastructures_pub.instance_history_rec;
11732: l_prior_txn_id NUMBER;
11733: l_oe_line_id NUMBER;
11734: l_install_date DATE;
11735: l_current_val NUMBER;
11736: l_txn_status varchar2(10) := 'COMPLETE';
11737: l_part_or_serial_change BOOLEAN := FALSE; --6176621
11738: l_number_open_ro NUMBER;
11739: --
11740: l_mtl_txn_tbl CSI_DATASTRUCTURES_PUB.MTL_TXN_TBL; -- Added for the bug 6875664, base bug 6531599
11741:
11742: -- Added variables for FP bug 8551918
11743: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
11744: l_instance_id_lst csi_datastructures_pub.id_tbl;
11739: --
11740: l_mtl_txn_tbl CSI_DATASTRUCTURES_PUB.MTL_TXN_TBL; -- Added for the bug 6875664, base bug 6531599
11741:
11742: -- Added variables for FP bug 8551918
11743: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
11744: l_instance_id_lst csi_datastructures_pub.id_tbl;
11745: l_msg_data VARCHAR2(2000);
11746:
11747: l_transaction_type_id NUMBER := 0;
11740: l_mtl_txn_tbl CSI_DATASTRUCTURES_PUB.MTL_TXN_TBL; -- Added for the bug 6875664, base bug 6531599
11741:
11742: -- Added variables for FP bug 8551918
11743: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
11744: l_instance_id_lst csi_datastructures_pub.id_tbl;
11745: l_msg_data VARCHAR2(2000);
11746:
11747: l_transaction_type_id NUMBER := 0;
11748: l_serial_tagged NUMBER := 1;
13687: END IF;
13688:
13689: -- Following code has been added for operational_status_code
13690: -- If owner is Internal then
13691: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
13692: --
13693: IF l_int_party_id IS NULL THEN
13694: select internal_party_id
13695: into l_int_party_id
15093: END IF;
15094:
15095: -- Get the full_dump_frequency from csi_install_parameter
15096: --
15097: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
15098: csi_gen_utility_pvt.populate_install_param_rec;
15099: END IF;
15100: --
15101: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
15097: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
15098: csi_gen_utility_pvt.populate_install_param_rec;
15099: END IF;
15100: --
15101: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
15102: --
15103: IF l_full_dump_frequency IS NULL THEN
15104: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
15105: FND_MSG_PUB.ADD;
19329: ( p_api_version IN NUMBER,
19330: p_commit IN VARCHAR2,
19331: p_init_msg_list IN VARCHAR2,
19332: p_validation_level IN NUMBER,
19333: p_instance_rec IN csi_datastructures_pub.instance_rec,
19334: p_expire_children IN VARCHAR2,
19335: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
19336: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
19337: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
19331: p_init_msg_list IN VARCHAR2,
19332: p_validation_level IN NUMBER,
19333: p_instance_rec IN csi_datastructures_pub.instance_rec,
19334: p_expire_children IN VARCHAR2,
19335: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
19336: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
19337: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
19338: x_return_status OUT NOCOPY VARCHAR2,
19339: x_msg_count OUT NOCOPY NUMBER,
19332: p_validation_level IN NUMBER,
19333: p_instance_rec IN csi_datastructures_pub.instance_rec,
19334: p_expire_children IN VARCHAR2,
19335: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
19336: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
19337: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
19338: x_return_status OUT NOCOPY VARCHAR2,
19339: x_msg_count OUT NOCOPY NUMBER,
19340: x_msg_data OUT NOCOPY VARCHAR2
19343: l_api_version CONSTANT NUMBER := 1.0;
19344: l_debug_level NUMBER;
19345: l_instance_id NUMBER;
19346: l_dummy NUMBER;
19347: l_instance_rec csi_datastructures_pub.instance_rec:=p_instance_rec;
19348: l_object_version_number NUMBER;
19349: l_return_value BOOLEAN;
19350: l_csi_item_instance_h_id NUMBER;
19351: l_full_dump_frequency NUMBER;
19350: l_csi_item_instance_h_id NUMBER;
19351: l_full_dump_frequency NUMBER;
19352: l_mod_value NUMBER;
19353: l_dump_flag VARCHAR2(1);
19354: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
19355: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
19356: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
19357:
19358: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS
19351: l_full_dump_frequency NUMBER;
19352: l_mod_value NUMBER;
19353: l_dump_flag VARCHAR2(1);
19354: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
19355: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
19356: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
19357:
19358: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS
19359: SELECT
19831: RAISE FND_API.G_EXC_ERROR;
19832: END IF;
19833:
19834: -- Get the full_dump_frequency from csi_install_parameter
19835: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
19836: csi_gen_utility_pvt.populate_install_param_rec;
19837: END IF;
19838: --
19839: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
19835: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
19836: csi_gen_utility_pvt.populate_install_param_rec;
19837: END IF;
19838: --
19839: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
19840: --
19841: IF l_full_dump_frequency IS NULL THEN
19842: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
19843: FND_MSG_PUB.ADD;
20434: p_api_version IN NUMBER
20435: ,p_commit IN VARCHAR2
20436: ,p_init_msg_list IN VARCHAR2
20437: ,p_validation_level IN NUMBER
20438: ,p_instance_rec IN csi_datastructures_pub.instance_rec
20439: ,p_expire_children IN VARCHAR2
20440: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
20441: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
20442: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
20436: ,p_init_msg_list IN VARCHAR2
20437: ,p_validation_level IN NUMBER
20438: ,p_instance_rec IN csi_datastructures_pub.instance_rec
20439: ,p_expire_children IN VARCHAR2
20440: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
20441: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
20442: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
20443: ,x_return_status OUT NOCOPY VARCHAR2
20444: ,x_msg_count OUT NOCOPY NUMBER
20437: ,p_validation_level IN NUMBER
20438: ,p_instance_rec IN csi_datastructures_pub.instance_rec
20439: ,p_expire_children IN VARCHAR2
20440: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
20441: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
20442: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
20443: ,x_return_status OUT NOCOPY VARCHAR2
20444: ,x_msg_count OUT NOCOPY NUMBER
20445: ,x_msg_data OUT NOCOPY VARCHAR2
20449: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_ITEM_NSTANCE';
20450: l_api_version CONSTANT NUMBER := 1.0;
20451: l_debug_level NUMBER;
20452: l_instance_id NUMBER;
20453: l_instance_rec csi_datastructures_pub.instance_rec;
20454: l_temp_instance_rec csi_datastructures_pub.instance_rec;
20455: l_csi_item_instance_h_id NUMBER;
20456: l_full_dump_frequency NUMBER;
20457: l_mod_value NUMBER;
20450: l_api_version CONSTANT NUMBER := 1.0;
20451: l_debug_level NUMBER;
20452: l_instance_id NUMBER;
20453: l_instance_rec csi_datastructures_pub.instance_rec;
20454: l_temp_instance_rec csi_datastructures_pub.instance_rec;
20455: l_csi_item_instance_h_id NUMBER;
20456: l_full_dump_frequency NUMBER;
20457: l_mod_value NUMBER;
20458: l_dump_flag VARCHAR2(1);
20457: l_mod_value NUMBER;
20458: l_dump_flag VARCHAR2(1);
20459: l_dummy NUMBER;
20460: -- Added variables for bug 6788183
20461: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
20462: l_instance_id_lst csi_datastructures_pub.id_tbl;
20463: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
20464: l_msg_data VARCHAR2(2000);
20465:
20458: l_dump_flag VARCHAR2(1);
20459: l_dummy NUMBER;
20460: -- Added variables for bug 6788183
20461: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
20462: l_instance_id_lst csi_datastructures_pub.id_tbl;
20463: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
20464: l_msg_data VARCHAR2(2000);
20465:
20466: CURSOR get_instance_rec(p_instance_id IN NUMBER) IS
20758:
20759: DECLARE
20760: l_dummy NUMBER;
20761: l_has_unexpired_children BOOLEAN;
20762: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
20763: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
20764: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
20765: BEGIN
20766: p_rel_query_rec.object_id := p_instance_rec.instance_id;
20759: DECLARE
20760: l_dummy NUMBER;
20761: l_has_unexpired_children BOOLEAN;
20762: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
20763: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
20764: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
20765: BEGIN
20766: p_rel_query_rec.object_id := p_instance_rec.instance_id;
20767: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
21128: csi_item_instance_vld_pvt.get_csi_item_instance_h_id;
21129:
21130: -- Get the full_dump_frequency from csi_install_parameter
21131: --
21132: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
21133: csi_gen_utility_pvt.populate_install_param_rec;
21134: END IF;
21135: --
21136: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
21132: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
21133: csi_gen_utility_pvt.populate_install_param_rec;
21134: END IF;
21135: --
21136: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
21137: --
21138: IF l_full_dump_frequency IS NULL THEN
21139: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
21140: FND_MSG_PUB.ADD;
21968: p_api_version IN NUMBER
21969: ,p_commit IN VARCHAR2
21970: ,p_init_msg_list IN VARCHAR2
21971: ,p_validation_level IN NUMBER
21972: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
21973: ,p_quantity1 IN NUMBER
21974: ,p_quantity2 IN NUMBER
21975: ,p_copy_ext_attribs IN VARCHAR2
21976: ,p_copy_org_assignments IN VARCHAR2
21978: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
21979: ,p_copy_accounts IN VARCHAR2
21980: ,p_copy_asset_assignments IN VARCHAR2
21981: ,p_copy_pricing_attribs IN VARCHAR2
21982: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
21983: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
21984: ,x_return_status OUT NOCOPY VARCHAR2
21985: ,x_msg_count OUT NOCOPY NUMBER
21986: ,x_msg_data OUT NOCOPY VARCHAR2
21979: ,p_copy_accounts IN VARCHAR2
21980: ,p_copy_asset_assignments IN VARCHAR2
21981: ,p_copy_pricing_attribs IN VARCHAR2
21982: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
21983: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
21984: ,x_return_status OUT NOCOPY VARCHAR2
21985: ,x_msg_count OUT NOCOPY NUMBER
21986: ,x_msg_data OUT NOCOPY VARCHAR2
21987: )
21993: l_serialized NUMBER;
21994: l_return_value BOOLEAN;
21995: l_object_version_number NUMBER;
21996: l_quantity NUMBER;
21997: l_instance_id_lst csi_datastructures_pub.id_tbl;
21998: l_new_instance_rec csi_datastructures_pub.instance_rec;
21999: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
22000: l_msg_data VARCHAR2(2000);
22001: l_msg_index NUMBER;
21994: l_return_value BOOLEAN;
21995: l_object_version_number NUMBER;
21996: l_quantity NUMBER;
21997: l_instance_id_lst csi_datastructures_pub.id_tbl;
21998: l_new_instance_rec csi_datastructures_pub.instance_rec;
21999: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
22000: l_msg_data VARCHAR2(2000);
22001: l_msg_index NUMBER;
22002: l_msg_count NUMBER;
21995: l_object_version_number NUMBER;
21996: l_quantity NUMBER;
21997: l_instance_id_lst csi_datastructures_pub.id_tbl;
21998: l_new_instance_rec csi_datastructures_pub.instance_rec;
21999: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
22000: l_msg_data VARCHAR2(2000);
22001: l_msg_index NUMBER;
22002: l_msg_count NUMBER;
22003: x_msg_index_out NUMBER;
22003: x_msg_index_out NUMBER;
22004: l_old_oks_cp_rec oks_ibint_pub.cp_rec_type;
22005: l_new_oks_cp_rec oks_ibint_pub.cp_rec_type;
22006: l_transaction_type VARCHAR2(10);
22007: l_source_instance_rec csi_datastructures_pub.instance_rec := p_source_instance_rec;
22008: l_contracts_status VARCHAR2(3);
22009: l_new_instance_rec1 csi_datastructures_pub.instance_rec;
22010: l_internal_party_id NUMBER;
22011: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
22005: l_new_oks_cp_rec oks_ibint_pub.cp_rec_type;
22006: l_transaction_type VARCHAR2(10);
22007: l_source_instance_rec csi_datastructures_pub.instance_rec := p_source_instance_rec;
22008: l_contracts_status VARCHAR2(3);
22009: l_new_instance_rec1 csi_datastructures_pub.instance_rec;
22010: l_internal_party_id NUMBER;
22011: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
22012: l_location_tbl csi_item_instance_pvt.location_tbl;
22013: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
22012: l_location_tbl csi_item_instance_pvt.location_tbl;
22013: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
22014: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
22015: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
22016: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
22017: --
22018: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
22019: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
22020: l_batch_type VARCHAR2(50);
22477: p_api_version IN NUMBER
22478: ,p_commit IN VARCHAR2
22479: ,p_init_msg_list IN VARCHAR2
22480: ,p_validation_level IN NUMBER
22481: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
22482: ,p_copy_ext_attribs IN VARCHAR2
22483: ,p_copy_org_assignments IN VARCHAR2
22484: ,p_copy_parties IN VARCHAR2
22485: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
22485: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
22486: ,p_copy_accounts IN VARCHAR2
22487: ,p_copy_asset_assignments IN VARCHAR2
22488: ,p_copy_pricing_attribs IN VARCHAR2
22489: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
22490: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
22491: ,x_return_status OUT NOCOPY VARCHAR2
22492: ,x_msg_count OUT NOCOPY NUMBER
22493: ,x_msg_data OUT NOCOPY VARCHAR2
22486: ,p_copy_accounts IN VARCHAR2
22487: ,p_copy_asset_assignments IN VARCHAR2
22488: ,p_copy_pricing_attribs IN VARCHAR2
22489: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
22490: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
22491: ,x_return_status OUT NOCOPY VARCHAR2
22492: ,x_msg_count OUT NOCOPY NUMBER
22493: ,x_msg_data OUT NOCOPY VARCHAR2
22494: )
22509: l_serialized NUMBER;
22510: l_return_value BOOLEAN;
22511: l_object_version_number NUMBER;
22512: l_quantity NUMBER;
22513: l_instance_id_lst csi_datastructures_pub.id_tbl;
22514: l_new_instance_rec csi_datastructures_pub.instance_rec;
22515: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
22516: l_count NUMBER;
22517: l_msg_data VARCHAR2(2000);
22510: l_return_value BOOLEAN;
22511: l_object_version_number NUMBER;
22512: l_quantity NUMBER;
22513: l_instance_id_lst csi_datastructures_pub.id_tbl;
22514: l_new_instance_rec csi_datastructures_pub.instance_rec;
22515: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
22516: l_count NUMBER;
22517: l_msg_data VARCHAR2(2000);
22518: l_msg_index NUMBER;
22511: l_object_version_number NUMBER;
22512: l_quantity NUMBER;
22513: l_instance_id_lst csi_datastructures_pub.id_tbl;
22514: l_new_instance_rec csi_datastructures_pub.instance_rec;
22515: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
22516: l_count NUMBER;
22517: l_msg_data VARCHAR2(2000);
22518: l_msg_index NUMBER;
22519: l_msg_count NUMBER;
22525: l_location_tbl csi_item_instance_pvt.location_tbl;
22526: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
22527: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
22528: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
22529: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
22530: --
22531: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
22532: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
22533: l_batch_type VARCHAR2(50);
22994: /*----------------------------------------------------------*/
22995:
22996: PROCEDURE Initialize_ver_rec_no_dump
22997: (
22998: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,
22999: p_version_label_id IN NUMBER ,
23000: x_no_dump IN OUT NOCOPY DATE
23001: ) IS
23002:
23070: /*----------------------------------------------------------*/
23071:
23072: PROCEDURE Initialize_ver_rec
23073: (
23074: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,
23075: p_version_label_hist_id IN NUMBER ,
23076: x_nearest_full_dump IN OUT NOCOPY DATE
23077: ) IS
23078:
23140: /*----------------------------------------------------------*/
23141:
23142: PROCEDURE Construct_ver_from_hist
23143: (
23144: x_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl,
23145: p_time_stamp IN DATE
23146: ) IS
23147:
23148: l_nearest_full_dump DATE := p_time_stamp;
23390:
23391: PROCEDURE Get_Ver_Column_Values
23392: (
23393: p_get_ver_cursor_id IN NUMBER ,
23394: x_ver_label_query_rec OUT NOCOPY csi_datastructures_pub.version_label_rec
23395: ) IS
23396: BEGIN
23397:
23398: dbms_sql.column_value(p_get_ver_cursor_id, 1, x_ver_label_query_rec.version_label_id);
23433: (
23434: p_get_ver_cursor_id IN NUMBER
23435: ) IS
23436:
23437: l_ver_label_rec csi_datastructures_pub.version_label_rec;
23438:
23439: BEGIN
23440:
23441: dbms_sql.define_column(p_get_ver_cursor_id, 1, l_ver_label_rec.version_label_id);
23471: /* cluase for Party relationship */
23472: /*----------------------------------------------------------*/
23473: PROCEDURE Bind_Ver_variable
23474: (
23475: p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec,
23476: p_get_ver_cursor_id IN NUMBER
23477: ) IS
23478:
23479: BEGIN
23506: /* cluase for Party relationship */
23507: /*----------------------------------------------------------*/
23508:
23509: PROCEDURE Gen_Ver_Where_Clause
23510: ( p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec
23511: ,x_where_clause OUT NOCOPY VARCHAR2
23512: ) IS
23513:
23514: BEGIN
23585: ( p_api_version IN NUMBER
23586: ,p_commit IN VARCHAR2
23587: ,p_init_msg_list IN VARCHAR2
23588: ,p_validation_level IN NUMBER
23589: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
23590: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
23591: ,x_return_status OUT NOCOPY VARCHAR2
23592: ,x_msg_count OUT NOCOPY NUMBER
23593: ,x_msg_data OUT NOCOPY VARCHAR2
23586: ,p_commit IN VARCHAR2
23587: ,p_init_msg_list IN VARCHAR2
23588: ,p_validation_level IN NUMBER
23589: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
23590: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
23591: ,x_return_status OUT NOCOPY VARCHAR2
23592: ,x_msg_count OUT NOCOPY NUMBER
23593: ,x_msg_data OUT NOCOPY VARCHAR2
23594: ) IS
23597: l_api_version CONSTANT NUMBER := 1.0 ;
23598: l_debug_level NUMBER ;
23599: l_process_flag BOOLEAN := TRUE ;
23600: l_msg_index NUMBER ;
23601: l_version_label_rec csi_datastructures_pub.version_label_rec;
23602: l_version_label_hist_id NUMBER ;
23603: l_flag VARCHAR2(1) :='N';
23604:
23605: BEGIN
23899: ( p_api_version IN NUMBER
23900: ,p_commit IN VARCHAR2
23901: ,p_init_msg_list IN VARCHAR2
23902: ,p_validation_level IN NUMBER
23903: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
23904: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
23905: ,p_call_transaction IN VARCHAR2
23906: ,x_return_status OUT NOCOPY VARCHAR2
23907: ,x_msg_count OUT NOCOPY NUMBER
23900: ,p_commit IN VARCHAR2
23901: ,p_init_msg_list IN VARCHAR2
23902: ,p_validation_level IN NUMBER
23903: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
23904: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
23905: ,p_call_transaction IN VARCHAR2
23906: ,x_return_status OUT NOCOPY VARCHAR2
23907: ,x_msg_count OUT NOCOPY NUMBER
23908: ,x_msg_data OUT NOCOPY VARCHAR2
23910:
23911: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_LABEL';
23912: l_api_version CONSTANT NUMBER := 1.0;
23913: l_debug_level NUMBER;
23914: l_version_label_rec csi_datastructures_pub.version_label_rec;
23915: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
23916: l_temp_ver_label_rec csi_datastructures_pub.version_label_rec;
23917: l_msg_index NUMBER;
23918: l_OBJECT_VERSION_NUMBER NUMBER;
23911: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_LABEL';
23912: l_api_version CONSTANT NUMBER := 1.0;
23913: l_debug_level NUMBER;
23914: l_version_label_rec csi_datastructures_pub.version_label_rec;
23915: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
23916: l_temp_ver_label_rec csi_datastructures_pub.version_label_rec;
23917: l_msg_index NUMBER;
23918: l_OBJECT_VERSION_NUMBER NUMBER;
23919: l_mod_value NUMBER;
23912: l_api_version CONSTANT NUMBER := 1.0;
23913: l_debug_level NUMBER;
23914: l_version_label_rec csi_datastructures_pub.version_label_rec;
23915: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
23916: l_temp_ver_label_rec csi_datastructures_pub.version_label_rec;
23917: l_msg_index NUMBER;
23918: l_OBJECT_VERSION_NUMBER NUMBER;
23919: l_mod_value NUMBER;
23920: l_version_label_hist_id NUMBER;
23920: l_version_label_hist_id NUMBER;
23921: x_msg_index_out NUMBER;
23922: l_full_dump_frequency NUMBER;
23923: l_flag VARCHAR2(1) :='N';
23924: l_ver_label_hist_rec csi_datastructures_pub.version_label_history_rec;
23925:
23926: CURSOR get_curr_ver_label_rec (p_ver_label_id IN NUMBER) IS
23927: SELECT
23928: VERSION_LABEL_ID ,
24110: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
24111:
24112: -- Get the full_dump_frequency from csi_install_parameter
24113: --
24114: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
24115: csi_gen_utility_pvt.populate_install_param_rec;
24116: END IF;
24117: --
24118: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
24114: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
24115: csi_gen_utility_pvt.populate_install_param_rec;
24116: END IF;
24117: --
24118: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
24119: --
24120: IF l_full_dump_frequency IS NULL THEN
24121: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
24122: FND_MSG_PUB.ADD;
25029: ( p_api_version IN NUMBER
25030: ,p_commit IN VARCHAR2
25031: ,p_init_msg_list IN VARCHAR2
25032: ,p_validation_level IN NUMBER
25033: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
25034: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
25035: ,x_return_status OUT NOCOPY VARCHAR2
25036: ,x_msg_count OUT NOCOPY NUMBER
25037: ,x_msg_data OUT NOCOPY VARCHAR2
25030: ,p_commit IN VARCHAR2
25031: ,p_init_msg_list IN VARCHAR2
25032: ,p_validation_level IN NUMBER
25033: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
25034: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
25035: ,x_return_status OUT NOCOPY VARCHAR2
25036: ,x_msg_count OUT NOCOPY NUMBER
25037: ,x_msg_data OUT NOCOPY VARCHAR2
25038: ) IS
25038: ) IS
25039: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_VERSION_LABEL';
25040: l_api_version CONSTANT NUMBER := 1.0;
25041: l_debug_level NUMBER;
25042: l_version_label_rec csi_datastructures_pub.version_label_rec;
25043: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
25044: l_msg_index NUMBER;
25045: l_OBJECT_VERSION_NUMBER NUMBER;
25046: l_mod_value NUMBER;
25039: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_VERSION_LABEL';
25040: l_api_version CONSTANT NUMBER := 1.0;
25041: l_debug_level NUMBER;
25042: l_version_label_rec csi_datastructures_pub.version_label_rec;
25043: l_curr_ver_label_rec csi_datastructures_pub.version_label_rec;
25044: l_msg_index NUMBER;
25045: l_OBJECT_VERSION_NUMBER NUMBER;
25046: l_mod_value NUMBER;
25047: l_version_label_hist_id NUMBER;
25225: -- Generate a unique instance_party_history_id from the sequence
25226: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
25227:
25228: -- Get the full_dump_frequency from csi_install_parameter
25229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
25230: csi_gen_utility_pvt.populate_install_param_rec;
25231: END IF;
25232: --
25233: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
25229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
25230: csi_gen_utility_pvt.populate_install_param_rec;
25231: END IF;
25232: --
25233: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
25234: --
25235: IF l_full_dump_frequency IS NULL THEN
25236: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
25237: FND_MSG_PUB.ADD;
25416: /*----------------------------------------------------------*/
25417:
25418: PROCEDURE Initialize_ext_rec_no_dump
25419: (
25420: x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,
25421: p_ext_id IN NUMBER,
25422: x_no_dump IN OUT NOCOPY DATE
25423: ) IS
25424:
25486: /*----------------------------------------------------------*/
25487:
25488: PROCEDURE Initialize_ext_rec
25489: (
25490: x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,
25491: p_ext_h_id IN NUMBER,
25492: x_nearest_full_dump IN OUT NOCOPY DATE
25493: ) IS
25494:
25552: /* from the history */
25553: /*----------------------------------------------------------*/
25554:
25555: PROCEDURE Construct_ext_from_hist
25556: ( x_ext_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
25557: p_time_stamp IN DATE
25558: ) IS
25559:
25560: l_nearest_full_dump DATE := p_time_stamp;
25558: ) IS
25559:
25560: l_nearest_full_dump DATE := p_time_stamp;
25561: l_att_val_hist_id NUMBER;
25562: l_ext_tbl csi_datastructures_pub.extend_attrib_values_tbl;
25563: l_ext_count NUMBER := 0;
25564: --
25565: Process_next EXCEPTION;
25566:
25805: PROCEDURE Define_ext_Columns
25806: ( p_get_ext_cursor_id IN NUMBER
25807: )
25808: IS
25809: l_ext_rec csi_datastructures_pub.extend_attrib_values_rec;
25810:
25811: BEGIN
25812: dbms_sql.define_column(p_get_ext_cursor_id, 1, l_ext_rec.attribute_value_id);
25813: dbms_sql.define_column(p_get_ext_cursor_id, 2, l_ext_rec.attribute_id);
25843: /*----------------------------------------------------------*/
25844:
25845: PROCEDURE Get_ext_Column_Values
25846: (p_get_ext_cursor_id IN NUMBER,
25847: x_ext_rec OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
25848: )
25849: IS
25850: BEGIN
25851: dbms_sql.column_value(p_get_ext_cursor_id, 1, x_ext_rec.attribute_value_id);
25884: /* for the Dynamic SQL */
25885: /*----------------------------------------------------------*/
25886:
25887: PROCEDURE Bind_ext_variable
25888: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec,
25889: p_cur_get_ext IN NUMBER
25890: )
25891: IS
25892: BEGIN
25917: /* clause for Extended Attributes units */
25918: /*----------------------------------------------------------*/
25919:
25920: PROCEDURE Gen_ext_Where_Clause
25921: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
25922: ,x_where_clause OUT NOCOPY VARCHAR2
25923: ) IS
25924:
25925: BEGIN
25980: p_api_version IN NUMBER
25981: ,p_commit IN VARCHAR2
25982: ,p_init_msg_list IN VARCHAR2
25983: ,p_validation_level IN NUMBER
25984: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
25985: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
25986: ,x_return_status OUT NOCOPY VARCHAR2
25987: ,x_msg_count OUT NOCOPY NUMBER
25988: ,x_msg_data OUT NOCOPY VARCHAR2
25981: ,p_commit IN VARCHAR2
25982: ,p_init_msg_list IN VARCHAR2
25983: ,p_validation_level IN NUMBER
25984: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
25985: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
25986: ,x_return_status OUT NOCOPY VARCHAR2
25987: ,x_msg_count OUT NOCOPY NUMBER
25988: ,x_msg_data OUT NOCOPY VARCHAR2
25989: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
26565: p_api_version IN NUMBER
26566: ,p_commit IN VARCHAR2
26567: ,p_init_msg_list IN VARCHAR2
26568: ,p_validation_level IN NUMBER
26569: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
26570: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
26571: ,x_return_status OUT NOCOPY VARCHAR2
26572: ,x_msg_count OUT NOCOPY NUMBER
26573: ,x_msg_data OUT NOCOPY VARCHAR2
26566: ,p_commit IN VARCHAR2
26567: ,p_init_msg_list IN VARCHAR2
26568: ,p_validation_level IN NUMBER
26569: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
26570: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
26571: ,x_return_status OUT NOCOPY VARCHAR2
26572: ,x_msg_count OUT NOCOPY NUMBER
26573: ,x_msg_data OUT NOCOPY VARCHAR2
26574: )
26584: l_attribute_value_id NUMBER:= p_ext_attrib_rec.attribute_value_id;
26585: l_attribute_value_h_id NUMBER;
26586: l_dump_frequency NUMBER;
26587: l_dump_frequency_flag VARCHAR2(30);
26588: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26589: l_temp_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26590: l_ext_att_hist_rec csi_datastructures_pub.ext_attrib_val_history_rec;
26591:
26592: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26585: l_attribute_value_h_id NUMBER;
26586: l_dump_frequency NUMBER;
26587: l_dump_frequency_flag VARCHAR2(30);
26588: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26589: l_temp_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26590: l_ext_att_hist_rec csi_datastructures_pub.ext_attrib_val_history_rec;
26591:
26592: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26593: SELECT *
26586: l_dump_frequency NUMBER;
26587: l_dump_frequency_flag VARCHAR2(30);
26588: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26589: l_temp_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
26590: l_ext_att_hist_rec csi_datastructures_pub.ext_attrib_val_history_rec;
26591:
26592: CURSOR ieav_hist_csr (p_ieav_hist_id NUMBER) IS
26593: SELECT *
26594: FROM csi_iea_values_h
27661: ( p_api_version IN NUMBER
27662: ,p_commit IN VARCHAR2
27663: ,p_init_msg_list IN VARCHAR2
27664: ,p_validation_level IN NUMBER
27665: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
27666: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
27667: ,x_return_status OUT NOCOPY VARCHAR2
27668: ,x_msg_count OUT NOCOPY NUMBER
27669: ,x_msg_data OUT NOCOPY VARCHAR2
27662: ,p_commit IN VARCHAR2
27663: ,p_init_msg_list IN VARCHAR2
27664: ,p_validation_level IN NUMBER
27665: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
27666: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
27667: ,x_return_status OUT NOCOPY VARCHAR2
27668: ,x_msg_count OUT NOCOPY NUMBER
27669: ,x_msg_data OUT NOCOPY VARCHAR2
27670: )
27674: l_api_version CONSTANT NUMBER := 1.0;
27675: l_debug_level NUMBER;
27676: l_msg_index NUMBER;
27677: l_msg_count NUMBER;
27678: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
27679: BEGIN
27680:
27681: -- Standard Start of API savepoint
27682: SAVEPOINT expire_extended_attrib_values;
27858: p_api_version IN NUMBER
27859: ,p_commit IN VARCHAR2
27860: ,p_init_msg_list IN VARCHAR2
27861: ,p_validation_level IN NUMBER
27862: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
27863: ,p_copy_ext_attribs IN VARCHAR2
27864: ,p_copy_org_assignments IN VARCHAR2
27865: ,p_copy_parties IN VARCHAR2
27866: ,p_copy_contacts IN VARCHAR2
27868: ,p_copy_asset_assignments IN VARCHAR2
27869: ,p_copy_pricing_attribs IN VARCHAR2
27870: ,p_call_from_split IN VARCHAR2
27871: ,p_call_from_bom_expl IN VARCHAR2
27872: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
27873: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
27874: ,x_return_status OUT NOCOPY VARCHAR2
27875: ,x_msg_count OUT NOCOPY NUMBER
27876: ,x_msg_data OUT NOCOPY VARCHAR2
27869: ,p_copy_pricing_attribs IN VARCHAR2
27870: ,p_call_from_split IN VARCHAR2
27871: ,p_call_from_bom_expl IN VARCHAR2
27872: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
27873: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
27874: ,x_return_status OUT NOCOPY VARCHAR2
27875: ,x_msg_count OUT NOCOPY NUMBER
27876: ,x_msg_data OUT NOCOPY VARCHAR2
27877: )
27879: IS
27880: l_api_name CONSTANT VARCHAR2(30) := 'copy_single_item_instance';
27881: l_api_version CONSTANT NUMBER := 1.0;
27882: l_debug_level NUMBER;
27883: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27884: l_new_instance_rec csi_datastructures_pub.instance_rec;
27885: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27886: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27880: l_api_name CONSTANT VARCHAR2(30) := 'copy_single_item_instance';
27881: l_api_version CONSTANT NUMBER := 1.0;
27882: l_debug_level NUMBER;
27883: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27884: l_new_instance_rec csi_datastructures_pub.instance_rec;
27885: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27886: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27881: l_api_version CONSTANT NUMBER := 1.0;
27882: l_debug_level NUMBER;
27883: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27884: l_new_instance_rec csi_datastructures_pub.instance_rec;
27885: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27886: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27882: l_debug_level NUMBER;
27883: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27884: l_new_instance_rec csi_datastructures_pub.instance_rec;
27885: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27886: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27883: l_curr_instance_rec csi_datastructures_pub.instance_rec;
27884: l_new_instance_rec csi_datastructures_pub.instance_rec;
27885: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27886: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27884: l_new_instance_rec csi_datastructures_pub.instance_rec;
27885: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27886: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27885: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
27886: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27886: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27887: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27888: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27889: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27890: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27891: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27892: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27893: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27901: l_party_input_tbl csi_datastructures_pub.party_tbl;
27894: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27901: l_party_input_tbl csi_datastructures_pub.party_tbl;
27902: l_new_party_tbl csi_datastructures_pub.party_tbl;
27895: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27901: l_party_input_tbl csi_datastructures_pub.party_tbl;
27902: l_new_party_tbl csi_datastructures_pub.party_tbl;
27903: l_contact_tbl csi_datastructures_pub.party_tbl;
27896: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27901: l_party_input_tbl csi_datastructures_pub.party_tbl;
27902: l_new_party_tbl csi_datastructures_pub.party_tbl;
27903: l_contact_tbl csi_datastructures_pub.party_tbl;
27904: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27897: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27901: l_party_input_tbl csi_datastructures_pub.party_tbl;
27902: l_new_party_tbl csi_datastructures_pub.party_tbl;
27903: l_contact_tbl csi_datastructures_pub.party_tbl;
27904: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27905: l_contact_found_flag BOOLEAN := FALSE;
27898: l_party_query_rec csi_datastructures_pub.party_query_rec;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27901: l_party_input_tbl csi_datastructures_pub.party_tbl;
27902: l_new_party_tbl csi_datastructures_pub.party_tbl;
27903: l_contact_tbl csi_datastructures_pub.party_tbl;
27904: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27905: l_contact_found_flag BOOLEAN := FALSE;
27906: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27899: l_party_tbl csi_datastructures_pub.party_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27901: l_party_input_tbl csi_datastructures_pub.party_tbl;
27902: l_new_party_tbl csi_datastructures_pub.party_tbl;
27903: l_contact_tbl csi_datastructures_pub.party_tbl;
27904: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27905: l_contact_found_flag BOOLEAN := FALSE;
27906: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27907: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27900: l_original_party_tbl csi_datastructures_pub.party_tbl;
27901: l_party_input_tbl csi_datastructures_pub.party_tbl;
27902: l_new_party_tbl csi_datastructures_pub.party_tbl;
27903: l_contact_tbl csi_datastructures_pub.party_tbl;
27904: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27905: l_contact_found_flag BOOLEAN := FALSE;
27906: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27907: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27908: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27902: l_new_party_tbl csi_datastructures_pub.party_tbl;
27903: l_contact_tbl csi_datastructures_pub.party_tbl;
27904: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27905: l_contact_found_flag BOOLEAN := FALSE;
27906: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27907: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27908: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27909: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27910: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27903: l_contact_tbl csi_datastructures_pub.party_tbl;
27904: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27905: l_contact_found_flag BOOLEAN := FALSE;
27906: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27907: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27908: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27909: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27910: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27911: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27904: l_contact_input_tbl csi_datastructures_pub.party_tbl;
27905: l_contact_found_flag BOOLEAN := FALSE;
27906: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27907: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27908: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27909: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27910: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27911: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27912: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27905: l_contact_found_flag BOOLEAN := FALSE;
27906: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27907: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27908: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27909: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27910: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27911: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27912: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27913: l_msg_index NUMBER;
27906: l_new_contact_tbl csi_datastructures_pub.party_tbl;
27907: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27908: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27909: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27910: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27911: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27912: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27913: l_msg_index NUMBER;
27914: l_msg_count NUMBER;
27907: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
27908: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27909: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27910: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27911: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27912: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27913: l_msg_index NUMBER;
27914: l_msg_count NUMBER;
27915: l_attribute_level VARCHAR2(30);
27908: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
27909: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
27910: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
27911: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
27912: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
27913: l_msg_index NUMBER;
27914: l_msg_count NUMBER;
27915: l_attribute_level VARCHAR2(30);
27916: l_vld_org_id NUMBER;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27927: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
27928: l_version_label VARCHAR2(30);
27929: l_version_label_rec csi_datastructures_pub.version_label_rec;
27930: l_obj_id NUMBER;
27931: --
27932: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
27933: l_batch_type VARCHAR2(50);
29606: IF x_new_instance_tbl(1).instance_id IS NOT NULL AND
29607: x_new_instance_tbl(1).instance_id <> fnd_api.g_miss_num
29608: THEN
29609: -- Added by sk for fixing bug 2245976
29610: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
29611: csi_gen_utility_pvt.populate_install_param_rec;
29612: END IF;
29613: --
29614: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
29610: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
29611: csi_gen_utility_pvt.populate_install_param_rec;
29612: END IF;
29613: --
29614: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
29615: --
29616: IF l_internal_party_id IS NULL THEN
29617: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
29618: FND_MSG_PUB.ADD;
29774: p_api_version IN NUMBER
29775: ,p_commit IN VARCHAR2
29776: ,p_init_msg_list IN VARCHAR2
29777: ,p_validation_level IN NUMBER
29778: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
29779: ,p_explosion_level IN NUMBER
29780: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
29781: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
29782: ,p_create_instance IN VARCHAR2
29776: ,p_init_msg_list IN VARCHAR2
29777: ,p_validation_level IN NUMBER
29778: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
29779: ,p_explosion_level IN NUMBER
29780: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
29781: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
29782: ,p_create_instance IN VARCHAR2
29783: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
29784: ,x_return_status OUT NOCOPY VARCHAR2
29777: ,p_validation_level IN NUMBER
29778: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
29779: ,p_explosion_level IN NUMBER
29780: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
29781: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
29782: ,p_create_instance IN VARCHAR2
29783: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
29784: ,x_return_status OUT NOCOPY VARCHAR2
29785: ,x_msg_count OUT NOCOPY NUMBER
29779: ,p_explosion_level IN NUMBER
29780: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
29781: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
29782: ,p_create_instance IN VARCHAR2
29783: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
29784: ,x_return_status OUT NOCOPY VARCHAR2
29785: ,x_msg_count OUT NOCOPY NUMBER
29786: ,x_msg_data OUT NOCOPY VARCHAR2
29787: )
29804: l_csi_explode_bom VARCHAR2(30) := fnd_profile.value('CSI_EXPLODE_BOM');
29805: l_csi_bom_explosion_level NUMBER;
29806: l_ins_count NUMBER := 0;
29807: l_curr_parent VARCHAR2(240);
29808: x_ins_tbl csi_datastructures_pub.instance_tbl;
29809: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29810: l_source_instance_rec csi_datastructures_pub.instance_rec;
29811: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29812: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29805: l_csi_bom_explosion_level NUMBER;
29806: l_ins_count NUMBER := 0;
29807: l_curr_parent VARCHAR2(240);
29808: x_ins_tbl csi_datastructures_pub.instance_tbl;
29809: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29810: l_source_instance_rec csi_datastructures_pub.instance_rec;
29811: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29812: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29813: l_rel_count NUMBER := 0;
29806: l_ins_count NUMBER := 0;
29807: l_curr_parent VARCHAR2(240);
29808: x_ins_tbl csi_datastructures_pub.instance_tbl;
29809: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29810: l_source_instance_rec csi_datastructures_pub.instance_rec;
29811: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29812: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29813: l_rel_count NUMBER := 0;
29814: l_count NUMBER;
29807: l_curr_parent VARCHAR2(240);
29808: x_ins_tbl csi_datastructures_pub.instance_tbl;
29809: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29810: l_source_instance_rec csi_datastructures_pub.instance_rec;
29811: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29812: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29813: l_rel_count NUMBER := 0;
29814: l_count NUMBER;
29815: l_prev_parent VARCHAR2(240);
29808: x_ins_tbl csi_datastructures_pub.instance_tbl;
29809: x_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
29810: l_source_instance_rec csi_datastructures_pub.instance_rec;
29811: x_new_ins_tbl csi_datastructures_pub.instance_tbl;
29812: l_init_source_instance_rec csi_datastructures_pub.instance_rec;
29813: l_rel_count NUMBER := 0;
29814: l_count NUMBER;
29815: l_prev_parent VARCHAR2(240);
29816: l_prev_child VARCHAR2(240);
30378: ,p_commit IN VARCHAR2
30379: ,p_init_msg_list IN VARCHAR2
30380: ,p_validation_level IN NUMBER
30381: ,p_transaction_id IN NUMBER
30382: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
30383: ,x_return_status OUT NOCOPY VARCHAR2
30384: ,x_msg_count OUT NOCOPY NUMBER
30385: ,x_msg_data OUT NOCOPY VARCHAR2
30386: ) IS
30388: SELECT *
30389: FROM csi_item_instances_h
30390: WHERE transaction_id = p_txn_id;
30391:
30392: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
30393: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
30394: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30395: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30396: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
30389: FROM csi_item_instances_h
30390: WHERE transaction_id = p_txn_id;
30391:
30392: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
30393: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
30394: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30395: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30396: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
30397: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
30390: WHERE transaction_id = p_txn_id;
30391:
30392: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
30393: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
30394: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30395: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30396: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
30397: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
30398: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
30391:
30392: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
30393: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
30394: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30395: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30396: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
30397: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
30398: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
30399: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
30392: l_old_ins_header_rec csi_datastructures_pub.instance_header_rec;
30393: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
30394: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30395: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30396: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
30397: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
30398: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
30399: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
30400: l_api_version CONSTANT NUMBER := 1.0;
30393: l_new_ins_header_rec csi_datastructures_pub.instance_header_rec;
30394: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30395: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30396: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
30397: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
30398: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
30399: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
30400: l_api_version CONSTANT NUMBER := 1.0;
30401: i NUMBER := 0;
30394: l_old_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30395: l_new_ins_header_tbl csi_datastructures_pub.instance_header_tbl;
30396: l_ins_header_rec csi_datastructures_pub.instance_history_rec;
30397: l_temp_ins_rec csi_datastructures_pub.instance_history_rec;
30398: l_temp_hdr_rec csi_datastructures_pub.instance_header_rec;
30399: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
30400: l_api_version CONSTANT NUMBER := 1.0;
30401: i NUMBER := 0;
30402: l_time_stamp DATE;
30399: l_api_name CONSTANT VARCHAR2(30) := 'get_instance_hist';
30400: l_api_version CONSTANT NUMBER := 1.0;
30401: i NUMBER := 0;
30402: l_time_stamp DATE;
30403: l_instance_rec csi_datastructures_pub.instance_header_rec;
30404: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
30405: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
30406: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
30407: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
30400: l_api_version CONSTANT NUMBER := 1.0;
30401: i NUMBER := 0;
30402: l_time_stamp DATE;
30403: l_instance_rec csi_datastructures_pub.instance_header_rec;
30404: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
30405: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
30406: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
30407: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
30408: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
30401: i NUMBER := 0;
30402: l_time_stamp DATE;
30403: l_instance_rec csi_datastructures_pub.instance_header_rec;
30404: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
30405: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
30406: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
30407: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
30408: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
30409: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
30402: l_time_stamp DATE;
30403: l_instance_rec csi_datastructures_pub.instance_header_rec;
30404: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
30405: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
30406: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
30407: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
30408: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
30409: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
30410: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
30403: l_instance_rec csi_datastructures_pub.instance_header_rec;
30404: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
30405: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
30406: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
30407: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
30408: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
30409: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
30410: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
30411: BEGIN
30404: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
30405: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
30406: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
30407: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
30408: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
30409: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
30410: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
30411: BEGIN
30412: /*
30405: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
30406: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
30407: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
30408: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
30409: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
30410: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
30411: BEGIN
30412: /*
30413: IF fnd_api.to_boolean(p_commit)
30406: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl;
30407: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
30408: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
30409: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
30410: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
30411: BEGIN
30412: /*
30413: IF fnd_api.to_boolean(p_commit)
30414: THEN
32304: ,p_commit IN VARCHAR2
32305: ,p_init_msg_list IN VARCHAR2
32306: ,p_validation_level IN NUMBER
32307: ,p_transaction_id IN NUMBER
32308: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
32309: ,x_return_status OUT NOCOPY VARCHAR2
32310: ,x_msg_count OUT NOCOPY NUMBER
32311: ,x_msg_data OUT NOCOPY VARCHAR2
32312: ) IS
32362: WHERE ieh.transaction_id = p_txn_id
32363: AND ieh.attribute_value_id = ie.attribute_value_id
32364: AND ie.attribute_id= iea.attribute_id;
32365:
32366: l_old_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
32367: l_new_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
32368: l_ext_header_rec csi_datastructures_pub.ext_attrib_val_history_rec;
32369: l_temp_ext_rec csi_datastructures_pub.ext_attrib_val_history_rec;
32370: l_api_name CONSTANT VARCHAR2(30) := 'get_ext_attrib_val_hist';
32363: AND ieh.attribute_value_id = ie.attribute_value_id
32364: AND ie.attribute_id= iea.attribute_id;
32365:
32366: l_old_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
32367: l_new_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
32368: l_ext_header_rec csi_datastructures_pub.ext_attrib_val_history_rec;
32369: l_temp_ext_rec csi_datastructures_pub.ext_attrib_val_history_rec;
32370: l_api_name CONSTANT VARCHAR2(30) := 'get_ext_attrib_val_hist';
32371: l_api_version CONSTANT NUMBER := 1.0;
32364: AND ie.attribute_id= iea.attribute_id;
32365:
32366: l_old_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
32367: l_new_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
32368: l_ext_header_rec csi_datastructures_pub.ext_attrib_val_history_rec;
32369: l_temp_ext_rec csi_datastructures_pub.ext_attrib_val_history_rec;
32370: l_api_name CONSTANT VARCHAR2(30) := 'get_ext_attrib_val_hist';
32371: l_api_version CONSTANT NUMBER := 1.0;
32372: i NUMBER := 0;
32365:
32366: l_old_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
32367: l_new_ext_header_rec csi_datastructures_pub.extend_attrib_values_rec;
32368: l_ext_header_rec csi_datastructures_pub.ext_attrib_val_history_rec;
32369: l_temp_ext_rec csi_datastructures_pub.ext_attrib_val_history_rec;
32370: l_api_name CONSTANT VARCHAR2(30) := 'get_ext_attrib_val_hist';
32371: l_api_version CONSTANT NUMBER := 1.0;
32372: i NUMBER := 0;
32373: BEGIN
32690: ( p_api_version IN NUMBER
32691: ,p_commit IN VARCHAR2
32692: ,p_init_msg_list IN VARCHAR2
32693: ,p_validation_level IN NUMBER
32694: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
32695: ,p_copy_ext_attribs IN VARCHAR2
32696: ,p_copy_org_assignments IN VARCHAR2
32697: ,p_copy_parties IN VARCHAR2
32698: ,p_copy_contacts IN VARCHAR2
32700: ,p_copy_asset_assignments IN VARCHAR2
32701: ,p_copy_pricing_attribs IN VARCHAR2
32702: ,p_copy_inst_children IN VARCHAR2
32703: ,p_call_from_split IN VARCHAR2 -- Added
32704: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
32705: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
32706: ,x_return_status OUT NOCOPY VARCHAR2
32707: ,x_msg_count OUT NOCOPY NUMBER
32708: ,x_msg_data OUT NOCOPY VARCHAR2
32701: ,p_copy_pricing_attribs IN VARCHAR2
32702: ,p_copy_inst_children IN VARCHAR2
32703: ,p_call_from_split IN VARCHAR2 -- Added
32704: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
32705: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
32706: ,x_return_status OUT NOCOPY VARCHAR2
32707: ,x_msg_count OUT NOCOPY NUMBER
32708: ,x_msg_data OUT NOCOPY VARCHAR2
32709: )
32716: l_msg_index NUMBER;
32717: l_msg_count NUMBER;
32718: x_msg_index_out NUMBER;
32719: j NUMBER := 1;
32720: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32721: l_new_instance_rec csi_datastructures_pub.instance_rec;
32722: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32723: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32717: l_msg_count NUMBER;
32718: x_msg_index_out NUMBER;
32719: j NUMBER := 1;
32720: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32721: l_new_instance_rec csi_datastructures_pub.instance_rec;
32722: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32723: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32718: x_msg_index_out NUMBER;
32719: j NUMBER := 1;
32720: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32721: l_new_instance_rec csi_datastructures_pub.instance_rec;
32722: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32723: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32719: j NUMBER := 1;
32720: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32721: l_new_instance_rec csi_datastructures_pub.instance_rec;
32722: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32723: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32720: l_curr_instance_rec csi_datastructures_pub.instance_rec;
32721: l_new_instance_rec csi_datastructures_pub.instance_rec;
32722: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32723: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32721: l_new_instance_rec csi_datastructures_pub.instance_rec;
32722: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32723: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32722: l_source_child_instance_rec csi_datastructures_pub.instance_rec;
32723: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32723: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32724: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;--rk
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32725: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32726: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32727: l_ext_attribs_query_rec csi_datastructures_pub.extend_attrib_query_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32728: l_ou_query_rec csi_datastructures_pub.organization_unit_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32729: l_org_unit_tbl csi_datastructures_pub.organization_units_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32730: l_org_unit_header_tbl csi_datastructures_pub.org_units_header_tbl;--rk
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32731: l_pricing_attribs_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32739: l_party_input_tbl csi_datastructures_pub.party_tbl;
32732: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32739: l_party_input_tbl csi_datastructures_pub.party_tbl;
32740: l_new_party_tbl csi_datastructures_pub.party_tbl;
32733: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32739: l_party_input_tbl csi_datastructures_pub.party_tbl;
32740: l_new_party_tbl csi_datastructures_pub.party_tbl;
32741: l_contact_tbl csi_datastructures_pub.party_tbl;
32734: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32739: l_party_input_tbl csi_datastructures_pub.party_tbl;
32740: l_new_party_tbl csi_datastructures_pub.party_tbl;
32741: l_contact_tbl csi_datastructures_pub.party_tbl;
32742: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32735: l_instance_asset_rec csi_datastructures_pub.instance_asset_rec;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32739: l_party_input_tbl csi_datastructures_pub.party_tbl;
32740: l_new_party_tbl csi_datastructures_pub.party_tbl;
32741: l_contact_tbl csi_datastructures_pub.party_tbl;
32742: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32743: l_contact_found_flag BOOLEAN := FALSE;
32736: l_party_query_rec csi_datastructures_pub.party_query_rec;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32739: l_party_input_tbl csi_datastructures_pub.party_tbl;
32740: l_new_party_tbl csi_datastructures_pub.party_tbl;
32741: l_contact_tbl csi_datastructures_pub.party_tbl;
32742: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32743: l_contact_found_flag BOOLEAN := FALSE;
32744: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32737: l_party_tbl csi_datastructures_pub.party_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32739: l_party_input_tbl csi_datastructures_pub.party_tbl;
32740: l_new_party_tbl csi_datastructures_pub.party_tbl;
32741: l_contact_tbl csi_datastructures_pub.party_tbl;
32742: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32743: l_contact_found_flag BOOLEAN := FALSE;
32744: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32745: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32738: l_original_party_tbl csi_datastructures_pub.party_tbl;
32739: l_party_input_tbl csi_datastructures_pub.party_tbl;
32740: l_new_party_tbl csi_datastructures_pub.party_tbl;
32741: l_contact_tbl csi_datastructures_pub.party_tbl;
32742: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32743: l_contact_found_flag BOOLEAN := FALSE;
32744: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32745: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32746: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32740: l_new_party_tbl csi_datastructures_pub.party_tbl;
32741: l_contact_tbl csi_datastructures_pub.party_tbl;
32742: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32743: l_contact_found_flag BOOLEAN := FALSE;
32744: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32745: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32746: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32747: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32741: l_contact_tbl csi_datastructures_pub.party_tbl;
32742: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32743: l_contact_found_flag BOOLEAN := FALSE;
32744: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32745: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32746: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32747: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32742: l_contact_input_tbl csi_datastructures_pub.party_tbl;
32743: l_contact_found_flag BOOLEAN := FALSE;
32744: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32745: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32746: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32747: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32743: l_contact_found_flag BOOLEAN := FALSE;
32744: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32745: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32746: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32747: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32744: l_new_contact_tbl csi_datastructures_pub.party_tbl;
32745: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32746: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32747: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32752: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32745: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
32746: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32747: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32752: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32753: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32746: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
32747: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32752: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32753: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32754: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32747: l_contact_account_query_rec csi_datastructures_pub.party_account_query_rec;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32752: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32753: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32754: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32755: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32748: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32752: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32753: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32754: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32755: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32756: l_parent_object_found_flag VARCHAR2(1);
32749: l_contact_account_tbl csi_datastructures_pub.party_account_tbl;
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32752: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32753: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32754: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32755: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32756: l_parent_object_found_flag VARCHAR2(1);
32757: l_attribute_level VARCHAR2(30);
32750: l_temp_party_account_tbl csi_datastructures_pub.party_account_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32752: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32753: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32754: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32755: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32756: l_parent_object_found_flag VARCHAR2(1);
32757: l_attribute_level VARCHAR2(30);
32758: l_temp_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32751: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
32752: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32753: l_new_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
32754: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32755: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32756: l_parent_object_found_flag VARCHAR2(1);
32757: l_attribute_level VARCHAR2(30);
32758: l_temp_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32759: l_pty_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32754: l_new_instance_tbl csi_datastructures_pub.instance_tbl;
32755: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32756: l_parent_object_found_flag VARCHAR2(1);
32757: l_attribute_level VARCHAR2(30);
32758: l_temp_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32759: l_pty_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32760: k NUMBER;
32761: l_vld_org_id NUMBER;
32762: l_internal_party_id NUMBER;
32755: l_new_child_instance_tbl csi_datastructures_pub.instance_tbl;
32756: l_parent_object_found_flag VARCHAR2(1);
32757: l_attribute_level VARCHAR2(30);
32758: l_temp_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32759: l_pty_acct_hdr_tbl csi_datastructures_pub.party_account_header_tbl;
32760: k NUMBER;
32761: l_vld_org_id NUMBER;
32762: l_internal_party_id NUMBER;
32763: l_party_id NUMBER;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32779: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32780: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32781: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
32782: l_obj_id NUMBER;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32779: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32780: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32781: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
32782: l_obj_id NUMBER;
32783: --
32776: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32779: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32780: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32781: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
32782: l_obj_id NUMBER;
32783: --
32784: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
34413: IF x_new_instance_tbl(1).instance_id IS NOT NULL AND
34414: x_new_instance_tbl(1).instance_id <> fnd_api.g_miss_num
34415: THEN
34416: -- Added by sk for fixing bug 2245976
34417: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
34418: csi_gen_utility_pvt.populate_install_param_rec;
34419: END IF;
34420: --
34421: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
34417: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
34418: csi_gen_utility_pvt.populate_install_param_rec;
34419: END IF;
34420: --
34421: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
34422: --
34423: IF l_internal_party_id IS NULL THEN
34424: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
34425: FND_MSG_PUB.ADD;
34853: ,p_commit IN VARCHAR2
34854: ,p_init_msg_list IN VARCHAR2
34855: ,p_validation_level IN NUMBER
34856: ,p_transaction_id IN NUMBER
34857: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
34858: ,x_return_status OUT NOCOPY VARCHAR2
34859: ,x_msg_count OUT NOCOPY NUMBER
34860: ,x_msg_data OUT NOCOPY VARCHAR2
34861: )IS
35096: ,p_commit IN VARCHAR2
35097: ,p_init_msg_list IN VARCHAR2
35098: ,p_validation_level IN NUMBER
35099: ,p_instance_id IN NUMBER
35100: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
35101: ,x_return_status OUT NOCOPY VARCHAR2
35102: ,x_msg_count OUT NOCOPY NUMBER
35103: ,x_msg_data OUT NOCOPY VARCHAR2
35104: )IS
35106: l_api_name CONSTANT VARCHAR2(30) := 'GET_INSTANCE_LINK_LOCATIONS';
35107: l_api_version CONSTANT NUMBER := 1.0;
35108: l_debug_level NUMBER;
35109: l_flag VARCHAR2(1) := 'N';
35110: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
35111:
35112: BEGIN
35113: -- Standard Start of API savepoint
35114: -- SAVEPOINT get_instance_link_locations;
35268: p_api_version IN NUMBER
35269: ,p_commit IN VARCHAR2
35270: ,p_init_msg_list IN VARCHAR2
35271: ,p_validation_level IN NUMBER
35272: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
35273: ,x_return_status OUT NOCOPY VARCHAR2
35274: ,x_msg_count OUT NOCOPY NUMBER
35275: ,x_msg_data OUT NOCOPY VARCHAR2)
35276: IS
35286: l_return_status VARCHAR2(1);
35287: l_msg_data VARCHAR2(2000);
35288: l_msg_count NUMBER;
35289: l_msg_index NUMBER;
35290: l_version_label_rec csi_datastructures_pub.version_label_rec;
35291: l_temp_label_rec csi_datastructures_pub.version_label_rec;
35292: BEGIN
35293: SAVEPOINT Update_version_time;
35294:
35287: l_msg_data VARCHAR2(2000);
35288: l_msg_count NUMBER;
35289: l_msg_index NUMBER;
35290: l_version_label_rec csi_datastructures_pub.version_label_rec;
35291: l_temp_label_rec csi_datastructures_pub.version_label_rec;
35292: BEGIN
35293: SAVEPOINT Update_version_time;
35294:
35295: x_return_status := FND_API.G_RET_STS_SUCCESS;
35446: ,p_commit IN VARCHAR2
35447: ,p_init_msg_list IN VARCHAR2
35448: ,p_validation_level IN NUMBER
35449: ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
35450: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
35451: ,x_return_status OUT NOCOPY VARCHAR2
35452: ,x_msg_count OUT NOCOPY NUMBER
35453: ,x_msg_data OUT NOCOPY VARCHAR2
35454: )
35459: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
35460: l_root_node NUMBER;
35461: l_config_tbl csi_cz_int.config_tbl := px_config_tbl;
35462: l_count NUMBER;
35463: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
35464: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
35465: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
35466: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.config_tbl;
35467: l_root NUMBER:=0;
35461: l_config_tbl csi_cz_int.config_tbl := px_config_tbl;
35462: l_count NUMBER;
35463: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
35464: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
35465: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
35466: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.config_tbl;
35467: l_root NUMBER:=0;
35468: l_found VARCHAR2(1):='N';
35469: l_root_hdr_id NUMBER;
36224: ,p_init_msg_list IN VARCHAR2
36225: ,p_validation_level IN NUMBER
36226: ,p_config_tbl IN csi_cz_int.config_tbl
36227: ,p_unlock_all IN VARCHAR2
36228: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
36229: ,x_return_status OUT NOCOPY VARCHAR2
36230: ,x_msg_count OUT NOCOPY NUMBER
36231: ,x_msg_data OUT NOCOPY VARCHAR2
36232: )
36233: AS
36234: l_api_name CONSTANT VARCHAR2(30) := 'UNLOCK_ITEM_INSTANCES';
36235: l_api_version CONSTANT NUMBER := 1.0;
36236: l_csi_debug_level NUMBER;
36237: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
36238: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
36239: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
36240: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
36241: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
36235: l_api_version CONSTANT NUMBER := 1.0;
36236: l_csi_debug_level NUMBER;
36237: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
36238: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
36239: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
36240: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
36241: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
36242: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;
36243: l_unlock_count NUMBER;