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_I_PARTIES_H

Line 790: FROM CSI_I_PARTIES_H

786: NEW_ATTRIBUTE14 ,
787: NEW_ATTRIBUTE15 ,
788: NEW_PRIMARY_FLAG ,
789: NEW_PREFERRED_FLAG
790: FROM CSI_I_PARTIES_H
791: WHERE instance_party_id = p_inst_pty_id
792: -- and creation_date < x_first_no_dump
793: -- and full_dump_flag = 'N'
794: order by creation_date;

Line 876: FROM CSI_I_PARTIES_H

872: NEW_ATTRIBUTE14 ,
873: NEW_ATTRIBUTE15 ,
874: NEW_PRIMARY_FLAG ,
875: NEW_PREFERRED_FLAG
876: FROM CSI_I_PARTIES_H
877: WHERE instance_party_history_id = p_inst_pty_hist_id
878: and full_dump_flag = 'Y' ;
879:
880: BEGIN

Line 936: FROM CSI_I_PARTIES_H

932:
933: CURSOR get_nearest_full_dump(p_inst_party_id IN NUMBER ,p_time IN DATE) IS
934: SELECT
935: MAX(instance_party_history_id)
936: FROM CSI_I_PARTIES_H
937: WHERE creation_date <= p_time
938: and instance_party_id = p_inst_party_id
939: and full_dump_flag = 'Y' ;
940:

Line 996: FROM CSI_I_PARTIES_H

992: OLD_PRIMARY_FLAG ,
993: NEW_PRIMARY_FLAG ,
994: OLD_PREFERRED_FLAG ,
995: NEW_PREFERRED_FLAG
996: FROM CSI_I_PARTIES_H
997: WHERE creation_date <= p_time
998: and creation_date >= p_nearest_full_dump
999: and instance_party_id = p_inst_party_id
1000: and full_dump_flag = 'N'

Line 2126: -- Call table handlers to insert into csi_i_parties_h table

