APPS.OKL_VENDORMERGE_GRP dependencies on OKC_K_PARTY_ROLES_B

Line 70: , OKC_K_PARTY_ROLES_B CPRS

66: IS
67: SELECT CHR.CONTRACT_NUMBER
68: , CHR.ID
69: FROM OKC_K_HEADERS_ALL_B CHR
70: , OKC_K_PARTY_ROLES_B CPRS
71: , OKC_K_PARTY_ROLES_B CPRD
72: WHERE CPRS.CHR_ID = CHR.ID
73: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID
74: AND CPRS.OBJECT1_ID1 <> CPRD.OBJECT1_ID1

Line 71: , OKC_K_PARTY_ROLES_B CPRD

67: SELECT CHR.CONTRACT_NUMBER
68: , CHR.ID
69: FROM OKC_K_HEADERS_ALL_B CHR
70: , OKC_K_PARTY_ROLES_B CPRS
71: , OKC_K_PARTY_ROLES_B CPRD
72: WHERE CPRS.CHR_ID = CHR.ID
73: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID
74: AND CPRS.OBJECT1_ID1 <> CPRD.OBJECT1_ID1
75: AND CPRS.OBJECT1_ID1 = p_src_vendor_id

Line 95: , OKC_K_PARTY_ROLES_B CPRS

91: SELECT CHR.CONTRACT_NUMBER
92: , CHR.ID
93: , CPRD.CLE_ID
94: FROM OKC_K_HEADERS_ALL_B CHR
95: , OKC_K_PARTY_ROLES_B CPRS
96: , OKC_K_PARTY_ROLES_B CPRD
97: WHERE CPRS.DNZ_CHR_ID = CHR.ID
98: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID
99: AND CPRS.OBJECT1_ID1 <> CPRD.OBJECT1_ID1

Line 96: , OKC_K_PARTY_ROLES_B CPRD

92: , CHR.ID
93: , CPRD.CLE_ID
94: FROM OKC_K_HEADERS_ALL_B CHR
95: , OKC_K_PARTY_ROLES_B CPRS
96: , OKC_K_PARTY_ROLES_B CPRD
97: WHERE CPRS.DNZ_CHR_ID = CHR.ID
98: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID
99: AND CPRS.OBJECT1_ID1 <> CPRD.OBJECT1_ID1
100: AND CPRS.OBJECT1_ID1 = p_src_vendor_id

Line 119: FROM OKC_K_PARTY_ROLES_B CPRS

115: CURSOR party_role_dtls_csr (p_src_vendor_id NUMBER, p_des_vendor_id NUMBER, p_chr_id NUMBER)
116: IS
117: SELECT CPRS.ID CPRS_CPL_ID
118: , CPRD.ID CPRD_CPL_ID
119: FROM OKC_K_PARTY_ROLES_B CPRS
120: , OKC_K_PARTY_ROLES_B CPRD
121: WHERE CPRS.DNZ_CHR_ID = p_chr_id
122: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID
123: AND CPRS.OBJECT1_ID1 <> CPRD.OBJECT1_ID1

Line 120: , OKC_K_PARTY_ROLES_B CPRD

116: IS
117: SELECT CPRS.ID CPRS_CPL_ID
118: , CPRD.ID CPRD_CPL_ID
119: FROM OKC_K_PARTY_ROLES_B CPRS
120: , OKC_K_PARTY_ROLES_B CPRD
121: WHERE CPRS.DNZ_CHR_ID = p_chr_id
122: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID
123: AND CPRS.OBJECT1_ID1 <> CPRD.OBJECT1_ID1
124: AND CPRS.OBJECT1_ID1 = p_src_vendor_id

Line 140: FROM OKC_K_PARTY_ROLES_B CPRS

136: CURSOR party_role_dtls_ln_csr (p_src_vendor_id NUMBER, p_des_vendor_id NUMBER, p_chr_id NUMBER, p_cle_id NUMBER)
137: IS
138: SELECT CPRS.ID CPRS_CPL_ID
139: , CPRD.ID CPRD_CPL_ID
140: FROM OKC_K_PARTY_ROLES_B CPRS
141: , OKC_K_PARTY_ROLES_B CPRD
142: WHERE CPRS.DNZ_CHR_ID = p_chr_id
143: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID
144: AND CPRS.OBJECT1_ID1 <> CPRD.OBJECT1_ID1

Line 141: , OKC_K_PARTY_ROLES_B CPRD

137: IS
138: SELECT CPRS.ID CPRS_CPL_ID
139: , CPRD.ID CPRD_CPL_ID
140: FROM OKC_K_PARTY_ROLES_B CPRS
141: , OKC_K_PARTY_ROLES_B CPRD
142: WHERE CPRS.DNZ_CHR_ID = p_chr_id
143: AND CPRS.DNZ_CHR_ID = CPRD.DNZ_CHR_ID
144: AND CPRS.OBJECT1_ID1 <> CPRD.OBJECT1_ID1
145: AND CPRS.OBJECT1_ID1 = p_src_vendor_id

Line 744: --Update OKC_K_PARTY_ROLES_B for references of Vendor

740: LAST_UPDATE_LOGIN = l_last_update_login
741: WHERE VENDOR_ID = p_dup_vendor_id
742: AND PAY_SITE_ID = p_dup_vendor_site_id;
743:
744: --Update OKC_K_PARTY_ROLES_B for references of Vendor
745: --This will take care of the cases where only source vendor and not the destination
746: --vendor is added to the contract. Both the vendor added to contract case is
747: --handled separately above.
748: UPDATE OKC_K_PARTY_ROLES_B CPR

Line 748: UPDATE OKC_K_PARTY_ROLES_B CPR

744: --Update OKC_K_PARTY_ROLES_B for references of Vendor
745: --This will take care of the cases where only source vendor and not the destination
746: --vendor is added to the contract. Both the vendor added to contract case is
747: --handled separately above.
748: UPDATE OKC_K_PARTY_ROLES_B CPR
749: SET OBJECT1_ID1 = TO_CHAR(p_vendor_id),
750: LAST_UPDATED_BY = l_last_updated_by,
751: LAST_UPDATE_DATE = l_last_update_date,
752: LAST_UPDATE_LOGIN = l_last_update_login