eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_ITEM_INSTANCE_PVT

Line 1: PACKAGE BODY CSI_ITEM_INSTANCE_PVT as

1: PACKAGE BODY CSI_ITEM_INSTANCE_PVT as
2: /* $Header: csiviib.pls 120.100.12020000.11 2013/04/22 12:27:51 mvaradam ship $ */
3:
4: -- ---------------------------------------------------------
5: -- Define global variables

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_ITEM_INSTANCE_PVT';

4: -- ---------------------------------------------------------
5: -- Define global variables
6: -- ---------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_ITEM_INSTANCE_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csiviib.pls';
10: g_expire_ext_att_flag VARCHAR2(1) := 'N';
11:
12: --Start of: Added for bug 5615169

Line 317: ,p_parent_child_tbl IN csi_item_instance_pvt.parent_child_tbl

313: /* as a parent or not. */
314: /*-------------------------------------------------------------*/
315: FUNCTION Is_Parent(
316: p_child_sort_order IN VARCHAR2
317: ,p_parent_child_tbl IN csi_item_instance_pvt.parent_child_tbl
318: ) return BOOLEAN IS
319: --
320: l_return_status BOOLEAN := TRUE;
321: --

Line 349: ,p_parent_child_tbl IN csi_item_instance_pvt.parent_child_tbl

345: /*-------------------------------------------------------------*/
346: PROCEDURE Get_parent_sort_order
347: (
348: p_parent_sort_order IN OUT NOCOPY VARCHAR2
349: ,p_parent_child_tbl IN csi_item_instance_pvt.parent_child_tbl
350: ,p_bom_sort_order_tbl IN csi_item_instance_pvt.bom_sort_order_tbl
351: ) IS
352: l_exists_flag VARCHAR2(1) := 'N';
353: l_init_sort_code VARCHAR2(2000);

Line 350: ,p_bom_sort_order_tbl IN csi_item_instance_pvt.bom_sort_order_tbl

346: PROCEDURE Get_parent_sort_order
347: (
348: p_parent_sort_order IN OUT NOCOPY VARCHAR2
349: ,p_parent_child_tbl IN csi_item_instance_pvt.parent_child_tbl
350: ,p_bom_sort_order_tbl IN csi_item_instance_pvt.bom_sort_order_tbl
351: ) IS
352: l_exists_flag VARCHAR2(1) := 'N';
353: l_init_sort_code VARCHAR2(2000);
354: BEGIN

Line 387: csi_item_instance_pvt.Get_parent_sort_order

383: END IF;
384: End Loop;
385: --
386: -- Call this recursively
387: csi_item_instance_pvt.Get_parent_sort_order
388: (
389: p_parent_sort_order => p_parent_sort_order
390: ,p_parent_child_tbl => p_parent_child_tbl
391: ,p_bom_sort_order_tbl => p_bom_sort_order_tbl

Line 4555: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_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
4556: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4557: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4558: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4559: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec

Line 4556: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_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
4556: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4557: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4558: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4559: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
4560: ,p_called_from_grp IN VARCHAR2

Line 4557: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl

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
4556: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4557: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4558: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4559: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
4560: ,p_called_from_grp IN VARCHAR2
4561: ,p_internal_party_id IN NUMBER

Line 4558: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl

4554: ,x_msg_data OUT NOCOPY VARCHAR2
4555: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4556: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4557: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4558: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4559: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
4560: ,p_called_from_grp IN VARCHAR2
4561: ,p_internal_party_id IN NUMBER
4562: )

Line 4559: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec

4555: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4556: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4557: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4558: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4559: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
4560: ,p_called_from_grp IN VARCHAR2
4561: ,p_internal_party_id IN NUMBER
4562: )
4563: IS

Line 6898: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

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;
6901: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6902: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 6899: l_location_tbl csi_item_instance_pvt.location_tbl;

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;
6901: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6902: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6903: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 6900: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

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;
6901: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6902: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6903: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
6904: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 6901: l_lookup_tbl csi_item_instance_pvt.lookup_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;
6901: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6902: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6903: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
6904: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
6905:

Line 6902: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

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;
6901: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6902: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6903: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
6904: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
6905:
6906: BEGIN

Line 10266: csi_item_instance_pvt.Call_to_Contracts

