APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_ITEM_INSTANCE_GRP

Line 24: p_inst_hist_rec_tab IN OUT NOCOPY csi_item_instance_grp.instance_history_rec_tab )

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
28: LOOP

Line 6904: px_child_inst_tbl csi_item_instance_grp.child_inst_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
6907:
6908: -- Standard Start of API savepoint

Line 7092: p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_tbl,

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,
7093: p_orig_install_date IN DATE,
7094: x_msg_count OUT NOCOPY NUMBER,
7095: x_msg_data OUT NOCOPY VARCHAR2
7096: )

Line 7115: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table

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;
7119: --End of:Added for bug 5615169

Line 10449: ,p_inst_hist_rec_tab => l_inst_hist_rec_tab -- csi_item_instance_grp.instance_history_rec_tab

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
10453: l_ciih_blk_ins_cnt := l_inst_hist_rec_tab.instance_history_id.count;

Line 11667: ,p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_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
11668: )
11669: IS
11670: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
11671: l_api_version CONSTANT NUMBER := 1.0;

Line 22019: px_child_inst_tbl csi_item_instance_grp.child_inst_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);
22021: l_batch_id NUMBER;
22022: --
22023: CURSOR c1 is

Line 22532: px_child_inst_tbl csi_item_instance_grp.child_inst_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);
22534: l_batch_id NUMBER;
22535: --
22536: BEGIN