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 2552: FROM csi_i_parties_h

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

Line 2553: WHERE csi_i_parties_h.instance_party_history_id = p_party_hist_id

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

Line 3214: FROM csi_i_parties_h h

3210: -- Start of Changes for Bug#2547034 on 09/20/02 - rtalluri
3211: BEGIN
3212: SELECT instance_party_history_id
3213: INTO l_party_hist_id
3214: FROM csi_i_parties_h h
3215: WHERE h.transaction_id = p_txn_rec.transaction_id
3216: AND h.instance_party_id = p_party_rec.instance_party_id;
3217:
3218: OPEN pty_hist_csr(l_party_hist_id);

Line 3224: CSI_I_PARTIES_H_PKG.update_Row

3220: CLOSE pty_hist_csr;
3221:
3222: IF l_pty_hist_csr.full_dump_flag = 'Y'
3223: THEN
3224: CSI_I_PARTIES_H_PKG.update_Row
3225: (
3226: p_INSTANCE_PARTY_HISTORY_ID => l_party_hist_id ,
3227: p_INSTANCE_PARTY_ID => fnd_api.g_miss_num ,
3228: p_TRANSACTION_ID => fnd_api.g_miss_num ,

Line 3664: CSI_I_PARTIES_H_PKG.update_Row

3660: l_pty_hist_csr.old_preferred_flag := fnd_api.g_miss_char;
3661: l_pty_hist_csr.new_preferred_flag := l_temp_party_rec.preferred_flag;
3662: END IF;
3663:
3664: CSI_I_PARTIES_H_PKG.update_Row
3665: (
3666: p_INSTANCE_PARTY_HISTORY_ID => l_party_hist_id ,
3667: p_INSTANCE_PARTY_ID => FND_API.G_MISS_NUM ,
3668: p_TRANSACTION_ID => FND_API.G_MISS_NUM ,

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

3807: IF (p_party_rec.PREFERRED_FLAG = FND_API.G_MISS_CHAR) THEN
3808: l_temp_party_rec.PREFERRED_FLAG := l_curr_party_rec.PREFERRED_FLAG ;
3809: END IF;
3810:
3811: -- Call table handlers to insert into csi_i_parties_h table
3812: CSI_I_PARTIES_H_PKG.Insert_Row
3813: (
3814: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
3815: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,

Line 3812: CSI_I_PARTIES_H_PKG.Insert_Row

3808: l_temp_party_rec.PREFERRED_FLAG := l_curr_party_rec.PREFERRED_FLAG ;
3809: END IF;
3810:
3811: -- Call table handlers to insert into csi_i_parties_h table
3812: CSI_I_PARTIES_H_PKG.Insert_Row
3813: (
3814: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
3815: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,
3816: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

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

4124: l_party_hist_rec.old_preferred_flag := l_curr_party_rec.preferred_flag ;
4125: l_party_hist_rec.new_preferred_flag := p_party_rec.preferred_flag ;
4126: END IF;
4127:
4128: -- Call table handlers to insert into csi_i_parties_h table
4129: CSI_I_PARTIES_H_PKG.Insert_Row
4130: (
4131: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
4132: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,

Line 4129: CSI_I_PARTIES_H_PKG.Insert_Row

4125: l_party_hist_rec.new_preferred_flag := p_party_rec.preferred_flag ;
4126: END IF;
4127:
4128: -- Call table handlers to insert into csi_i_parties_h table
4129: CSI_I_PARTIES_H_PKG.Insert_Row
4130: (
4131: px_INSTANCE_PARTY_HISTORY_ID => l_inst_party_his_id ,
4132: p_INSTANCE_PARTY_ID => p_party_rec.INSTANCE_PARTY_ID ,
4133: p_TRANSACTION_ID => p_txn_rec.TRANSACTION_ID ,

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

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

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

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

Line 6935: from CSI_I_PARTIES_H

6931: l_new_party_id := null;
6932: Begin
6933: select old_party_id,new_party_id
6934: into l_old_party_id,l_new_party_id
6935: from CSI_I_PARTIES_H
6936: where instance_party_id = l_party_rec.instance_party_id
6937: and transaction_id = p_txn_rec.transaction_id;
6938: Exception
6939: when no_data_found then

Line 7939: FROM csi_i_parties_h ciph,

7935: ciph.OLD_PRIMARY_FLAG,
7936: ciph.NEW_PRIMARY_FLAG,
7937: cip.INSTANCE_ID,
7938: ciph.creation_date --Added for bug 2781480
7939: FROM csi_i_parties_h ciph,
7940: csi_i_parties cip
7941: WHERE ciph.transaction_id = i_transaction_id
7942: AND ciph.instance_party_id = cip.instance_party_id; -- Added by sk on 08-APR for fixing bug
7943: -- 2304649 .