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.88.12010000.2 2008/12/08 13:47:04 dsingire 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 4536: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl

4532: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
4533: ,x_return_status OUT NOCOPY VARCHAR2
4534: ,x_msg_count OUT NOCOPY NUMBER
4535: ,x_msg_data OUT NOCOPY VARCHAR2
4536: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4537: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4538: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4539: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4540: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec

Line 4537: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl

4533: ,x_return_status OUT NOCOPY VARCHAR2
4534: ,x_msg_count OUT NOCOPY NUMBER
4535: ,x_msg_data OUT NOCOPY VARCHAR2
4536: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4537: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4538: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4539: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4540: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
4541: ,p_called_from_grp IN VARCHAR2

Line 4538: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl

4534: ,x_msg_count OUT NOCOPY NUMBER
4535: ,x_msg_data OUT NOCOPY VARCHAR2
4536: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4537: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4538: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4539: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4540: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
4541: ,p_called_from_grp IN VARCHAR2
4542: ,p_internal_party_id IN NUMBER

Line 4539: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl

4535: ,x_msg_data OUT NOCOPY VARCHAR2
4536: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4537: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4538: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4539: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4540: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
4541: ,p_called_from_grp IN VARCHAR2
4542: ,p_internal_party_id IN NUMBER
4543: )

Line 4540: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec

4536: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
4537: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
4538: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
4539: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
4540: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
4541: ,p_called_from_grp IN VARCHAR2
4542: ,p_internal_party_id IN NUMBER
4543: )
4544: IS

Line 6821: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

6817: --l_obj_ver_num NUMBER;
6818: l_instance_rec csi_datastructures_pub.instance_rec;
6819: l_instance_id_lst csi_datastructures_pub.id_tbl ;
6820: x_msg_index_out NUMBER;
6821: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6822: l_location_tbl csi_item_instance_pvt.location_tbl;
6823: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6824: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6825: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 6822: l_location_tbl csi_item_instance_pvt.location_tbl;

6818: l_instance_rec csi_datastructures_pub.instance_rec;
6819: l_instance_id_lst csi_datastructures_pub.id_tbl ;
6820: x_msg_index_out NUMBER;
6821: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6822: l_location_tbl csi_item_instance_pvt.location_tbl;
6823: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6824: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6825: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6826: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 6823: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

6819: l_instance_id_lst csi_datastructures_pub.id_tbl ;
6820: x_msg_index_out NUMBER;
6821: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6822: l_location_tbl csi_item_instance_pvt.location_tbl;
6823: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6824: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6825: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6826: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
6827: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 6824: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

6820: x_msg_index_out NUMBER;
6821: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6822: l_location_tbl csi_item_instance_pvt.location_tbl;
6823: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6824: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6825: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6826: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
6827: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
6828:

Line 6825: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

6821: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6822: l_location_tbl csi_item_instance_pvt.location_tbl;
6823: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6824: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6825: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6826: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
6827: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
6828:
6829: BEGIN

Line 10034: csi_item_instance_pvt.Call_to_Contracts