2122:
2123: -- Generate a unique instance_party_history_id from the sequence
2124: l_inst_party_his_id := CSI_Instance_parties_vld_pvt.gen_inst_party_hist_id;
2125:
2126: -- Call table handlers to insert into csi_i_parties_h table
2127: CSI_I_PARTIES_H_PKG.Insert_Row
2128: (
2129: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
2130: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,

Line 2127: CSI_I_PARTIES_H_PKG.Insert_Row

2123: -- Generate a unique instance_party_history_id from the sequence
2124: l_inst_party_his_id := CSI_Instance_parties_vld_pvt.gen_inst_party_hist_id;
2125:
2126: -- Call table handlers to insert into csi_i_parties_h table
2127: CSI_I_PARTIES_H_PKG.Insert_Row
2128: (
2129: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
2130: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,
2131: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 2551: FROM csi_i_parties_h

2547: ,old_primary_flag
2548: ,new_primary_flag
2549: ,old_preferred_flag
2550: ,new_preferred_flag
2551: FROM csi_i_parties_h
2552: WHERE csi_i_parties_h.instance_party_history_id = p_party_hist_id
2553: FOR UPDATE OF object_version_number ;
2554: l_pty_hist_csr pty_hist_csr%rowtype;
2555: l_party_hist_id NUMBER;

Line 2552: WHERE csi_i_parties_h.instance_party_history_id = p_party_hist_id

2548: ,new_primary_flag
2549: ,old_preferred_flag
2550: ,new_preferred_flag
2551: FROM csi_i_parties_h
2552: WHERE csi_i_parties_h.instance_party_history_id = p_party_hist_id
2553: FOR UPDATE OF object_version_number ;
2554: l_pty_hist_csr pty_hist_csr%rowtype;
2555: l_party_hist_id NUMBER;
2556: l_open_service VARCHAR2(1);

Line 3175: FROM csi_i_parties_h h

3171: -- Start of Changes for Bug#2547034 on 09/20/02 - rtalluri
3172: BEGIN
3173: SELECT instance_party_history_id
3174: INTO l_party_hist_id
3175: FROM csi_i_parties_h h
3176: WHERE h.transaction_id = p_txn_rec.transaction_id
3177: AND h.instance_party_id = p_party_rec.instance_party_id;
3178:
3179: OPEN pty_hist_csr(l_party_hist_id);

Line 3185: CSI_I_PARTIES_H_PKG.update_Row

3181: CLOSE pty_hist_csr;
3182:
3183: IF l_pty_hist_csr.full_dump_flag = 'Y'
3184: THEN
3185: CSI_I_PARTIES_H_PKG.update_Row
3186: (
3187: p_INSTANCE_PARTY_HISTORY_ID => l_party_hist_id ,
3188: p_INSTANCE_PARTY_ID => fnd_api.g_miss_num ,
3189: p_TRANSACTION_ID => fnd_api.g_miss_num ,

Line 3625: CSI_I_PARTIES_H_PKG.update_Row

3621: l_pty_hist_csr.old_preferred_flag := fnd_api.g_miss_char;
3622: l_pty_hist_csr.new_preferred_flag := l_temp_party_rec.preferred_flag;
3623: END IF;
3624:
3625: CSI_I_PARTIES_H_PKG.update_Row
3626: (
3627: p_INSTANCE_PARTY_HISTORY_ID => l_party_hist_id ,
3628: p_INSTANCE_PARTY_ID => FND_API.G_MISS_NUM ,
3629: p_TRANSACTION_ID => FND_API.G_MISS_NUM ,

Line 3772: -- Call table handlers to insert into csi_i_parties_h table

3768: IF (p_party_rec.PREFERRED_FLAG = FND_API.G_MISS_CHAR) THEN
3769: l_temp_party_rec.PREFERRED_FLAG := l_curr_party_rec.PREFERRED_FLAG ;
3770: END IF;
3771:
3772: -- Call table handlers to insert into csi_i_parties_h table
3773: CSI_I_PARTIES_H_PKG.Insert_Row
3774: (
3775: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
3776: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,

Line 3773: CSI_I_PARTIES_H_PKG.Insert_Row

3769: l_temp_party_rec.PREFERRED_FLAG := l_curr_party_rec.PREFERRED_FLAG ;
3770: END IF;
3771:
3772: -- Call table handlers to insert into csi_i_parties_h table
3773: CSI_I_PARTIES_H_PKG.Insert_Row
3774: (
3775: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
3776: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,
3777: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 4089: -- Call table handlers to insert into csi_i_parties_h table

4085: l_party_hist_rec.old_preferred_flag := l_curr_party_rec.preferred_flag ;
4086: l_party_hist_rec.new_preferred_flag := p_party_rec.preferred_flag ;
4087: END IF;
4088:
4089: -- Call table handlers to insert into csi_i_parties_h table
4090: CSI_I_PARTIES_H_PKG.Insert_Row
4091: (
4092: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
4093: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,

Line 4090: CSI_I_PARTIES_H_PKG.Insert_Row

4086: l_party_hist_rec.new_preferred_flag := p_party_rec.preferred_flag ;
4087: END IF;
4088:
4089: -- Call table handlers to insert into csi_i_parties_h table
4090: CSI_I_PARTIES_H_PKG.Insert_Row
4091: (
4092: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
4093: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,
4094: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

Line 6492: -- Call table handlers to insert into csi_i_parties_h table

6488: IF (p_party_account_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN
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,

Line 6788: -- Call table handlers to insert into csi_i_parties_h table

6784: l_account_hist_rec.old_instance_party_id := l_curr_party_acct_rec.instance_party_id ;
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 ,

Line 6894: from CSI_I_PARTIES_H

6890: l_new_party_id := null;
6891: Begin
6892: select old_party_id,new_party_id
6893: into l_old_party_id,l_new_party_id
6894: from CSI_I_PARTIES_H
6895: where instance_party_id = l_party_rec.instance_party_id
6896: and transaction_id = p_txn_rec.transaction_id;
6897: Exception
6898: when no_data_found then

Line 7889: FROM csi_i_parties_h ciph,

7885: ciph.OLD_PRIMARY_FLAG,
7886: ciph.NEW_PRIMARY_FLAG,
7887: cip.INSTANCE_ID,
7888: ciph.creation_date --Added for bug 2781480
7889: FROM csi_i_parties_h ciph,
7890: csi_i_parties cip
7891: WHERE ciph.transaction_id = i_transaction_id
7892: AND ciph.instance_party_id = cip.instance_party_id; -- Added by sk on 08-APR for fixing bug
7893: -- 2304649 .