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.OKL_PARTY_MERGE_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 2872: -- Description : Updating the table: OKC_K_PARTY_ROLES_B for column: OBJECT1_ID1

2868:
2869: ----------------------------------------------------------------------------------------------------------
2870: -- Start of comments
2871: -- Procedure Name : CPL_PARTY_MERGE
2872: -- Description : Updating the table: OKC_K_PARTY_ROLES_B for column: OBJECT1_ID1
2873: -- Business Rules : performing PARTY MERGE for table: OKC_K_PARTY_ROLES_B and col: OBJECT1_ID1
2874: -- for the records created for Lease Management
2875: -- Parameters :
2876: -- Version : 1.0

Line 2873: -- Business Rules : performing PARTY MERGE for table: OKC_K_PARTY_ROLES_B and col: OBJECT1_ID1

2869: ----------------------------------------------------------------------------------------------------------
2870: -- Start of comments
2871: -- Procedure Name : CPL_PARTY_MERGE
2872: -- Description : Updating the table: OKC_K_PARTY_ROLES_B for column: OBJECT1_ID1
2873: -- Business Rules : performing PARTY MERGE for table: OKC_K_PARTY_ROLES_B and col: OBJECT1_ID1
2874: -- for the records created for Lease Management
2875: -- Parameters :
2876: -- Version : 1.0
2877: -- End of comments

Line 2926: , OKC_K_PARTY_ROLES_B CPRS

2922: , CPRD.ID CPRD_CPL_ID
2923: , CPRS.OBJECT1_ID1 CPRS_OBJECT1_ID1
2924: , CPRD.OBJECT1_ID1 CPRD_OBJECT1_ID1
2925: FROM OKC_K_HEADERS_ALL_B CHR
2926: , OKC_K_PARTY_ROLES_B CPRS
2927: , OKC_K_PARTY_ROLES_B CPRD
2928: , OKC_SUBCLASSES_V SC
2929: , FND_LOOKUPS RLE
2930: WHERE CPRS.CHR_ID = CHR.ID

Line 2927: , OKC_K_PARTY_ROLES_B CPRD

2923: , CPRS.OBJECT1_ID1 CPRS_OBJECT1_ID1
2924: , CPRD.OBJECT1_ID1 CPRD_OBJECT1_ID1
2925: FROM OKC_K_HEADERS_ALL_B CHR
2926: , OKC_K_PARTY_ROLES_B CPRS
2927: , OKC_K_PARTY_ROLES_B CPRD
2928: , OKC_SUBCLASSES_V SC
2929: , FND_LOOKUPS RLE
2930: WHERE CPRS.CHR_ID = CHR.ID
2931: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID

Line 2960: , OKC_K_PARTY_ROLES_B CPRS

2956: , CPRD.ID CPRD_CPL_ID
2957: , CPRS.OBJECT1_ID1 CPRS_OBJECT1_ID1
2958: , CPRD.OBJECT1_ID1 CPRD_OBJECT1_ID1
2959: FROM OKC_K_HEADERS_ALL_B CHR
2960: , OKC_K_PARTY_ROLES_B CPRS
2961: , OKC_K_PARTY_ROLES_B CPRD
2962: , OKC_SUBCLASSES_V SC
2963: , FND_LOOKUPS RLE
2964: WHERE CPRS.DNZ_CHR_ID = CHR.ID

Line 2961: , OKC_K_PARTY_ROLES_B CPRD

2957: , CPRS.OBJECT1_ID1 CPRS_OBJECT1_ID1
2958: , CPRD.OBJECT1_ID1 CPRD_OBJECT1_ID1
2959: FROM OKC_K_HEADERS_ALL_B CHR
2960: , OKC_K_PARTY_ROLES_B CPRS
2961: , OKC_K_PARTY_ROLES_B CPRD
2962: , OKC_SUBCLASSES_V SC
2963: , FND_LOOKUPS RLE
2964: WHERE CPRS.DNZ_CHR_ID = CHR.ID
2965: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID

Line 3052: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);

3048: -- not transfer and return the id of the duplicate record as the Merged To Id
3049: if p_from_fk_id <> p_to_fk_id
3050: then
3051: arp_message.set_name('AR','AR_UPDATING_TABLE');
3052: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
3053:
3054: IF p_parent_entity_name = 'HZ_PARTIES'
3055: THEN
3056: --Check if the parties to be merged are part of same type of contract

Line 3213: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));

3209: WHEN OKL_API.G_EXCEPTION_ERROR
3210: THEN
3211: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3212: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3213: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3214: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3215: IF chk_vendor_chr_csr%ISOPEN
3216: THEN
3217: CLOSE chk_vendor_chr_csr;

Line 3238: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));

3234: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
3235: THEN
3236: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3237: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3238: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3239: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3240: IF chk_vendor_chr_csr%ISOPEN
3241: THEN
3242: CLOSE chk_vendor_chr_csr;