10030: END IF;
10031: --
10032: IF p_txn_rec.transaction_type_id <> 7 -- Added for bug 3973706
10033: THEN
10034: csi_item_instance_pvt.Call_to_Contracts
10035: ( p_transaction_type => l_oks_txn_type
10036: ,p_instance_id => l_rel_tbl(j).SUBJECT_ID
10037: ,p_new_instance_id => NULL
10038: ,p_vld_org_id => l_curr_instance_rec.last_vld_organization_id

Line 10091: csi_item_instance_pvt.Call_to_Contracts

10087: END IF;
10088: --
10089: IF p_txn_rec.transaction_type_id <> 7 -- Added for bug 3973706
10090: THEN
10091: csi_item_instance_pvt.Call_to_Contracts
10092: ( p_transaction_type => 'NEW'
10093: ,p_instance_id => l_rel_tbl(j).SUBJECT_ID
10094: ,p_new_instance_id => NULL
10095: ,p_vld_org_id => l_curr_instance_rec.last_vld_organization_id

Line 10129: csi_item_instance_pvt.Call_to_Contracts

10125: -- with 'IDC'. Following call is exclusively for Install_date change only.
10126: ELSE -- Check for 'IDC'
10127: IF NVL(l_curr_instance_rec.install_date,fnd_api.g_miss_date) <>
10128: NVL(l_new_instance_rec.install_date,fnd_api.g_miss_date) THEN
10129: csi_item_instance_pvt.Call_to_Contracts
10130: ( p_transaction_type => 'IDC'
10131: ,p_instance_id => l_rel_tbl(j).SUBJECT_ID
10132: ,p_new_instance_id => NULL
10133: ,p_vld_org_id => l_curr_instance_rec.last_vld_organization_id

Line 11368: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl

11364: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
11365: ,x_return_status OUT NOCOPY VARCHAR2
11366: ,x_msg_count OUT NOCOPY NUMBER
11367: ,x_msg_data OUT NOCOPY VARCHAR2
11368: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11369: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11370: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11371: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11372: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec

Line 11369: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl

11365: ,x_return_status OUT NOCOPY VARCHAR2
11366: ,x_msg_count OUT NOCOPY NUMBER
11367: ,x_msg_data OUT NOCOPY VARCHAR2
11368: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11369: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11370: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11371: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11372: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
11373: ,p_called_from_rel IN VARCHAR2

Line 11370: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl

11366: ,x_msg_count OUT NOCOPY NUMBER
11367: ,x_msg_data OUT NOCOPY VARCHAR2
11368: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11369: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11370: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11371: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11372: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
11373: ,p_called_from_rel IN VARCHAR2
11374: ,p_validation_mode IN VARCHAR2

Line 11371: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl

11367: ,x_msg_data OUT NOCOPY VARCHAR2
11368: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11369: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11370: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11371: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11372: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
11373: ,p_called_from_rel IN VARCHAR2
11374: ,p_validation_mode IN VARCHAR2
11375: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl

Line 11372: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec

11368: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl
11369: ,p_location_tbl IN OUT NOCOPY csi_item_instance_pvt.location_tbl
11370: ,p_generic_id_tbl IN OUT NOCOPY csi_item_instance_pvt.generic_id_tbl
11371: ,p_lookup_tbl IN OUT NOCOPY csi_item_instance_pvt.lookup_tbl
11372: ,p_ins_count_rec IN OUT NOCOPY csi_item_instance_pvt.ins_count_rec
11373: ,p_called_from_rel IN VARCHAR2
11374: ,p_validation_mode IN VARCHAR2
11375: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
11376: ,p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_tbl

Line 11989: csi_item_instance_pvt.get_instance_lock_status

11985: --Added for MACD lock functionality
11986: IF p_instance_rec.instance_id IS NOT NULL AND
11987: p_instance_rec.instance_id <> fnd_api.g_miss_num
11988: THEN
11989: csi_item_instance_pvt.get_instance_lock_status
11990: ( p_instance_id => p_instance_rec.instance_id ,
11991: p_lock_status => l_lock_status
11992: );
11993: IF (p_txn_rec.transaction_type_id = 401 AND

Line 19850: csi_item_instance_pvt.Call_to_Contracts

19846: l_oks_txn_type := 'RET';
19847: ELSE
19848: l_oks_txn_type := 'TRM';
19849: END IF;
19850: csi_item_instance_pvt.Call_to_Contracts
19851: ( p_transaction_type => l_oks_txn_type
19852: ,p_instance_id => l_rel_tbl(j).subject_id
19853: ,p_new_instance_id => NULL
19854: ,p_vld_org_id => l_instance_csr.last_vld_organization_id

Line 21337: csi_item_instance_pvt.Call_to_Contracts

21333: l_oks_txn_type := 'RET';
21334: ELSE
21335: l_oks_txn_type := 'TRM';
21336: END IF;
21337: csi_item_instance_pvt.Call_to_Contracts
21338: ( p_transaction_type => l_oks_txn_type
21339: ,p_instance_id => p_instance_rec.instance_id
21340: ,p_new_instance_id => NULL
21341: ,p_vld_org_id => p_instance_rec.vld_organization_id

Line 21470: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

21466: l_source_instance_rec csi_datastructures_pub.instance_rec := p_source_instance_rec;
21467: l_contracts_status VARCHAR2(3);
21468: l_new_instance_rec1 csi_datastructures_pub.instance_rec;
21469: l_internal_party_id NUMBER;
21470: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21471: l_location_tbl csi_item_instance_pvt.location_tbl;
21472: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21473: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21474: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 21471: l_location_tbl csi_item_instance_pvt.location_tbl;

21467: l_contracts_status VARCHAR2(3);
21468: l_new_instance_rec1 csi_datastructures_pub.instance_rec;
21469: l_internal_party_id NUMBER;
21470: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21471: l_location_tbl csi_item_instance_pvt.location_tbl;
21472: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21473: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21474: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21475: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 21472: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

21468: l_new_instance_rec1 csi_datastructures_pub.instance_rec;
21469: l_internal_party_id NUMBER;
21470: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21471: l_location_tbl csi_item_instance_pvt.location_tbl;
21472: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21473: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21474: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21475: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21476: --

Line 21473: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

21469: l_internal_party_id NUMBER;
21470: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21471: l_location_tbl csi_item_instance_pvt.location_tbl;
21472: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21473: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21474: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21475: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21476: --
21477: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 21474: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

21470: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21471: l_location_tbl csi_item_instance_pvt.location_tbl;
21472: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21473: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21474: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21475: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21476: --
21477: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
21478: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 21626: csi_item_instance_pvt.copy_item_instance

21622: --if the passed quantities and the quantity in the table are same then
21623: p_source_instance_rec.quantity := p_quantity2;
21624: --call the copy instance api to create a new record with 'p_quantity2')
21625:
21626: csi_item_instance_pvt.copy_item_instance
21627: ( p_api_version => p_api_version
21628: ,p_commit => fnd_api.g_false
21629: ,p_init_msg_list => p_init_msg_list
21630: ,p_validation_level => p_validation_level

Line 21810: csi_item_instance_pvt.Call_to_Contracts

21806: -- Added on 28-sep-01
21807: -- Modification starts
21808: --
21809: l_transaction_type := 'SPL';
21810: csi_item_instance_pvt.Call_to_Contracts
21811: ( p_transaction_type => l_transaction_type
21812: ,p_instance_id => p_source_instance_rec.instance_id
21813: ,p_new_instance_id => l_new_instance_tbl(1).instance_id
21814: ,p_vld_org_id => p_source_instance_rec.vld_organization_id

Line 21979: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

21975: x_msg_index_out NUMBER;
21976: l_dummy NUMBER;
21977: l_temp_qty NUMBER;
21978: l_old_qty NUMBER;
21979: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21980: l_location_tbl csi_item_instance_pvt.location_tbl;
21981: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21982: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21983: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 21980: l_location_tbl csi_item_instance_pvt.location_tbl;

21976: l_dummy NUMBER;
21977: l_temp_qty NUMBER;
21978: l_old_qty NUMBER;
21979: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21980: l_location_tbl csi_item_instance_pvt.location_tbl;
21981: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21982: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21983: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21984: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 21981: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

21977: l_temp_qty NUMBER;
21978: l_old_qty NUMBER;
21979: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21980: l_location_tbl csi_item_instance_pvt.location_tbl;
21981: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21982: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21983: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21984: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21985: --

Line 21982: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

21978: l_old_qty NUMBER;
21979: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21980: l_location_tbl csi_item_instance_pvt.location_tbl;
21981: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21982: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21983: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21984: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21985: --
21986: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 21983: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

21979: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
21980: l_location_tbl csi_item_instance_pvt.location_tbl;
21981: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
21982: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
21983: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21984: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21985: --
21986: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
21987: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 22120: csi_item_instance_pvt.copy_item_instance

22116: l_old_qty :=l_quantity-l_temp_qty; -- This will be our split old quantity.
22117: p_source_instance_rec.quantity := 1;
22118: l_new_instance_tbl.delete;
22119: --call the copy instance api to create a new record with 'p_quantity2')
22120: csi_item_instance_pvt.copy_item_instance
22121: (
22122: p_api_version => p_api_version
22123: ,p_commit => fnd_api.g_false
22124: ,p_init_msg_list => p_init_msg_list

Line 22249: csi_item_instance_pvt.call_to_contracts

22245: BEGIN
22246: -- For each of the record contracts call will be made and px_oks_txn_inst_tbl will be refreshed
22247: px_oks_txn_inst_tbl.DELETE;
22248: --
22249: csi_item_instance_pvt.call_to_contracts
22250: ( p_transaction_type => 'SPL'
22251: ,p_instance_id => p_source_instance_rec.instance_id
22252: ,p_new_instance_id => l_new_instance_tbl(1).instance_id
22253: ,p_vld_org_id => p_source_instance_rec.vld_organization_id

Line 25424: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl

25420: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
25421: ,x_return_status OUT NOCOPY VARCHAR2
25422: ,x_msg_count OUT NOCOPY NUMBER
25423: ,x_msg_data OUT NOCOPY VARCHAR2
25424: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
25425: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
25426: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
25427: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
25428: ,p_called_from_grp IN VARCHAR2

Line 25425: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec

25421: ,x_return_status OUT NOCOPY VARCHAR2
25422: ,x_msg_count OUT NOCOPY NUMBER
25423: ,x_msg_data OUT NOCOPY VARCHAR2
25424: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
25425: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
25426: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
25427: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
25428: ,p_called_from_grp IN VARCHAR2
25429: )

Line 25426: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl

25422: ,x_msg_count OUT NOCOPY NUMBER
25423: ,x_msg_data OUT NOCOPY VARCHAR2
25424: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
25425: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
25426: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
25427: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
25428: ,p_called_from_grp IN VARCHAR2
25429: )
25430: IS

Line 25427: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl

25423: ,x_msg_data OUT NOCOPY VARCHAR2
25424: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl
25425: ,p_ext_count_rec IN OUT NOCOPY csi_item_instance_pvt.ext_count_rec
25426: ,p_ext_attr_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_attr_tbl
25427: ,p_ext_cat_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_cat_tbl
25428: ,p_called_from_grp IN VARCHAR2
25429: )
25430: IS
25431: l_api_name CONSTANT VARCHAR2(30) := 'create_extended_attrib_values';

Line 25654: csi_item_instance_pvt.update_extended_attrib_values

25650: IF p_ext_attrib_rec.active_end_date = fnd_api.g_miss_date
25651: THEN
25652: p_ext_attrib_rec.active_end_date := NULL;
25653: END IF;
25654: csi_item_instance_pvt.update_extended_attrib_values
25655: (p_api_version => p_api_version
25656: ,p_commit => fnd_api.g_false
25657: ,p_init_msg_list => p_init_msg_list
25658: ,p_validation_level => p_validation_level

Line 27188: csi_item_instance_pvt.update_extended_attrib_values

27184: l_ext_attrib_rec.object_version_number := p_ext_attrib_rec.object_version_number;
27185:
27186:
27187: g_expire_ext_att_flag := 'Y';
27188: csi_item_instance_pvt.update_extended_attrib_values
27189: (p_api_version => p_api_version
27190: ,p_commit => fnd_api.g_false
27191: ,p_init_msg_list => p_init_msg_list
27192: ,p_validation_level => p_validation_level

Line 27342: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

27338: l_attribute_level VARCHAR2(30);
27339: l_vld_org_id NUMBER;
27340: l_internal_party_id NUMBER;
27341: l_party_id NUMBER;
27342: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27343: l_location_tbl csi_item_instance_pvt.location_tbl;
27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 27343: l_location_tbl csi_item_instance_pvt.location_tbl;

27339: l_vld_org_id NUMBER;
27340: l_internal_party_id NUMBER;
27341: l_party_id NUMBER;
27342: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27343: l_location_tbl csi_item_instance_pvt.location_tbl;
27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;

Line 27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

27340: l_internal_party_id NUMBER;
27341: l_party_id NUMBER;
27342: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27343: l_location_tbl csi_item_instance_pvt.location_tbl;
27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;

Line 27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

27341: l_party_id NUMBER;
27342: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27343: l_location_tbl csi_item_instance_pvt.location_tbl;
27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

Line 27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

27342: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
27343: l_location_tbl csi_item_instance_pvt.location_tbl;
27344: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
27345: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
27346: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
27347: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
27348: l_asset_count_rec csi_asset_pvt.asset_count_rec;
27349: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
27350: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

Line 28379: CSI_ITEM_INSTANCE_PVT.create_item_instance

28375: END IF;
28376: -- End addition of columns for FA Integration
28377: -- Call Create_item_instance to create the new instance in csi_item_instances table.
28378:
28379: CSI_ITEM_INSTANCE_PVT.create_item_instance
28380: ( p_api_version => p_api_version
28381: ,p_commit => p_commit
28382: ,p_init_msg_list => p_init_msg_list
28383: ,p_validation_level => p_validation_level

Line 29003: csi_item_instance_pvt.create_version_label

28999: l_version_label_rec.date_time_stamp := SYSDATE;
29000: l_version_label_rec.active_start_date := l_new_instance_rec.active_start_date;
29001: l_version_label_rec.description := l_new_instance_rec.version_label_description;
29002:
29003: csi_item_instance_pvt.create_version_label
29004: (
29005: p_api_version => p_api_version
29006: ,p_commit => fnd_api.g_false
29007: ,p_init_msg_list => p_init_msg_list

Line 29061: csi_item_instance_pvt.Call_to_Contracts(

29057: l_internal_party_id IS NOT NULL AND
29058: l_party_id <> l_internal_party_id
29059: THEN
29060: -- End addition by sk for fixing bug 2245976
29061: csi_item_instance_pvt.Call_to_Contracts(
29062: p_transaction_type => 'NEW'
29063: ,p_instance_id => x_new_instance_tbl(1).instance_id
29064: ,p_new_instance_id => NULL
29065: ,p_vld_org_id => x_new_instance_tbl(1).vld_organization_id

Line 29219: l_parent_child_tbl csi_item_instance_pvt.parent_child_tbl;

29215: l_err_msg VARCHAR2(2000) := NULL;
29216: l_error_code VARCHAR2(30) := NULL;
29217: l_group_id NUMBER;
29218: l_session_id NUMBER := 0;
29219: l_parent_child_tbl csi_item_instance_pvt.parent_child_tbl;
29220: l_parent_count NUMBER := 0;
29221: l_per_parent NUMBER := 0;
29222: l_temp_per_parent NUMBER := 0;
29223: l_csi_explode_bom VARCHAR2(30) := fnd_profile.value('CSI_EXPLODE_BOM');

Line 29242: l_bom_sort_order_tbl csi_item_instance_pvt.bom_sort_order_tbl;

29238: x_msg_index_out NUMBER;
29239: l_child_expl_level NUMBER;
29240: l_init_sort_code VARCHAR2(2000);
29241: l_bom_sortcode_width NUMBER := Bom_Common_Definitions.G_Bom_SortCode_Width;
29242: l_bom_sort_order_tbl csi_item_instance_pvt.bom_sort_order_tbl;
29243: --
29244: CURSOR BOM_CSR (p_group_id NUMBER)
29245: IS
29246: SELECT bom.assembly_item_id parent_item_id

Line 29430: csi_item_instance_pvt.Get_parent_sort_order

29426: -- Check whether parent is trackable or not
29427: l_curr_parent := v_rec.parent_sort_order;
29428: IF l_curr_parent <> l_init_sort_code THEN -- no need for Top Most
29429: -- Get the immediate Trackable Parent
29430: csi_item_instance_pvt.Get_parent_sort_order
29431: (
29432: p_parent_sort_order => l_curr_parent
29433: ,p_parent_child_tbl => l_parent_child_tbl
29434: ,p_bom_sort_order_tbl => l_bom_sort_order_tbl

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

29439: -- will be exploded only to the remaining level.
29440: l_child_expl_level := l_csi_bom_explosion_level - v_rec.plan_level;
29441: --
29442: IF ( (v_rec.serial_number_control_code in (2,5,6)) OR
29443: ((csi_item_instance_pvt.Is_Parent(p_child_sort_order => v_rec.child_sort_order
29444: ,p_parent_child_tbl => l_parent_child_tbl)) AND
29445: -- Check for Trackable component under this
29446: (csi_item_instance_pvt.Has_Trackable_Component
29447: (p_inventory_item_id => v_rec.component_item_id

Line 29446: (csi_item_instance_pvt.Has_Trackable_Component

29442: IF ( (v_rec.serial_number_control_code in (2,5,6)) OR
29443: ((csi_item_instance_pvt.Is_Parent(p_child_sort_order => v_rec.child_sort_order
29444: ,p_parent_child_tbl => l_parent_child_tbl)) AND
29445: -- Check for Trackable component under this
29446: (csi_item_instance_pvt.Has_Trackable_Component
29447: (p_inventory_item_id => v_rec.component_item_id
29448: ,p_organization_id => v_rec.organization_id
29449: ,p_explosion_level => l_child_expl_level))) ) THEN
29450: For i in 1..v_rec.extended_quantity

Line 29634: csi_item_instance_pvt.copy_single_item_instance

29630: For ins_tab in x_ins_tbl.FIRST .. x_ins_tbl.LAST
29631: Loop
29632: l_source_instance_rec := x_ins_tbl(ins_tab);
29633: l_source_instance_rec.instance_id := p_source_instance_rec.instance_id;
29634: csi_item_instance_pvt.copy_single_item_instance
29635: (
29636: p_api_version => 1.0
29637: ,p_commit => fnd_api.g_false
29638: ,p_init_msg_list => fnd_api.g_true

Line 30668: csi_item_instance_pvt.Resolve_id_columns

30664:
30665: --end of code for bug 4754569--
30666:
30667: l_old_ins_header_tbl(1):=l_old_ins_header_rec;
30668: csi_item_instance_pvt.Resolve_id_columns
30669: (p_instance_header_tbl => l_old_ins_header_tbl);
30670: l_old_ins_header_rec:=l_old_ins_header_tbl(1);
30671:
30672:

Line 30674: csi_item_instance_pvt.Resolve_id_columns

30670: l_old_ins_header_rec:=l_old_ins_header_tbl(1);
30671:
30672:
30673: l_new_ins_header_tbl(1):=l_new_ins_header_rec;
30674: csi_item_instance_pvt.Resolve_id_columns
30675: (p_instance_header_tbl => l_new_ins_header_tbl);
30676: l_new_ins_header_rec:=l_new_ins_header_tbl(1);
30677:
30678:

Line 32144: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

32140: k NUMBER;
32141: l_vld_org_id NUMBER;
32142: l_internal_party_id NUMBER;
32143: l_party_id NUMBER;
32144: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32145: l_location_tbl csi_item_instance_pvt.location_tbl;
32146: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32147: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32148: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 32145: l_location_tbl csi_item_instance_pvt.location_tbl;

32141: l_vld_org_id NUMBER;
32142: l_internal_party_id NUMBER;
32143: l_party_id NUMBER;
32144: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32145: l_location_tbl csi_item_instance_pvt.location_tbl;
32146: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32147: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32148: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32149: l_map_count NUMBER := 0;

Line 32146: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

32142: l_internal_party_id NUMBER;
32143: l_party_id NUMBER;
32144: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32145: l_location_tbl csi_item_instance_pvt.location_tbl;
32146: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32147: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32148: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32149: l_map_count NUMBER := 0;
32150: l_rel_count NUMBER := 0;

Line 32147: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

32143: l_party_id NUMBER;
32144: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32145: l_location_tbl csi_item_instance_pvt.location_tbl;
32146: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32147: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32148: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32149: l_map_count NUMBER := 0;
32150: l_rel_count NUMBER := 0;
32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;

Line 32148: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

32144: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
32145: l_location_tbl csi_item_instance_pvt.location_tbl;
32146: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
32147: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32148: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32149: l_map_count NUMBER := 0;
32150: l_rel_count NUMBER := 0;
32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32152: l_par_vld_organization_id NUMBER;

Line 32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;

32147: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
32148: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
32149: l_map_count NUMBER := 0;
32150: l_rel_count NUMBER := 0;
32151: l_map_inst_tbl csi_item_instance_pvt.map_inst_tbl;
32152: l_par_vld_organization_id NUMBER;
32153: l_asset_lookup_tbl csi_asset_pvt.lookup_tbl;
32154: l_asset_count_rec csi_asset_pvt.asset_count_rec;
32155: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

Line 33134: CSI_ITEM_INSTANCE_PVT.create_item_instance

33130: END IF;
33131: -- End addition by sguthiva for bug 2230264
33132:
33133: -- Call Create_item_instance to create the new instance in csi_item_instances table.
33134: CSI_ITEM_INSTANCE_PVT.create_item_instance
33135: ( p_api_version => p_api_version
33136: ,p_commit => p_commit
33137: ,p_init_msg_list => p_init_msg_list
33138: ,p_validation_level => p_validation_level

Line 33759: csi_item_instance_pvt.create_version_label

33755: l_version_label_rec.date_time_stamp := SYSDATE;
33756: l_version_label_rec.active_start_date := l_new_instance_rec.active_start_date;
33757: l_version_label_rec.description := l_new_instance_rec.version_label_description;
33758:
33759: csi_item_instance_pvt.create_version_label
33760: (
33761: p_api_version => p_api_version
33762: ,p_commit => fnd_api.g_false
33763: ,p_init_msg_list => p_init_msg_list

Line 33817: csi_item_instance_pvt.Call_to_Contracts(

33813: l_internal_party_id IS NOT NULL AND
33814: l_party_id <> l_internal_party_id
33815: THEN
33816: -- End addition by sk for fixing bug 2245976
33817: csi_item_instance_pvt.Call_to_Contracts(
33818: p_transaction_type => 'NEW'
33819: ,p_instance_id => x_new_instance_tbl(1).instance_id
33820: ,p_new_instance_id => NULL
33821: ,p_vld_org_id => x_new_instance_tbl(1).vld_organization_id

Line 33949: csi_item_instance_pvt.copy_single_item_instance

33945: l_source_child_instance_rec.mfg_serial_number_flag := 'N';
33946: l_source_child_instance_rec.creation_complete_flag := FND_API.G_MISS_CHAR;
33947: END IF;
33948: -- End of Addition by rtalluri for the Bug: 2297972
33949: csi_item_instance_pvt.copy_single_item_instance
33950: ( p_api_version => p_api_version
33951: ,p_commit => fnd_api.g_false
33952: ,p_init_msg_list => p_init_msg_list
33953: ,p_validation_level => p_validation_level

Line 34648: csi_item_instance_pvt.update_version_label

34644: l_version_label_rec:=l_temp_label_rec;
34645: l_version_label_rec.version_label_id:=l_ver_csr.version_label_id;
34646: l_version_label_rec.date_time_stamp:=l_sysdate;
34647: l_version_label_rec.object_version_number:=l_ver_csr.object_version_number;
34648: csi_item_instance_pvt.update_version_label
34649: ( p_api_version => p_api_version
34650: ,p_commit => p_commit
34651: ,p_init_msg_list => p_init_msg_list
34652: ,p_validation_level => p_validation_level

Line 34694: p_config_rec OUT NOCOPY csi_item_instance_pvt.lock_config_rec

34690: END Update_version_time;
34691:
34692: PROCEDURE get_config_keys
34693: (p_instance_id IN NUMBER,
34694: p_config_rec OUT NOCOPY csi_item_instance_pvt.lock_config_rec
34695: )
34696: IS
34697: BEGIN
34698: SELECT config_inst_hdr_id

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

34722: EXCEPTION
34723: WHEN NO_DATA_FOUND THEN
34724: p_lock_status := l_lock_status;
34725: WHEN TOO_MANY_ROWS THEN
34726: csi_gen_utility_pvt.put_line ('In csi_item_instance_pvt.get_instance_lock_status - too_many_rows exception ');
34727: p_lock_status := 2;
34728: END get_instance_lock_status;
34729:
34730: -- Return TRUE if instance is locked

Line 34809: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.config_tbl;

34805: l_count NUMBER;
34806: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
34807: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
34808: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
34809: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.config_tbl;
34810: l_root NUMBER:=0;
34811: l_found VARCHAR2(1):='N';
34812: l_root_hdr_id NUMBER;
34813: l_root_item_id NUMBER;

Line 34815: l_lock_config_rec csi_item_instance_pvt.lock_config_rec;

34811: l_found VARCHAR2(1):='N';
34812: l_root_hdr_id NUMBER;
34813: l_root_item_id NUMBER;
34814: l_root_rev_num NUMBER;
34815: l_lock_config_rec csi_item_instance_pvt.lock_config_rec;
34816: l_lock_count NUMBER;
34817: l_lock_id NUMBER;
34818: l_dup_count NUMBER;
34819: BEGIN

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

34962:
34963: IF (px_config_tbl(i).instance_id IS NOT NULL AND
34964: px_config_tbl(i).instance_id <> fnd_api.g_miss_num)
34965: THEN
34966: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => px_config_tbl(i).instance_id)
34967: THEN
34968: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
34969: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',px_config_tbl(i).instance_id);
34970: FND_MSG_PUB.Add;

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

35042: FOR l_chld_csr IN l_rel_tbl.FIRST .. l_rel_tbl.LAST
35043: LOOP
35044: l_lock_count:=l_lock_tbl.COUNT+1;
35045: l_lock_tbl(l_lock_count).instance_id:=l_rel_tbl(l_chld_csr).subject_id;
35046: IF csi_item_instance_pvt.check_item_instance_lock (p_instance_id => l_rel_tbl(l_chld_csr).subject_id)
35047: THEN
35048: FND_MESSAGE.SET_NAME('CSI','CSI_INS_ALREADY_LOCKED');
35049: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_lock_tbl(l_lock_count).instance_id);
35050: FND_MSG_PUB.Add;

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

35064: px_config_tbl(i).config_inst_item_id <> fnd_api.g_miss_num AND
35065: px_config_tbl(i).config_inst_rev_num IS NOT NULL AND
35066: px_config_tbl(i).config_inst_rev_num <> fnd_api.g_miss_num )
35067: THEN
35068: IF csi_item_instance_pvt.check_item_instance_lock ( p_config_inst_hdr_id => px_config_tbl(i).config_inst_hdr_id
35069: ,p_config_inst_item_id => px_config_tbl(i).config_inst_item_id
35070: ,p_config_inst_rev_num => px_config_tbl(i).config_inst_rev_num
35071: )
35072: THEN

Line 35440: p_bld_unlock_tbl OUT NOCOPY csi_item_instance_pvt.lock_instances_tbl

35436: (p_lock_id IN NUMBER,
35437: p_config_inst_hdr_id IN NUMBER,
35438: p_config_inst_item_id IN NUMBER,
35439: p_config_inst_rev_num IN NUMBER,
35440: p_bld_unlock_tbl OUT NOCOPY csi_item_instance_pvt.lock_instances_tbl
35441: )
35442: AS
35443: CURSOR config_csr(p_root_hdr IN NUMBER,
35444: p_root_rev IN NUMBER,

Line 35489: (p_unlock_tbl IN CSI_ITEM_INSTANCE_PVT.lock_instances_tbl,

35485: END;
35486: END build_unlock_config;
35487:
35488: PROCEDURE unlock_tbl_handler
35489: (p_unlock_tbl IN CSI_ITEM_INSTANCE_PVT.lock_instances_tbl,
35490: p_unlock_param IN VARCHAR2,
35491: p_date IN DATE
35492: )
35493: AS

Line 35580: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;

35576: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
35577: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
35578: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
35579: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
35580: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35581: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;
35582: l_unlock_count NUMBER;
35583: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
35584: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;

Line 35581: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;

35577: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
35578: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
35579: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
35580: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35581: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;
35582: l_unlock_count NUMBER;
35583: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
35584: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;
35585: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;

Line 35583: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;

35579: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
35580: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35581: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;
35582: l_unlock_count NUMBER;
35583: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
35584: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;
35585: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35586: l_config_count NUMBER;
35587: l_config_root NUMBER;

Line 35584: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;

35580: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35581: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;
35582: l_unlock_count NUMBER;
35583: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
35584: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;
35585: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35586: l_config_count NUMBER;
35587: l_config_root NUMBER;
35588: l_instance_ctr NUMBER;

Line 35585: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;

35581: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;
35582: l_unlock_count NUMBER;
35583: l_unlock_config csi_item_instance_pvt.lock_instances_tbl;
35584: l_unlock_root csi_item_instance_pvt.lock_instances_tbl;
35585: l_bld_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35586: l_config_count NUMBER;
35587: l_config_root NUMBER;
35588: l_instance_ctr NUMBER;
35589: l_config_ctr NUMBER;

Line 36089: END CSI_ITEM_INSTANCE_PVT;

36085: p_data => x_msg_data );
36086: END unlock_item_instances;
36087:
36088:
36089: END CSI_ITEM_INSTANCE_PVT;