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_PARTY_RELATIONSHIPS_PVT dependencies on CSI_IP_ACCOUNTS_H

Line 49: FROM CSI_IP_ACCOUNTS_H

45: NEW_ATTRIBUTE14 ,
46: NEW_ATTRIBUTE15 ,
47: NEW_BILL_TO_ADDRESS ,
48: NEW_SHIP_TO_ADDRESS
49: FROM CSI_IP_ACCOUNTS_H
50: WHERE ip_account_id = i_ip_acct_id
51: --and full_dump_flag = 'N'
52: --and creation_date < x_first_no_dump
53: order by creation_date;

Line 125: FROM CSI_IP_ACCOUNTS_H

121: NEW_ATTRIBUTE14 ,
122: NEW_ATTRIBUTE15 ,
123: NEW_BILL_TO_ADDRESS ,
124: NEW_SHIP_TO_ADDRESS
125: FROM CSI_IP_ACCOUNTS_H
126: WHERE ip_account_history_id = p_ip_acct_hist_id
127: and full_dump_flag = 'Y';
128:
129: BEGIN

Line 181: FROM CSI_IP_ACCOUNTS_H

177:
178: CURSOR get_nearest_full_dump(p_ip_acct_id IN NUMBER ,p_time IN DATE) IS
179: SELECT
180: MAX(ip_account_history_id)
181: FROM CSI_IP_ACCOUNTS_H
182: WHERE creation_date <= p_time
183: and ip_account_id = p_ip_acct_id
184: and full_dump_flag = 'Y' ;
185:

Line 235: FROM CSI_IP_ACCOUNTS_H

231: OLD_BILL_TO_ADDRESS ,
232: NEW_BILL_TO_ADDRESS ,
233: OLD_SHIP_TO_ADDRESS ,
234: NEW_SHIP_TO_ADDRESS
235: FROM CSI_IP_ACCOUNTS_H
236: WHERE creation_date <= p_time
237: and creation_date >= p_nearest_full_dump
238: and ip_account_id = p_ip_account_id
239: ORDER BY creation_date;

Line 5102: CSI_IP_ACCOUNTS_H_PKG.Insert_Row

5098:
5099: -- Generate a unique instance_party_history_id from the sequence
5100: l_ip_account_history_id := CSI_Instance_parties_vld_pvt.gen_ip_account_hist_id;
5101:
5102: CSI_IP_ACCOUNTS_H_PKG.Insert_Row
5103: (
5104: px_IP_ACCOUNT_HISTORY_ID => l_ip_account_history_id ,
5105: p_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
5106: p_TRANSACTION_ID => p_txn_rec.transaction_id ,

Line 5408: FROM csi_ip_accounts_h

5404: ,new_ship_to_address
5405: ,full_dump_flag
5406: ,old_instance_party_id
5407: ,new_instance_party_id
5408: FROM csi_ip_accounts_h
5409: WHERE csi_ip_accounts_h.ip_account_history_id = p_act_hist_id
5410: FOR UPDATE OF object_version_number ;
5411: l_pty_acct_csr pty_acct_csr%ROWTYPE;
5412: l_ip_acct_hist_id NUMBER;

Line 5409: WHERE csi_ip_accounts_h.ip_account_history_id = p_act_hist_id

5405: ,full_dump_flag
5406: ,old_instance_party_id
5407: ,new_instance_party_id
5408: FROM csi_ip_accounts_h
5409: WHERE csi_ip_accounts_h.ip_account_history_id = p_act_hist_id
5410: FOR UPDATE OF object_version_number ;
5411: l_pty_acct_csr pty_acct_csr%ROWTYPE;
5412: l_ip_acct_hist_id NUMBER;
5413: l_old_pty_acct_id NUMBER; -- Added by sguthiva for bug 2307804

Line 5942: FROM csi_ip_accounts_h h

5938: -- Start of changes for Bug#2547034 on 09/20/02 - rtalluri
5939: BEGIN
5940: SELECT ip_account_history_id
5941: INTO l_ip_acct_hist_id
5942: FROM csi_ip_accounts_h h
5943: WHERE h.transaction_id = p_txn_rec.transaction_id
5944: AND h.ip_account_id = p_party_account_rec.ip_account_id;
5945:
5946: OPEN pty_acct_csr(l_ip_acct_hist_id);

Line 5951: CSI_IP_ACCOUNTS_H_PKG.Update_Row

5947: FETCH pty_acct_csr INTO l_pty_acct_csr ;
5948: CLOSE pty_acct_csr;
5949: IF l_pty_acct_csr.full_dump_flag = 'Y'
5950: THEN
5951: CSI_IP_ACCOUNTS_H_PKG.Update_Row
5952: (
5953: p_IP_ACCOUNT_HISTORY_ID => l_ip_acct_hist_id ,
5954: p_IP_ACCOUNT_ID => fnd_api.g_miss_num ,
5955: p_TRANSACTION_ID => fnd_api.g_miss_num ,

Line 6358: CSI_IP_ACCOUNTS_H_PKG.Update_Row

6354: l_pty_acct_csr.old_instance_party_id := fnd_api.g_miss_num;
6355: l_pty_acct_csr.new_instance_party_id := l_temp_party_account_rec.instance_party_id;
6356: END IF;
6357:
6358: CSI_IP_ACCOUNTS_H_PKG.Update_Row
6359: (
6360: p_IP_ACCOUNT_HISTORY_ID => l_ip_acct_hist_id ,
6361: p_IP_ACCOUNT_ID => fnd_api.g_miss_num ,
6362: p_TRANSACTION_ID => fnd_api.g_miss_num ,

Line 6493: CSI_IP_ACCOUNTS_H_PKG.Insert_Row

6489: l_temp_party_account_rec.ATTRIBUTE15 := l_curr_party_acct_rec.ATTRIBUTE15 ;
6490: END IF;
6491:
6492: -- Call table handlers to insert into csi_i_parties_h table
6493: CSI_IP_ACCOUNTS_H_PKG.Insert_Row
6494: (
6495: px_IP_ACCOUNT_HISTORY_ID => l_ip_account_history_id ,
6496: p_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
6497: p_TRANSACTION_ID => p_txn_rec.transaction_id ,

Line 6789: CSI_IP_ACCOUNTS_H_PKG.Insert_Row

6785: l_account_hist_rec.new_instance_party_id := p_party_account_rec.instance_party_id ;
6786: END IF;
6787: -- End addition
6788: -- Call table handlers to insert into csi_i_parties_h table
6789: CSI_IP_ACCOUNTS_H_PKG.Insert_Row
6790: (
6791: px_IP_ACCOUNT_HISTORY_ID => l_ip_account_history_id ,
6792: p_IP_ACCOUNT_ID => p_party_account_rec.IP_ACCOUNT_ID ,
6793: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 8613: FROM csi_ip_accounts_h cah,

8609: cip.INSTANCE_ID,
8610: cah.OLD_INSTANCE_PARTY_ID ,
8611: cah.NEW_INSTANCE_PARTY_ID,
8612: cah.creation_date
8613: FROM csi_ip_accounts_h cah,
8614: csi_ip_accounts ca,
8615: csi_i_parties cip
8616: WHERE cah.transaction_id = i_transaction_id
8617: AND cah.ip_account_id = ca.ip_account_id