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_GRP dependencies on CSI_I_PARTIES

Line 1095: select CSI_I_PARTIES_H_S.nextval

1091: l_count NUMBER;
1092: l_hist_id NUMBER;
1093: BEGIN
1094: l_count := p_party_hist_tbl.count + 1;
1095: select CSI_I_PARTIES_H_S.nextval
1096: into l_hist_id
1097: from sys.dual;
1098: --
1099: p_party_hist_tbl(l_count).INSTANCE_PARTY_HISTORY_ID := l_hist_id;

Line 4093: INSERT INTO CSI_I_PARTIES(

4089: --
4090: l_ctr := l_party_rec_tab.instance_party_id.count;
4091: --
4092: FORALL i in 1 .. l_ctr
4093: INSERT INTO CSI_I_PARTIES(
4094: INSTANCE_PARTY_ID,
4095: INSTANCE_ID,
4096: PARTY_SOURCE_TABLE,
4097: PARTY_ID,

Line 4173: INSERT INTO CSI_I_PARTIES_H(

4169: --
4170: l_ctr := l_party_hist_rec_tab.instance_party_history_id.count;
4171: --
4172: FORALL i in 1 .. l_ctr
4173: INSERT INTO CSI_I_PARTIES_H(
4174: INSTANCE_PARTY_HISTORY_ID,
4175: INSTANCE_PARTY_ID,
4176: TRANSACTION_ID,
4177: OLD_PARTY_SOURCE_TABLE,

Line 8078: from CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j));

8074: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8075: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_del_inst_tbl(j);
8076: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8077: DELETE FROM CSI_IP_ACCOUNTS WHERE instance_party_id in (SELECT instance_party_id
8078: from CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j));
8079: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8080: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);
8081: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8082: DELETE FROM CSI_I_ORG_ASSIGNMENTS WHERE instance_id = l_del_inst_tbl(j);

Line 8080: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);

8076: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8077: DELETE FROM CSI_IP_ACCOUNTS WHERE instance_party_id in (SELECT instance_party_id
8078: from CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j));
8079: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8080: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);
8081: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8082: DELETE FROM CSI_I_ORG_ASSIGNMENTS WHERE instance_id = l_del_inst_tbl(j);
8083: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
8084: DELETE FROM CSI_I_PRICING_ATTRIBS WHERE instance_id = l_del_inst_tbl(j);

Line 8094: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);

8090: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
8091: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8092: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
8093: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8094: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
8095: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8096: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);
8097: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8098: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H WHERE transaction_id = l_del_txn_tbl(j);

Line 9436: FROM csi_i_parties cip

9432: --
9433: BEGIN
9434: SELECT cip.party_id
9435: INTO l_party_id
9436: FROM csi_i_parties cip
9437: WHERE cip.instance_id = p_instance_tbl(ins_row).instance_id
9438: AND cip.relationship_type_code = 'OWNER';
9439: EXCEPTION
9440: WHEN OTHERS THEN