Line 3263: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));

3259: WHEN OTHERS
3260: THEN
3261: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3262: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3263: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3264: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3265: IF chk_vendor_chr_csr%ISOPEN
3266: THEN
3267: CLOSE chk_vendor_chr_csr;

Line 3289: -- Description : Updating the table: OKC_K_PARTY_ROLES_B for column: OBJECT1_ID1

3285:
3286: ----------------------------------------------------------------------------------------------------------
3287: -- Start of comments
3288: -- Procedure Name : CPL_PARTY_SITE_MERGE
3289: -- Description : Updating the table: OKC_K_PARTY_ROLES_B for column: OBJECT1_ID1
3290: -- Business Rules : performing PARTY MERGE for table: OKC_K_PARTY_ROLES_B and col: OBJECT1_ID1
3291: -- for the records created by Lease Management for Party Site
3292: -- Parameters :
3293: -- Version : 1.0

Line 3290: -- Business Rules : performing PARTY MERGE for table: OKC_K_PARTY_ROLES_B and col: OBJECT1_ID1

3286: ----------------------------------------------------------------------------------------------------------
3287: -- Start of comments
3288: -- Procedure Name : CPL_PARTY_SITE_MERGE
3289: -- Description : Updating the table: OKC_K_PARTY_ROLES_B for column: OBJECT1_ID1
3290: -- Business Rules : performing PARTY MERGE for table: OKC_K_PARTY_ROLES_B and col: OBJECT1_ID1
3291: -- for the records created by Lease Management for Party Site
3292: -- Parameters :
3293: -- Version : 1.0
3294: -- End of comments

Line 3356: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);

3352: if p_from_fk_id <> p_to_fk_id
3353: then
3354: begin
3355: arp_message.set_name('AR','AR_UPDATING_TABLE');
3356: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
3357:
3358: IF p_parent_entity_name = 'HZ_PARTY_SITES'
3359: THEN
3360: --updating the OKC_K_PARTY_ROLES_B table for column references OBJECT1_ID1

Line 3360: --updating the OKC_K_PARTY_ROLES_B table for column references OBJECT1_ID1

3356: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
3357:
3358: IF p_parent_entity_name = 'HZ_PARTY_SITES'
3359: THEN
3360: --updating the OKC_K_PARTY_ROLES_B table for column references OBJECT1_ID1
3361: --and JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
3362: UPDATE OKC_K_PARTY_ROLES_B TAB
3363: SET TAB.OBJECT1_ID1 = p_to_fk_id
3364: , TAB.object_version_number = TAB.object_version_number + 1

Line 3362: UPDATE OKC_K_PARTY_ROLES_B TAB

3358: IF p_parent_entity_name = 'HZ_PARTY_SITES'
3359: THEN
3360: --updating the OKC_K_PARTY_ROLES_B table for column references OBJECT1_ID1
3361: --and JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
3362: UPDATE OKC_K_PARTY_ROLES_B TAB
3363: SET TAB.OBJECT1_ID1 = p_to_fk_id
3364: , TAB.object_version_number = TAB.object_version_number + 1
3365: , TAB.last_update_date = SYSDATE
3366: , TAB.last_updated_by = arp_standard.profile.user_id

Line 3380: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));

3376: when others
3377: then
3378: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3379: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3380: 'OKC_K_PARTY_ROLES_B for = '|| p_from_id));
3381: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3382: x_return_status := FND_API.G_RET_STS_ERROR;
3383: END;
3384: END IF;

Line 6265: TYPE CUST_ACCT_ID_LIST_TYPE IS TABLE OF OKC_K_PARTY_ROLES_B.CUST_ACCT_ID%TYPE

6261: TYPE ID_LIST_TYPE IS TABLE OF OKC_RULES_B.ID%TYPE
6262: INDEX BY BINARY_INTEGER;
6263: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
6264:
6265: TYPE CUST_ACCT_ID_LIST_TYPE IS TABLE OF OKC_K_PARTY_ROLES_B.CUST_ACCT_ID%TYPE
6266: INDEX BY BINARY_INTEGER;
6267: NUM_COL1_ORIG_LIST CUST_ACCT_ID_LIST_TYPE;
6268: NUM_COL1_NEW_LIST CUST_ACCT_ID_LIST_TYPE;
6269:

Line 6285: , OKC_K_PARTY_ROLES_B yt

6281: , rul.object1_id1
6282: FROM OKC_RULES_B rul
6283: , OKC_RG_PARTY_ROLES rgpr
6284: , OKC_RULE_GROUPS_B rgp
6285: , OKC_K_PARTY_ROLES_B yt
6286: , RA_CUSTOMER_MERGES m
6287: WHERE yt.cust_acct_id = m.duplicate_id
6288: AND rgpr.cpl_id = yt.id
6289: AND rgp.id = rgpr.rgp_id