APPS.POS_SUP_PROF_MRG_GRP dependencies on FND_REGISTRATION_DETAILS

Line 89: UPDATE fnd_registration_details

85: WHERE attribute_code = 'ICX_SUPPLIER_ORG_ID'
86: AND attribute_application_id = 177
87: AND number_value = p_old_vendor_id;
88:
89: UPDATE fnd_registration_details
90: SET field_value_string = (SELECT vendor_name FROM po_vendors WHERE vendor_id = p_new_vendor_id)
91: WHERE field_name = 'Supplier Name'
92: AND registration_id IN
93: (SELECT DISTINCT registration_id

Line 94: FROM fnd_registration_details WHERE field_name = 'Supplier Number'

90: SET field_value_string = (SELECT vendor_name FROM po_vendors WHERE vendor_id = p_new_vendor_id)
91: WHERE field_name = 'Supplier Name'
92: AND registration_id IN
93: (SELECT DISTINCT registration_id
94: FROM fnd_registration_details WHERE field_name = 'Supplier Number'
95: AND field_value_number = p_old_vendor_id
96: );
97:
98: UPDATE fnd_registration_details

Line 98: UPDATE fnd_registration_details

94: FROM fnd_registration_details WHERE field_name = 'Supplier Number'
95: AND field_value_number = p_old_vendor_id
96: );
97:
98: UPDATE fnd_registration_details
99: SET field_value_number = p_new_vendor_id
100: WHERE field_name = 'Supplier Number'
101: AND registration_id IN
102: (SELECT DISTINCT registration_id

Line 103: FROM fnd_registration_details WHERE field_name = 'Supplier Number'

99: SET field_value_number = p_new_vendor_id
100: WHERE field_name = 'Supplier Number'
101: AND registration_id IN
102: (SELECT DISTINCT registration_id
103: FROM fnd_registration_details WHERE field_name = 'Supplier Number'
104: AND field_value_number = p_old_vendor_id
105: );
106:
107: END IF;