APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_IP_ACCOUNTS

Line 1164: select CSI_IP_ACCOUNTS_H_S.nextval

1160: l_count NUMBER;
1161: l_hist_id NUMBER;
1162: BEGIN
1163: l_count := p_acct_hist_tbl.count + 1;
1164: select CSI_IP_ACCOUNTS_H_S.nextval
1165: into l_hist_id
1166: from sys.dual;
1167: --
1168: p_acct_hist_tbl(l_count).IP_ACCOUNT_HISTORY_ID := l_hist_id;

Line 4307: INSERT INTO CSI_IP_ACCOUNTS(

4303: --
4304: l_ctr := l_account_rec_tab.ip_account_id.count;
4305: --
4306: FORALL i in 1 .. l_ctr
4307: INSERT INTO CSI_IP_ACCOUNTS(
4308: IP_ACCOUNT_ID,
4309: INSTANCE_PARTY_ID,
4310: PARTY_ACCOUNT_ID,
4311: RELATIONSHIP_TYPE_CODE,

Line 4398: INSERT INTO CSI_IP_ACCOUNTS_H(

4394: --
4395: l_ctr := l_acct_hist_rec_tab.ip_account_history_id.count;
4396: --
4397: FORALL i in 1 .. l_ctr
4398: INSERT INTO CSI_IP_ACCOUNTS_H(
4399: IP_ACCOUNT_HISTORY_ID,
4400: IP_ACCOUNT_ID,
4401: TRANSACTION_ID,
4402: OLD_PARTY_ACCOUNT_ID,

Line 8077: DELETE FROM CSI_IP_ACCOUNTS WHERE instance_party_id in (SELECT instance_party_id

8073: BEGIN
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

Line 8096: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);

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);
8099: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8100: DELETE FROM CSI_I_PRICING_ATTRIBS_H WHERE transaction_id = l_del_txn_tbl(j);

Line 8510: from csi_ip_accounts

8506: CURSOR non_owner_csr (p_ins_pty_id NUMBER) IS
8507: SELECT ip_account_id
8508: ,active_end_date
8509: ,object_version_number
8510: from csi_ip_accounts
8511: where instance_party_id=p_ins_pty_id
8512: and relationship_type_code<>'OWNER';
8513:
8514: BEGIN