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

4673: object_version_number
4674: INTO p_party_account_rec.ip_account_id,
4675: p_party_account_rec.active_start_date,
4676: p_party_account_rec.object_version_number
4677: FROM csi_ip_accounts
4678: WHERE instance_party_id = p_party_account_rec.instance_party_id
4679: AND relationship_type_code = 'OWNER'
4680: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
4681: AND ROWNUM = 1;

Line 4698: FROM csi_ip_accounts

4694: object_version_number
4695: INTO p_party_account_rec.ip_account_id,
4696: p_party_account_rec.active_start_date,
4697: p_party_account_rec.object_version_number
4698: FROM csi_ip_accounts
4699: WHERE instance_party_id = p_party_account_rec.instance_party_id
4700: AND relationship_type_code = 'OWNER'
4701: AND ROWNUM = 1;
4702:

Line 4759: FROM csi_ip_accounts

4755: SELECT ip_account_id ,
4756: object_version_number
4757: INTO p_party_account_rec.ip_account_id,
4758: p_party_account_rec.object_version_number
4759: FROM csi_ip_accounts
4760: WHERE instance_party_id = p_party_account_rec.instance_party_id
4761: AND party_account_id = p_party_account_rec.party_account_id
4762: AND relationship_type_code = p_party_account_rec.relationship_type_code
4763: AND active_end_date < sysdate

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

