APPS.POS_SUP_PROF_MRG_GRP dependencies on FND_GLOBAL

Line 122: last_updated_by = FND_GLOBAL.user_id,

118:
119: UPDATE pos_acct_addr_rel
120: SET vendor_id = p_new_vendor_id,
121: last_update_date = SYSDATE,
122: last_updated_by = FND_GLOBAL.user_id,
123: last_update_login = FND_GLOBAL.login_id
124: WHERE vendor_id = p_old_vendor_id;
125:
126:

Line 123: last_update_login = FND_GLOBAL.login_id

119: UPDATE pos_acct_addr_rel
120: SET vendor_id = p_new_vendor_id,
121: last_update_date = SYSDATE,
122: last_updated_by = FND_GLOBAL.user_id,
123: last_update_login = FND_GLOBAL.login_id
124: WHERE vendor_id = p_old_vendor_id;
125:
126:
127: UPDATE pos_supplier_mappings

Line 130: last_updated_by = FND_GLOBAL.user_id,

126:
127: UPDATE pos_supplier_mappings
128: SET vendor_id = p_new_vendor_id,
129: last_update_date = SYSDATE,
130: last_updated_by = FND_GLOBAL.user_id,
131: last_update_login = FND_GLOBAL.login_id
132: WHERE vendor_id = p_old_vendor_id;
133:
134: UPDATE pos_supplier_registrations

Line 131: last_update_login = FND_GLOBAL.login_id

127: UPDATE pos_supplier_mappings
128: SET vendor_id = p_new_vendor_id,
129: last_update_date = SYSDATE,
130: last_updated_by = FND_GLOBAL.user_id,
131: last_update_login = FND_GLOBAL.login_id
132: WHERE vendor_id = p_old_vendor_id;
133:
134: UPDATE pos_supplier_registrations
135: SET po_vendor_id = p_new_vendor_id,

Line 137: last_updated_by = FND_GLOBAL.user_id,

133:
134: UPDATE pos_supplier_registrations
135: SET po_vendor_id = p_new_vendor_id,
136: last_update_date = SYSDATE,
137: last_updated_by = FND_GLOBAL.user_id,
138: last_update_login = FND_GLOBAL.login_id
139: WHERE po_vendor_id = p_old_vendor_id;
140:
141: UPDATE pos_sup_bank_account_requests

Line 138: last_update_login = FND_GLOBAL.login_id

134: UPDATE pos_supplier_registrations
135: SET po_vendor_id = p_new_vendor_id,
136: last_update_date = SYSDATE,
137: last_updated_by = FND_GLOBAL.user_id,
138: last_update_login = FND_GLOBAL.login_id
139: WHERE po_vendor_id = p_old_vendor_id;
140:
141: UPDATE pos_sup_bank_account_requests
142: SET vendor_id = p_new_vendor_id,

Line 144: last_updated_by = FND_GLOBAL.user_id,

140:
141: UPDATE pos_sup_bank_account_requests
142: SET vendor_id = p_new_vendor_id,
143: last_update_date = SYSDATE,
144: last_updated_by = FND_GLOBAL.user_id,
145: last_update_login = FND_GLOBAL.login_id
146: WHERE vendor_id = p_old_vendor_id;
147: */
148:

Line 145: last_update_login = FND_GLOBAL.login_id

141: UPDATE pos_sup_bank_account_requests
142: SET vendor_id = p_new_vendor_id,
143: last_update_date = SYSDATE,
144: last_updated_by = FND_GLOBAL.user_id,
145: last_update_login = FND_GLOBAL.login_id
146: WHERE vendor_id = p_old_vendor_id;
147: */
148:
149: -- If it is the last site then merge supplier profile info

Line 184: last_updated_by = FND_GLOBAL.user_id,

180: -- transfer classifications of the merged-from vendor to the merged-to vendor
181: UPDATE pos_sup_products_services
182: SET vendor_id = p_new_vendor_id,
183: last_update_date = SYSDATE,
184: last_updated_by = FND_GLOBAL.user_id,
185: last_update_login = FND_GLOBAL.login_id
186: WHERE vendor_id = p_old_vendor_id;
187: END IF;
188:

Line 185: last_update_login = FND_GLOBAL.login_id

181: UPDATE pos_sup_products_services
182: SET vendor_id = p_new_vendor_id,
183: last_update_date = SYSDATE,
184: last_updated_by = FND_GLOBAL.user_id,
185: last_update_login = FND_GLOBAL.login_id
186: WHERE vendor_id = p_old_vendor_id;
187: END IF;
188:
189: ELSE