APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_IP_ACCOUNTS_H

Line 497: select CSI_IP_ACCOUNTS_H_S.nextval

493: ,p_account_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
494: ) IS
495: BEGIN
496: FOR i in p_account_tbl.FIRST .. p_account_tbl.LAST LOOP
497: select CSI_IP_ACCOUNTS_H_S.nextval
498: into p_account_hist_tbl(i) from dual;
499: --
500: p_account_rec_tab.ip_account_id(i) := p_account_tbl(i).ip_account_id;
501: p_account_rec_tab.parent_tbl_index(i) := p_account_tbl(i).parent_tbl_index;

Line 2153: INSERT INTO CSI_IP_ACCOUNTS_H(

2149: --
2150: -- Insert into History
2151: log('Before Inserting into Party Accounts history');
2152: FORALL i in 1 .. l_account_rec_tab.ip_account_id.count
2153: INSERT INTO CSI_IP_ACCOUNTS_H(
2154: IP_ACCOUNT_HISTORY_ID,
2155: IP_ACCOUNT_ID,
2156: TRANSACTION_ID,
2157: NEW_PARTY_ACCOUNT_ID,

Line 10468: from CSI_IP_ACCOUNTS_H

10464: END IF;
10465: --
10466: select min(ip_account_history_id)
10467: into v_min_ret_id
10468: from CSI_IP_ACCOUNTS_H
10469: where ip_account_id = v_max_ip_acct_id;
10470: --
10471: v_old_account_id := NULL;
10472: --

Line 10477: from CSI_IP_ACCOUNTS_H

10473: FOR acct in ACCT_CUR(party.instance_party_id,v_max_ip_acct_id) LOOP
10474: v_min_history_id := NULL;
10475: select min(ip_account_history_id)
10476: into v_min_history_id
10477: from CSI_IP_ACCOUNTS_H
10478: where ip_account_id = acct.ip_account_id;
10479: --
10480: IF v_min_history_id IS NULL THEN
10481: Raise Process_next;

Line 10485: Update CSI_IP_ACCOUNTS_H

10481: Raise Process_next;
10482: END IF;
10483: --
10484: IF ACCT_CUR%ROWCOUNT > 1 THEN
10485: Update CSI_IP_ACCOUNTS_H
10486: set old_party_account_id = v_old_account_id
10487: where ip_account_history_id = v_min_history_id;
10488: END IF;
10489: --

Line 10490: DELETE from CSI_IP_ACCOUNTS_H

10486: set old_party_account_id = v_old_account_id
10487: where ip_account_history_id = v_min_history_id;
10488: END IF;
10489: --
10490: DELETE from CSI_IP_ACCOUNTS_H
10491: where ip_account_id = acct.ip_account_id
10492: and ip_account_history_id <> v_min_history_id;
10493: --
10494: v_old_account_id := NULL;

Line 10498: from CSI_IP_ACCOUNTS_H

10494: v_old_account_id := NULL;
10495: Begin
10496: select new_party_account_id
10497: into v_old_account_id
10498: from CSI_IP_ACCOUNTS_H
10499: where ip_account_history_id = v_min_history_id;
10500: Exception
10501: when no_data_found then
10502: v_old_account_id := NULL;

Line 10505: Update CSI_IP_ACCOUNTS_H

10501: when no_data_found then
10502: v_old_account_id := NULL;
10503: End;
10504: --
10505: Update CSI_IP_ACCOUNTS_H
10506: set ip_account_id = v_max_ip_acct_id
10507: where ip_account_history_id = v_min_history_id;
10508: --
10509: Delete from CSI_IP_ACCOUNTS

Line 10518: Update CSI_IP_ACCOUNTS_H

10514: v_commit_counter := 0;
10515: commit;
10516: END IF;
10517: END LOOP;
10518: Update CSI_IP_ACCOUNTS_H
10519: set old_party_account_id = v_old_account_id
10520: where ip_account_history_id = v_min_ret_id;
10521: Exception
10522: when Process_next Then

Line 10817: INSERT INTO CSI_IP_ACCOUNTS_H

10813: from CSI_IP_ACCOUNTS
10814: where instance_party_id = l_ip_id
10815: and relationship_type_code = 'OWNER';
10816: --
10817: INSERT INTO CSI_IP_ACCOUNTS_H
10818: ( IP_ACCOUNT_HISTORY_ID
10819: ,IP_ACCOUNT_ID
10820: ,TRANSACTION_ID
10821: ,OLD_ACTIVE_END_DATE

Line 10831: ( CSI_IP_ACCOUNTS_H_S.nextval

10827: ,LAST_UPDATE_LOGIN
10828: ,OBJECT_VERSION_NUMBER
10829: )
10830: VALUES
10831: ( CSI_IP_ACCOUNTS_H_S.nextval
10832: ,l_ip_account_id
10833: ,l_txn_id
10834: ,NULL
10835: ,SYSDATE