5068: set owner_party_account_id = p_party_account_rec.party_account_id
5069: where instance_id = l_party_rec.instance_id;
5070: END IF;
5071:
5072: -- Call table handlers to insert into csi_ip_accounts table
5073: CSI_IP_ACCOUNTS_PKG.Insert_Row(
5074: px_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
5075: p_INSTANCE_PARTY_ID => p_party_account_rec.INSTANCE_PARTY_ID,
5076: p_PARTY_ACCOUNT_ID => p_party_account_rec.PARTY_ACCOUNT_ID,

Line 5073: CSI_IP_ACCOUNTS_PKG.Insert_Row(

5069: where instance_id = l_party_rec.instance_id;
5070: END IF;
5071:
5072: -- Call table handlers to insert into csi_ip_accounts table
5073: CSI_IP_ACCOUNTS_PKG.Insert_Row(
5074: px_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
5075: p_INSTANCE_PARTY_ID => p_party_account_rec.INSTANCE_PARTY_ID,
5076: p_PARTY_ACCOUNT_ID => p_party_account_rec.PARTY_ACCOUNT_ID,
5077: p_RELATIONSHIP_TYPE_CODE => p_party_account_rec.RELATIONSHIP_TYPE_CODE,

Line 5141: CSI_IP_ACCOUNTS_H_PKG.Insert_Row

5137:
5138: -- Generate a unique instance_party_history_id from the sequence
5139: l_ip_account_history_id := CSI_Instance_parties_vld_pvt.gen_ip_account_hist_id;
5140:
5141: CSI_IP_ACCOUNTS_H_PKG.Insert_Row
5142: (
5143: px_IP_ACCOUNT_HISTORY_ID => l_ip_account_history_id ,
5144: p_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
5145: p_TRANSACTION_ID => p_txn_rec.transaction_id ,

Line 5389: FROM CSI_IP_ACCOUNTS

5385: attribute13 ,
5386: attribute14 ,
5387: attribute15 ,
5388: object_version_number
5389: FROM CSI_IP_ACCOUNTS
5390: WHERE IP_ACCOUNT_ID = p_ip_account_id
5391: FOR UPDATE OF OBJECT_VERSION_NUMBER;
5392: --AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE));
5393:

Line 5449: FROM csi_ip_accounts_h

5445: ,new_ship_to_address
5446: ,full_dump_flag
5447: ,old_instance_party_id
5448: ,new_instance_party_id
5449: FROM csi_ip_accounts_h
5450: WHERE csi_ip_accounts_h.ip_account_history_id = p_act_hist_id
5451: FOR UPDATE OF object_version_number ;
5452: l_pty_acct_csr pty_acct_csr%ROWTYPE;
5453: l_ip_acct_hist_id NUMBER;

Line 5450: WHERE csi_ip_accounts_h.ip_account_history_id = p_act_hist_id

5446: ,full_dump_flag
5447: ,old_instance_party_id
5448: ,new_instance_party_id
5449: FROM csi_ip_accounts_h
5450: WHERE csi_ip_accounts_h.ip_account_history_id = p_act_hist_id
5451: FOR UPDATE OF object_version_number ;
5452: l_pty_acct_csr pty_acct_csr%ROWTYPE;
5453: l_ip_acct_hist_id NUMBER;
5454: l_old_pty_acct_id NUMBER; -- Added by sguthiva for bug 2307804

Line 5806: FROM csi_ip_accounts

5802: l_found_for_update:='T';
5803: BEGIN
5804: SELECT 'x'
5805: INTO l_dummy
5806: FROM csi_ip_accounts
5807: WHERE instance_party_id = l_alt_pk_inst_pty_id
5808: AND party_account_id = l_alt_pk_pty_acct_id
5809: AND relationship_type_code = l_alt_pk_rel_type_code
5810: AND ((active_end_date IS NULL) OR (active_end_date >= sysdate))

Line 5818: FROM csi_ip_accounts

5814: -- I need to expire(if active) this record.
5815: BEGIN
5816: SELECT active_end_date
5817: INTO l_temp_acct_date
5818: FROM csi_ip_accounts
5819: WHERE ip_account_id=p_party_account_rec.ip_account_id
5820: AND ((active_end_date IS NULL) OR (active_end_date > sysdate));
5821: -- Active record found so make it inactive.
5822: l_temp_acct_date:=sysdate;

Line 5892: CSI_IP_ACCOUNTS_PKG.Update_Row

5888: -- Increment the object_version_number before updating
5889: l_OBJECT_VERSION_NUMBER := l_curr_party_acct_rec.OBJECT_VERSION_NUMBER + 1 ;
5890:
5891: -- Calling table table handler to update
5892: CSI_IP_ACCOUNTS_PKG.Update_Row
5893: (
5894: p_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
5895: p_INSTANCE_PARTY_ID => p_party_account_rec.INSTANCE_PARTY_ID,
5896: p_PARTY_ACCOUNT_ID => p_party_account_rec.PARTY_ACCOUNT_ID,

Line 5983: FROM csi_ip_accounts_h h

5979: -- Start of changes for Bug#2547034 on 09/20/02 - rtalluri
5980: BEGIN
5981: SELECT ip_account_history_id
5982: INTO l_ip_acct_hist_id
5983: FROM csi_ip_accounts_h h
5984: WHERE h.transaction_id = p_txn_rec.transaction_id
5985: AND h.ip_account_id = p_party_account_rec.ip_account_id;
5986:
5987: OPEN pty_acct_csr(l_ip_acct_hist_id);

Line 5992: CSI_IP_ACCOUNTS_H_PKG.Update_Row

5988: FETCH pty_acct_csr INTO l_pty_acct_csr ;
5989: CLOSE pty_acct_csr;
5990: IF l_pty_acct_csr.full_dump_flag = 'Y'
5991: THEN
5992: CSI_IP_ACCOUNTS_H_PKG.Update_Row
5993: (
5994: p_IP_ACCOUNT_HISTORY_ID => l_ip_acct_hist_id ,
5995: p_IP_ACCOUNT_ID => fnd_api.g_miss_num ,
5996: p_TRANSACTION_ID => fnd_api.g_miss_num ,

Line 6399: CSI_IP_ACCOUNTS_H_PKG.Update_Row

6395: l_pty_acct_csr.old_instance_party_id := fnd_api.g_miss_num;
6396: l_pty_acct_csr.new_instance_party_id := l_temp_party_account_rec.instance_party_id;
6397: END IF;
6398:
6399: CSI_IP_ACCOUNTS_H_PKG.Update_Row
6400: (
6401: p_IP_ACCOUNT_HISTORY_ID => l_ip_acct_hist_id ,
6402: p_IP_ACCOUNT_ID => fnd_api.g_miss_num ,
6403: p_TRANSACTION_ID => fnd_api.g_miss_num ,

Line 6534: CSI_IP_ACCOUNTS_H_PKG.Insert_Row

6530: l_temp_party_account_rec.ATTRIBUTE15 := l_curr_party_acct_rec.ATTRIBUTE15 ;
6531: END IF;
6532:
6533: -- Call table handlers to insert into csi_i_parties_h table
6534: CSI_IP_ACCOUNTS_H_PKG.Insert_Row
6535: (
6536: px_IP_ACCOUNT_HISTORY_ID => l_ip_account_history_id ,
6537: p_IP_ACCOUNT_ID => p_party_account_rec.ip_account_id,
6538: p_TRANSACTION_ID => p_txn_rec.transaction_id ,

Line 6830: CSI_IP_ACCOUNTS_H_PKG.Insert_Row

6826: l_account_hist_rec.new_instance_party_id := p_party_account_rec.instance_party_id ;
6827: END IF;
6828: -- End addition
6829: -- Call table handlers to insert into csi_i_parties_h table
6830: CSI_IP_ACCOUNTS_H_PKG.Insert_Row
6831: (
6832: px_IP_ACCOUNT_HISTORY_ID => l_ip_account_history_id ,
6833: p_IP_ACCOUNT_ID => p_party_account_rec.IP_ACCOUNT_ID ,
6834: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 7228: FROM CSI_IP_ACCOUNTS

7224: attribute13 ,
7225: attribute14 ,
7226: attribute15 ,
7227: object_version_number
7228: FROM CSI_IP_ACCOUNTS
7229: WHERE IP_ACCOUNT_ID = p_ip_account_id
7230: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
7231: FOR UPDATE OF OBJECT_VERSION_NUMBER;
7232:

Line 8663: FROM csi_ip_accounts_h cah,

8659: cip.INSTANCE_ID,
8660: cah.OLD_INSTANCE_PARTY_ID ,
8661: cah.NEW_INSTANCE_PARTY_ID,
8662: cah.creation_date
8663: FROM csi_ip_accounts_h cah,
8664: csi_ip_accounts ca,
8665: csi_i_parties cip
8666: WHERE cah.transaction_id = i_transaction_id
8667: AND cah.ip_account_id = ca.ip_account_id

Line 8664: csi_ip_accounts ca,

8660: cah.OLD_INSTANCE_PARTY_ID ,
8661: cah.NEW_INSTANCE_PARTY_ID,
8662: cah.creation_date
8663: FROM csi_ip_accounts_h cah,
8664: csi_ip_accounts ca,
8665: csi_i_parties cip
8666: WHERE cah.transaction_id = i_transaction_id
8667: AND cah.ip_account_id = ca.ip_account_id
8668: AND ca.instance_party_id = cip.instance_party_id; -- Added by sguthiva on 9-APR for bug 2304649