APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_IP_ACCOUNTS

Line 1161: select CSI_IP_ACCOUNTS_H_S.nextval

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

Line 4304: INSERT INTO CSI_IP_ACCOUNTS(

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

Line 4395: INSERT INTO CSI_IP_ACCOUNTS_H(

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

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

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

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

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

Line 7973: from csi_ip_accounts

7969: CURSOR non_owner_csr (p_ins_pty_id NUMBER) IS
7970: SELECT ip_account_id
7971: ,active_end_date
7972: ,object_version_number
7973: from csi_ip_accounts
7974: where instance_party_id=p_ins_pty_id
7975: and relationship_type_code<>'OWNER';
7976:
7977: BEGIN