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 1092: select CSI_I_PARTIES_H_S.nextval

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

Line 4090: INSERT INTO CSI_I_PARTIES(

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

Line 4170: INSERT INTO CSI_I_PARTIES_H(

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

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

7537: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7538: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_del_inst_tbl(j);
7539: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7540: DELETE FROM CSI_IP_ACCOUNTS WHERE instance_party_id in (SELECT instance_party_id
7541: from CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j));
7542: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7543: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);
7544: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7545: DELETE FROM CSI_I_ORG_ASSIGNMENTS WHERE instance_id = l_del_inst_tbl(j);

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

7539: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7540: DELETE FROM CSI_IP_ACCOUNTS WHERE instance_party_id in (SELECT instance_party_id
7541: from CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j));
7542: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7543: DELETE FROM CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j);
7544: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7545: DELETE FROM CSI_I_ORG_ASSIGNMENTS WHERE instance_id = l_del_inst_tbl(j);
7546: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7547: DELETE FROM CSI_I_PRICING_ATTRIBS WHERE instance_id = l_del_inst_tbl(j);

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

7553: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
7554: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7555: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
7556: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7557: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
7558: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7559: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);
7560: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7561: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H WHERE transaction_id = l_del_txn_tbl(j);

Line 8890: FROM csi_i_parties cip

8886: --
8887: BEGIN
8888: SELECT cip.party_id
8889: INTO l_party_id
8890: FROM csi_i_parties cip
8891: WHERE cip.instance_id = p_instance_tbl(ins_row).instance_id
8892: AND cip.relationship_type_code = 'OWNER';
8893: EXCEPTION
8894: WHEN OTHERS THEN