10262: )
10263: OR nvl(p_txn_rec.source_group_ref, FND_API.G_MISS_CHAR) <> 'WBADI'
10264: )
10265: THEN
10266: csi_item_instance_pvt.Call_to_Contracts
10267: ( p_transaction_type => l_oks_txn_type
10268: ,p_instance_id => l_rel_tbl(j).SUBJECT_ID
10269: ,p_new_instance_id => NULL
10270: ,p_vld_org_id => l_curr_instance_rec.last_vld_organization_id

Line 10330: csi_item_instance_pvt.Call_to_Contracts

10326: )
10327: OR nvl(p_txn_rec.source_group_ref, FND_API.G_MISS_CHAR) <> 'WBADI'
10328: )
10329: THEN
10330: csi_item_instance_pvt.Call_to_Contracts
10331: ( p_transaction_type => 'NEW'
10332: ,p_instance_id => l_rel_tbl(j).SUBJECT_ID
10333: ,p_new_instance_id => NULL
10334: ,p_vld_org_id => l_curr_instance_rec.last_vld_organization_id

Line 10376: csi_item_instance_pvt.Call_to_Contracts

10372: )
10373: OR nvl(p_txn_rec.source_group_ref, FND_API.G_MISS_CHAR) <> 'WBADI'
10374: )
10375: THEN
10376: csi_item_instance_pvt.Call_to_Contracts
10377: ( p_transaction_type => 'IDC'
10378: ,p_instance_id => l_rel_tbl(j).SUBJECT_ID
10379: ,p_new_instance_id => NULL
10380: ,p_vld_org_id => l_curr_instance_rec.last_vld_organization_id

Line 11659: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl

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
11660: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11661: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11662: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11663: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec

Line 11660: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_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
11660: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11661: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11662: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11663: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
11664: ,p_called_from_rel IN VARCHAR2

Line 11661: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl

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
11660: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11661: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11662: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11663: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
11664: ,p_called_from_rel IN VARCHAR2
11665: ,p_validation_mode IN VARCHAR2

Line 11662: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl

11658: ,x_msg_data OUT NOCOPY VARCHAR2
11659: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11660: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11661: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11662: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11663: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
11664: ,p_called_from_rel IN VARCHAR2
11665: ,p_validation_mode IN VARCHAR2
11666: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl

Line 11663: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec

11659: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11660: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11661: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11662: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11663: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
11664: ,p_called_from_rel IN VARCHAR2
11665: ,p_validation_mode IN VARCHAR2
11666: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
11667: ,p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_tbl

Line 12307: csi_item_instance_pvt.get_instance_lock_status

12303: --Added for MACD lock functionality
12304: IF p_instance_rec.instance_id IS NOT NULL AND
12305: p_instance_rec.instance_id <> fnd_api.g_miss_num
12306: THEN
12307: csi_item_instance_pvt.get_instance_lock_status
12308: ( p_instance_id => p_instance_rec.instance_id ,
12309: p_lock_status => l_lock_status
12310: );
12311: IF (p_txn_rec.transaction_type_id = 401 AND

Line 20347: csi_item_instance_pvt.Call_to_Contracts

20343: l_oks_txn_type := 'RET';
20344: ELSE
20345: l_oks_txn_type := 'TRM';
20346: END IF;
20347: csi_item_instance_pvt.Call_to_Contracts
20348: ( p_transaction_type => l_oks_txn_type
20349: ,p_instance_id => l_rel_tbl(j).subject_id
20350: ,p_new_instance_id => NULL
20351: ,p_vld_org_id => l_instance_csr.last_vld_organization_id

Line 21874: csi_item_instance_pvt.Call_to_Contracts

21870: l_oks_txn_type := 'RET';
21871: ELSE
21872: l_oks_txn_type := 'TRM';
21873: END IF;
21874: csi_item_instance_pvt.Call_to_Contracts
21875: ( p_transaction_type => l_oks_txn_type
21876: ,p_instance_id => p_instance_rec.instance_id
21877: ,p_new_instance_id => NULL
21878: ,p_vld_org_id => p_instance_rec.vld_organization_id

Line 22011: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

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;
22014: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
22015: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 22012: l_location_tbl csi_item_instance_pvt.location_tbl;

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;
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;

Line 22013: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

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;
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: --

Line 22014: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

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;
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;

Line 22015: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

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;
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;

Line 22167: csi_item_instance_pvt.copy_item_instance

22163: --if the passed quantities and the quantity in the table are same then
22164: p_source_instance_rec.quantity := p_quantity2;
22165: --call the copy instance api to create a new record with 'p_quantity2')
22166:
22167: csi_item_instance_pvt.copy_item_instance
22168: ( p_api_version => p_api_version
22169: ,p_commit => fnd_api.g_false
22170: ,p_init_msg_list => p_init_msg_list
22171: ,p_validation_level => p_validation_level

Line 22351: csi_item_instance_pvt.Call_to_Contracts

22347: -- Added on 28-sep-01
22348: -- Modification starts
22349: --
22350: l_transaction_type := 'SPL';
22351: csi_item_instance_pvt.Call_to_Contracts
22352: ( p_transaction_type => l_transaction_type
22353: ,p_instance_id => p_source_instance_rec.instance_id
22354: ,p_new_instance_id => l_new_instance_tbl(1).instance_id
22355: ,p_vld_org_id => p_source_instance_rec.vld_organization_id

Line 22524: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

22520: x_msg_index_out NUMBER;
22521: l_dummy NUMBER;
22522: l_temp_qty NUMBER;
22523: l_old_qty NUMBER;
22524: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
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;

Line 22525: l_location_tbl csi_item_instance_pvt.location_tbl;

22521: l_dummy NUMBER;
22522: l_temp_qty NUMBER;
22523: l_old_qty NUMBER;
22524: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
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;

Line 22526: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

22522: l_temp_qty NUMBER;
22523: l_old_qty NUMBER;
22524: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
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: --

Line 22527: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

22523: l_old_qty NUMBER;
22524: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
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;

Line 22528: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

22524: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
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;

Line 22665: csi_item_instance_pvt.copy_item_instance

22661: l_old_qty :=l_quantity-l_temp_qty; -- This will be our split old quantity.
22662: p_source_instance_rec.quantity := 1;
22663: l_new_instance_tbl.delete;
22664: --call the copy instance api to create a new record with 'p_quantity2')
22665: csi_item_instance_pvt.copy_item_instance
22666: (
22667: p_api_version => p_api_version
22668: ,p_commit => fnd_api.g_false
22669: ,p_init_msg_list => p_init_msg_list

Line 22794: csi_item_instance_pvt.call_to_contracts

22790: BEGIN
22791: -- For each of the record contracts call will be made and px_oks_txn_inst_tbl will be refreshed
22792: px_oks_txn_inst_tbl.DELETE;
22793: --
22794: csi_item_instance_pvt.call_to_contracts
22795: ( p_transaction_type => 'SPL'
22796: ,p_instance_id => p_source_instance_rec.instance_id
22797: ,p_new_instance_id => l_new_instance_tbl(1).instance_id
22798: ,p_vld_org_id => p_source_instance_rec.vld_organization_id

Line 25989: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl

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
25990: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
25991: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
25992: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
25993: ,p_called_from_grp IN VARCHAR2

Line 25990: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_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
25990: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
25991: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
25992: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
25993: ,p_called_from_grp IN VARCHAR2
25994: )

Line 25991: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl

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
25990: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
25991: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
25992: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
25993: ,p_called_from_grp IN VARCHAR2
25994: )
25995: IS

Line 25992: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl

25988: ,x_msg_data OUT NOCOPY VARCHAR2
25989: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
25990: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
25991: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
25992: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
25993: ,p_called_from_grp IN VARCHAR2
25994: )
25995: IS
25996: l_api_name CONSTANT VARCHAR2(30) := 'create_extended_attrib_values';

Line 26219: csi_item_instance_pvt.update_extended_attrib_values

26215: IF p_ext_attrib_rec.active_end_date = fnd_api.g_miss_date
26216: THEN
26217: p_ext_attrib_rec.active_end_date := NULL;
26218: END IF;
26219: csi_item_instance_pvt.update_extended_attrib_values
26220: (p_api_version => p_api_version
26221: ,p_commit => fnd_api.g_false
26222: ,p_init_msg_list => p_init_msg_list
26223: ,p_validation_level => p_validation_level

Line 27761: csi_item_instance_pvt.update_extended_attrib_values

27757: l_ext_attrib_rec.object_version_number := p_ext_attrib_rec.object_version_number;
27758:
27759:
27760: g_expire_ext_att_flag := 'Y';
27761: csi_item_instance_pvt.update_extended_attrib_values
27762: (p_api_version => p_api_version
27763: ,p_commit => fnd_api.g_false
27764: ,p_init_msg_list => p_init_msg_list
27765: ,p_validation_level => p_validation_level

Line 27919: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

27915: l_attribute_level VARCHAR2(30);
27916: l_vld_org_id NUMBER;
27917: l_internal_party_id NUMBER;
27918: l_party_id NUMBER;
27919: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27920: l_location_tbl csi_item_instance_pvt.location_tbl;
27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 27920: l_location_tbl csi_item_instance_pvt.location_tbl;

27916: l_vld_org_id NUMBER;
27917: l_internal_party_id NUMBER;
27918: l_party_id NUMBER;
27919: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27920: l_location_tbl csi_item_instance_pvt.location_tbl;
27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

Line 27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

27917: l_internal_party_id NUMBER;
27918: l_party_id NUMBER;
27919: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27920: l_location_tbl csi_item_instance_pvt.location_tbl;
27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;

Line 27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

27918: l_party_id NUMBER;
27919: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27920: l_location_tbl csi_item_instance_pvt.location_tbl;
27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27925: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27926: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

Line 27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

27919: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27920: l_location_tbl csi_item_instance_pvt.location_tbl;
27921: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27922: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27923: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27924: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
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;

Line 28956: CSI_ITEM_INSTANCE_PVT.create_item_instance

28952: END IF;
28953: -- End addition of columns for FA Integration
28954: -- Call Create_item_instance to create the new instance in csi_item_instances table.
28955:
28956: CSI_ITEM_INSTANCE_PVT.create_item_instance
28957: ( p_api_version => p_api_version
28958: ,p_commit => p_commit
28959: ,p_init_msg_list => p_init_msg_list
28960: ,p_validation_level => p_validation_level

Line 29580: csi_item_instance_pvt.create_version_label

29576: l_version_label_rec.date_time_stamp := SYSDATE;
29577: l_version_label_rec.active_start_date := l_new_instance_rec.active_start_date;
29578: l_version_label_rec.description := l_new_instance_rec.version_label_description;
29579:
29580: csi_item_instance_pvt.create_version_label
29581: (
29582: p_api_version => p_api_version
29583: ,p_commit => fnd_api.g_false
29584: ,p_init_msg_list => p_init_msg_list

Line 29638: csi_item_instance_pvt.Call_to_Contracts(

29634: l_internal_party_id IS NOT NULL AND
29635: l_party_id <> l_internal_party_id
29636: THEN
29637: -- End addition by sk for fixing bug 2245976
29638: csi_item_instance_pvt.Call_to_Contracts(
29639: p_transaction_type => 'NEW'
29640: ,p_instance_id => x_new_instance_tbl(1).instance_id
29641: ,p_new_instance_id => NULL
29642: ,p_vld_org_id => x_new_instance_tbl(1).vld_organization_id

Line 29800: l_parent_child_tbl csi_item_instance_pvt.parent_child_tbl;

29796: l_err_msg VARCHAR2(2000) := NULL;
29797: l_error_code VARCHAR2(30) := NULL;
29798: l_group_id NUMBER;
29799: l_session_id NUMBER := 0;
29800: l_parent_child_tbl csi_item_instance_pvt.parent_child_tbl;
29801: l_parent_count NUMBER := 0;
29802: l_per_parent NUMBER := 0;
29803: l_temp_per_parent NUMBER := 0;
29804: l_csi_explode_bom VARCHAR2(30) := fnd_profile.value('CSI_EXPLODE_BOM');

Line 29823: l_bom_sort_order_tbl csi_item_instance_pvt.bom_sort_order_tbl;

29819: x_msg_index_out NUMBER;
29820: l_child_expl_level NUMBER;
29821: l_init_sort_code VARCHAR2(2000);
29822: l_bom_sortcode_width NUMBER := Bom_Common_Definitions.G_Bom_SortCode_Width;
29823: l_bom_sort_order_tbl csi_item_instance_pvt.bom_sort_order_tbl;
29824: l_bom_expl_org_flag VARCHAR2(3);
29825: --
29826: CURSOR BOM_CSR (p_group_id NUMBER)
29827: IS

Line 30021: csi_item_instance_pvt.Get_parent_sort_order

30017: -- Check whether parent is trackable or not
30018: l_curr_parent := v_rec.parent_sort_order;
30019: IF l_curr_parent <> l_init_sort_code THEN -- no need for Top Most
30020: -- Get the immediate Trackable Parent
30021: csi_item_instance_pvt.Get_parent_sort_order
30022: (
30023: p_parent_sort_order => l_curr_parent
30024: ,p_parent_child_tbl => l_parent_child_tbl
30025: ,p_bom_sort_order_tbl => l_bom_sort_order_tbl

Line 30034: ((csi_item_instance_pvt.Is_Parent(p_child_sort_order => v_rec.child_sort_order

30030: -- will be exploded only to the remaining level.
30031: l_child_expl_level := l_csi_bom_explosion_level - v_rec.plan_level;
30032: --
30033: IF ( (v_rec.serial_number_control_code in (2,5,6)) OR
30034: ((csi_item_instance_pvt.Is_Parent(p_child_sort_order => v_rec.child_sort_order
30035: ,p_parent_child_tbl => l_parent_child_tbl)) AND
30036: -- Check for Trackable component under this
30037: (csi_item_instance_pvt.Has_Trackable_Component
30038: (p_inventory_item_id => v_rec.component_item_id

Line 30037: (csi_item_instance_pvt.Has_Trackable_Component

30033: IF ( (v_rec.serial_number_control_code in (2,5,6)) OR
30034: ((csi_item_instance_pvt.Is_Parent(p_child_sort_order => v_rec.child_sort_order
30035: ,p_parent_child_tbl => l_parent_child_tbl)) AND
30036: -- Check for Trackable component under this
30037: (csi_item_instance_pvt.Has_Trackable_Component
30038: (p_inventory_item_id => v_rec.component_item_id
30039: ,p_organization_id => v_rec.organization_id
30040: ,p_explosion_level => l_child_expl_level))) ) THEN
30041: For i in 1..v_rec.extended_quantity

Line 30232: csi_item_instance_pvt.copy_single_item_instance

30228: For ins_tab in x_ins_tbl.FIRST .. x_ins_tbl.LAST
30229: Loop
30230: l_source_instance_rec := x_ins_tbl(ins_tab);
30231: l_source_instance_rec.instance_id := p_source_instance_rec.instance_id;
30232: csi_item_instance_pvt.copy_single_item_instance
30233: (
30234: p_api_version => 1.0
30235: ,p_commit => fnd_api.g_false
30236: ,p_init_msg_list => fnd_api.g_true

Line 31270: csi_item_instance_pvt.Resolve_id_columns

31266:
31267: --end of code for bug 4754569--
31268:
31269: l_old_ins_header_tbl(1):=l_old_ins_header_rec;
31270: csi_item_instance_pvt.Resolve_id_columns
31271: (p_instance_header_tbl => l_old_ins_header_tbl);
31272: l_old_ins_header_rec:=l_old_ins_header_tbl(1);
31273:
31274:

Line 31276: csi_item_instance_pvt.Resolve_id_columns

31272: l_old_ins_header_rec:=l_old_ins_header_tbl(1);
31273:
31274:
31275: l_new_ins_header_tbl(1):=l_new_ins_header_rec;
31276: csi_item_instance_pvt.Resolve_id_columns
31277: (p_instance_header_tbl => l_new_ins_header_tbl);
31278: l_new_ins_header_rec:=l_new_ins_header_tbl(1);
31279:
31280:

Line 32764: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

32760: k NUMBER;
32761: l_vld_org_id NUMBER;
32762: l_internal_party_id NUMBER;
32763: l_party_id NUMBER;
32764: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32765: l_location_tbl csi_item_instance_pvt.location_tbl;
32766: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32767: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32768: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 32765: l_location_tbl csi_item_instance_pvt.location_tbl;

32761: l_vld_org_id NUMBER;
32762: l_internal_party_id NUMBER;
32763: l_party_id NUMBER;
32764: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32765: l_location_tbl csi_item_instance_pvt.location_tbl;
32766: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32767: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32768: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32769: l_map_count NUMBER := 0;

Line 32766: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

32762: l_internal_party_id NUMBER;
32763: l_party_id NUMBER;
32764: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32765: l_location_tbl csi_item_instance_pvt.location_tbl;
32766: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32767: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32768: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32769: l_map_count NUMBER := 0;
32770: l_rel_count NUMBER := 0;

Line 32767: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

32763: l_party_id NUMBER;
32764: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32765: l_location_tbl csi_item_instance_pvt.location_tbl;
32766: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32767: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32768: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32769: l_map_count NUMBER := 0;
32770: l_rel_count NUMBER := 0;
32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;

Line 32768: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

32764: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32765: l_location_tbl csi_item_instance_pvt.location_tbl;
32766: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32767: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32768: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32769: l_map_count NUMBER := 0;
32770: l_rel_count NUMBER := 0;
32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32772: l_par_vld_organization_id NUMBER;

Line 32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;

32767: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32768: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32769: l_map_count NUMBER := 0;
32770: l_rel_count NUMBER := 0;
32771: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32772: l_par_vld_organization_id NUMBER;
32773: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32774: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32775: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

Line 33762: CSI_ITEM_INSTANCE_PVT.create_item_instance

33758: l_new_instance_rec.SOURCE_CODE := p_source_instance_rec.SOURCE_CODE;
33759: END IF;
33760:
33761: -- Call Create_item_instance to create the new instance in csi_item_instances table.
33762: CSI_ITEM_INSTANCE_PVT.create_item_instance
33763: ( p_api_version => p_api_version
33764: ,p_commit => p_commit
33765: ,p_init_msg_list => p_init_msg_list
33766: ,p_validation_level => p_validation_level

Line 34387: csi_item_instance_pvt.create_version_label

34383: l_version_label_rec.date_time_stamp := SYSDATE;
34384: l_version_label_rec.active_start_date := l_new_instance_rec.active_start_date;
34385: l_version_label_rec.description := l_new_instance_rec.version_label_description;
34386:
34387: csi_item_instance_pvt.create_version_label
34388: (
34389: p_api_version => p_api_version
34390: ,p_commit => fnd_api.g_false
34391: ,p_init_msg_list => p_init_msg_list

Line 34460: csi_item_instance_pvt.Call_to_Contracts(

34456: l_party_id <> l_internal_party_id
34457: AND (l_contract_exists = 'Y') -- Added for Bug 14593787
34458: THEN
34459: -- End addition by sk for fixing bug 2245976
34460: csi_item_instance_pvt.Call_to_Contracts(
34461: p_transaction_type => 'NEW'
34462: ,p_instance_id => x_new_instance_tbl(1).instance_id
34463: ,p_new_instance_id => NULL
34464: ,p_vld_org_id => x_new_instance_tbl(1).vld_organization_id

Line 34592: csi_item_instance_pvt.copy_single_item_instance

34588: l_source_child_instance_rec.mfg_serial_number_flag := 'N';
34589: l_source_child_instance_rec.creation_complete_flag := FND_API.G_MISS_CHAR;
34590: END IF;
34591: -- End of Addition by rtalluri for the Bug: 2297972
34592: csi_item_instance_pvt.copy_single_item_instance
34593: ( p_api_version => p_api_version
34594: ,p_commit => fnd_api.g_false
34595: ,p_init_msg_list => p_init_msg_list
34596: ,p_validation_level => p_validation_level

Line 35303: csi_item_instance_pvt.update_version_label

35299: l_version_label_rec:=l_temp_label_rec;
35300: l_version_label_rec.version_label_id:=l_ver_csr.version_label_id;
35301: l_version_label_rec.date_time_stamp:=l_sysdate;
35302: l_version_label_rec.object_version_number:=l_ver_csr.object_version_number;
35303: csi_item_instance_pvt.update_version_label
35304: ( p_api_version => p_api_version
35305: ,p_commit => p_commit
35306: ,p_init_msg_list => p_init_msg_list
35307: ,p_validation_level => p_validation_level

Line 35351: p_config_rec OUT NOCOPY csi_item_instance_pvt.lock_config_rec

35347: END Update_version_time;
35348:
35349: PROCEDURE get_config_keys
35350: (p_instance_id IN NUMBER,
35351: p_config_rec OUT NOCOPY csi_item_instance_pvt.lock_config_rec
35352: )
35353: IS
35354: BEGIN
35355: SELECT config_inst_hdr_id

Line 35383: csi_gen_utility_pvt.put_line ('In csi_item_instance_pvt.get_instance_lock_status - too_many_rows exception ');

35379: EXCEPTION
35380: WHEN NO_DATA_FOUND THEN
35381: p_lock_status := l_lock_status;
35382: WHEN TOO_MANY_ROWS THEN
35383: csi_gen_utility_pvt.put_line ('In csi_item_instance_pvt.get_instance_lock_status - too_many_rows exception ');
35384: p_lock_status := 2;
35385: END get_instance_lock_status;
35386:
35387: -- Return TRUE if instance is locked

Line 35466: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.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;
35470: l_root_item_id NUMBER;

Line 35472: l_lock_config_rec csi_item_instance_pvt.lock_config_rec;

35468: l_found VARCHAR2(1):='N';
35469: l_root_hdr_id NUMBER;
35470: l_root_item_id NUMBER;
35471: l_root_rev_num NUMBER;
35472: l_lock_config_rec csi_item_instance_pvt.lock_config_rec;
35473: l_lock_count NUMBER;
35474: l_lock_id NUMBER;
35475: l_dup_count NUMBER;
35476: BEGIN

Line 35623: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => px_config_tbl(i).instance_id)

35619:
35620: IF (px_config_tbl(i).instance_id IS NOT NULL AND
35621: px_config_tbl(i).instance_id <> fnd_api.g_miss_num)
35622: THEN
35623: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => px_config_tbl(i).instance_id)
35624: THEN
35625: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35626: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
35627: FND_MSG_PUB.Add;

Line 35703: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => l_rel_tbl(l_chld_csr).subject_id)

35699: FOR l_chld_csr IN l_rel_tbl.FIRST .. l_rel_tbl.LAST
35700: LOOP
35701: l_lock_count:=l_lock_tbl.COUNT+1;
35702: l_lock_tbl(l_lock_count).instance_id:=l_rel_tbl(l_chld_csr).subject_id;
35703: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => l_rel_tbl(l_chld_csr).subject_id)
35704: THEN
35705: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35706: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_lock_tbl(l_lock_count).instance_id);
35707: FND_MSG_PUB.Add;

Line 35725: IF csi_item_instance_pvt.check_item_instance_lock ( p_config_inst_hdr_id => px_config_tbl(i).config_inst_hdr_id

35721: px_config_tbl(i).config_inst_item_id <> fnd_api.g_miss_num AND
35722: px_config_tbl(i).config_inst_rev_num IS NOT NULL AND
35723: px_config_tbl(i).config_inst_rev_num <> fnd_api.g_miss_num )
35724: THEN
35725: IF csi_item_instance_pvt.check_item_instance_lock ( p_config_inst_hdr_id => px_config_tbl(i).config_inst_hdr_id
35726: ,p_config_inst_item_id => px_config_tbl(i).config_inst_item_id
35727: ,p_config_inst_rev_num => px_config_tbl(i).config_inst_rev_num
35728: )
35729: THEN

Line 36101: p_bld_unlock_tbl OUT NOCOPY csi_item_instance_pvt.lock_instances_tbl

36097: (p_lock_id IN NUMBER,
36098: p_config_inst_hdr_id IN NUMBER,
36099: p_config_inst_item_id IN NUMBER,
36100: p_config_inst_rev_num IN NUMBER,
36101: p_bld_unlock_tbl OUT NOCOPY csi_item_instance_pvt.lock_instances_tbl
36102: )
36103: AS
36104: CURSOR config_csr(p_root_hdr IN NUMBER,
36105: p_root_rev IN NUMBER,

Line 36150: (p_unlock_tbl IN CSI_ITEM_INSTANCE_PVT.lock_instances_tbl,

36146: END;
36147: END build_unlock_config;
36148:
36149: PROCEDURE unlock_tbl_handler
36150: (p_unlock_tbl IN CSI_ITEM_INSTANCE_PVT.lock_instances_tbl,
36151: p_unlock_param IN VARCHAR2,
36152: p_date IN DATE
36153: )
36154: AS

Line 36241: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;

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;
36244: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
36245: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;

Line 36242: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_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;
36244: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
36245: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;
36246: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;

Line 36244: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;

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;
36244: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
36245: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;
36246: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
36247: l_config_count NUMBER;
36248: l_config_root NUMBER;

Line 36245: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;

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;
36244: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
36245: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;
36246: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
36247: l_config_count NUMBER;
36248: l_config_root NUMBER;
36249: l_instance_ctr NUMBER;

Line 36246: l_bld_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;
36244: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
36245: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;
36246: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
36247: l_config_count NUMBER;
36248: l_config_root NUMBER;
36249: l_instance_ctr NUMBER;
36250: l_config_ctr NUMBER;

Line 36754: END CSI_ITEM_INSTANCE_PVT;

36750: p_data => x_msg_data );
36751: END unlock_item_instances;
36752:
36753:
36754: END CSI_ITEM_INSTANCE_PVT;