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

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 2286: FROM csi_ip_accounts

2282: CURSOR GET_IP_ACCOUNT (p_inst_party_id IN NUMBER) IS
2283: SELECT
2284: ip_account_id,
2285: object_version_number
2286: FROM csi_ip_accounts
2287: WHERE instance_party_id = p_inst_party_id
2288: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE)) ;
2289:
2290: CURSOR get_curr_party_rec (p_inst_party_id IN NUMBER) IS

Line 4638: FROM csi_ip_accounts

4634: object_version_number
4635: INTO p_party_account_rec.ip_account_id,
4636: p_party_account_rec.active_start_date,
4637: p_party_account_rec.object_version_number
4638: FROM csi_ip_accounts
4639: WHERE instance_party_id = p_party_account_rec.instance_party_id
4640: AND relationship_type_code = 'OWNER'
4641: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
4642: AND ROWNUM = 1;

Line 4659: FROM csi_ip_accounts

4655: object_version_number
4656: INTO p_party_account_rec.ip_account_id,
4657: p_party_account_rec.active_start_date,
4658: p_party_account_rec.object_version_number
4659: FROM csi_ip_accounts
4660: WHERE instance_party_id = p_party_account_rec.instance_party_id
4661: AND relationship_type_code = 'OWNER'
4662: AND ROWNUM = 1;
4663:

Line 4720: FROM csi_ip_accounts

4716: SELECT ip_account_id ,
4717: object_version_number
4718: INTO p_party_account_rec.ip_account_id,
4719: p_party_account_rec.object_version_number
4720: FROM csi_ip_accounts
4721: WHERE instance_party_id = p_party_account_rec.instance_party_id
4722: AND party_account_id = p_party_account_rec.party_account_id
4723: AND relationship_type_code = p_party_account_rec.relationship_type_code
4724: AND active_end_date < sysdate

Line 5033: -- Call table handlers to insert into csi_ip_accounts table

5029: set owner_party_account_id = p_party_account_rec.party_account_id
5030: where instance_id = l_party_rec.instance_id;
5031: END IF;
5032:
5033: -- Call table handlers to insert into csi_ip_accounts table
5034: CSI_IP_ACCOUNTS_PKG.Insert_Row(
5035: px_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
5036: p_INSTANCE_PARTY_ID => p_party_account_rec.INSTANCE_PARTY_ID,
5037: p_PARTY_ACCOUNT_ID => p_party_account_rec.PARTY_ACCOUNT_ID,

Line 5034: CSI_IP_ACCOUNTS_PKG.Insert_Row(

5030: where instance_id = l_party_rec.instance_id;
5031: END IF;
5032:
5033: -- Call table handlers to insert into csi_ip_accounts table
5034: CSI_IP_ACCOUNTS_PKG.Insert_Row(
5035: px_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
5036: p_INSTANCE_PARTY_ID => p_party_account_rec.INSTANCE_PARTY_ID,
5037: p_PARTY_ACCOUNT_ID => p_party_account_rec.PARTY_ACCOUNT_ID,
5038: p_RELATIONSHIP_TYPE_CODE => p_party_account_rec.RELATIONSHIP_TYPE_CODE,

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 5348: FROM CSI_IP_ACCOUNTS

5344: attribute13 ,
5345: attribute14 ,
5346: attribute15 ,
5347: object_version_number
5348: FROM CSI_IP_ACCOUNTS
5349: WHERE IP_ACCOUNT_ID = p_ip_account_id
5350: FOR UPDATE OF OBJECT_VERSION_NUMBER;
5351: --AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE));
5352:

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 5765: FROM csi_ip_accounts

5761: l_found_for_update:='T';
5762: BEGIN
5763: SELECT 'x'
5764: INTO l_dummy
5765: FROM csi_ip_accounts
5766: WHERE instance_party_id = l_alt_pk_inst_pty_id
5767: AND party_account_id = l_alt_pk_pty_acct_id
5768: AND relationship_type_code = l_alt_pk_rel_type_code
5769: AND ((active_end_date IS NULL) OR (active_end_date >= sysdate))

Line 5777: FROM csi_ip_accounts

5773: -- I need to expire(if active) this record.
5774: BEGIN
5775: SELECT active_end_date
5776: INTO l_temp_acct_date
5777: FROM csi_ip_accounts
5778: WHERE ip_account_id=p_party_account_rec.ip_account_id
5779: AND ((active_end_date IS NULL) OR (active_end_date > sysdate));
5780: -- Active record found so make it inactive.
5781: l_temp_acct_date:=sysdate;

Line 5851: CSI_IP_ACCOUNTS_PKG.Update_Row

5847: -- Increment the object_version_number before updating
5848: l_OBJECT_VERSION_NUMBER := l_curr_party_acct_rec.OBJECT_VERSION_NUMBER + 1 ;
5849:
5850: -- Calling table table handler to update
5851: CSI_IP_ACCOUNTS_PKG.Update_Row
5852: (
5853: p_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
5854: p_INSTANCE_PARTY_ID => p_party_account_rec.INSTANCE_PARTY_ID,
5855: p_PARTY_ACCOUNT_ID => p_party_account_rec.PARTY_ACCOUNT_ID,

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 7178: FROM CSI_IP_ACCOUNTS

7174: attribute13 ,
7175: attribute14 ,
7176: attribute15 ,
7177: object_version_number
7178: FROM CSI_IP_ACCOUNTS
7179: WHERE IP_ACCOUNT_ID = p_ip_account_id
7180: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
7181: FOR UPDATE OF OBJECT_VERSION_NUMBER;
7182:

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

Line 8614: csi_ip_accounts ca,

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
8618: AND ca.instance_party_id = cip.instance_party_id; -- Added by sguthiva on 9-APR for bug 2304649