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 6827: px_child_inst_tbl csi_item_instance_grp.child_inst_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
6830:
6831: -- Standard Start of API savepoint

Line 7011: p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_tbl,

7007: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
7008: x_return_status OUT NOCOPY VARCHAR2,
7009: p_unexpire IN VARCHAR2,
7010: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
7011: p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_tbl,
7012: p_orig_install_date IN DATE,
7013: x_msg_count OUT NOCOPY NUMBER,
7014: x_msg_data OUT NOCOPY VARCHAR2
7015: )

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

7030: l_msg_count NUMBER;
7031: l_instance_hist_rec csi_datastructures_pub.instance_history_rec;
7032: --Start of:Added for bug 5615169
7033: l_inst_hist_tbl_blk_ins csi_datastructures_pub.instance_history_tbl; -- used for bulk insert
7034: l_inst_hist_rec_tab csi_item_instance_grp.instance_history_rec_tab; -- used for column table
7035: l_ciih_blk_ins_cnt NUMBER := 0;
7036: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7037: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7038: --End of:Added for bug 5615169

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

10198: IF l_inst_hist_tbl_blk_ins.count > 0 THEN -- BUG#6203160
10199: --Do the ciih bulk insert
10200: --Convert PL/SQl table to column table
10201: build_inst_hist_rec_of_table ( p_inst_hist_tbl => l_inst_hist_tbl_blk_ins -- csi_datastructures_pub.instance_history_tbl
10202: ,p_inst_hist_rec_tab => l_inst_hist_rec_tab -- csi_item_instance_grp.instance_history_rec_tab
10203: );
10204: --Do the actual bulk Insert
10205: -- Modified OLD_LAST_OE_AGREEMENT_ID, NEW_LAST_OE_AGREEMENT_ID for the bug 6967129
10206: l_ciih_blk_ins_cnt := l_inst_hist_rec_tab.instance_history_id.count;

Line 11376: ,p_child_inst_tbl IN OUT NOCOPY csi_item_instance_grp.child_inst_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
11377: )
11378: IS
11379: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
11380: l_api_version CONSTANT NUMBER := 1.0;

Line 21478: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

21474: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21475: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21476: --
21477: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
21478: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
21479: l_batch_type VARCHAR2(50);
21480: l_batch_id NUMBER;
21481: --
21482: CURSOR c1 is

Line 21987: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

21983: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
21984: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
21985: --
21986: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
21987: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
21988: l_batch_type VARCHAR2(50);
21989: l_batch_id NUMBER;
21990: --
21991: BEGIN