DBA Data[Home] [Help]

APPS.POS_SUP_PROF_MRG_GRP dependencies on FND_GLOBAL

Line 137: last_updated_by = FND_GLOBAL.user_id,

133:
134: UPDATE pos_acct_addr_rel
135: SET 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 vendor_id = p_old_vendor_id;
140:
141:

Line 138: last_update_login = FND_GLOBAL.login_id

134: UPDATE pos_acct_addr_rel
135: SET 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 vendor_id = p_old_vendor_id;
140:
141:
142: UPDATE pos_supplier_mappings

Line 145: last_updated_by = FND_GLOBAL.user_id,

141:
142: UPDATE pos_supplier_mappings
143: SET vendor_id = p_new_vendor_id,
144: last_update_date = SYSDATE,
145: last_updated_by = FND_GLOBAL.user_id,
146: last_update_login = FND_GLOBAL.login_id
147: WHERE vendor_id = p_old_vendor_id;
148:
149: UPDATE pos_supplier_registrations

Line 146: last_update_login = FND_GLOBAL.login_id

142: UPDATE pos_supplier_mappings
143: SET vendor_id = p_new_vendor_id,
144: last_update_date = SYSDATE,
145: last_updated_by = FND_GLOBAL.user_id,
146: last_update_login = FND_GLOBAL.login_id
147: WHERE vendor_id = p_old_vendor_id;
148:
149: UPDATE pos_supplier_registrations
150: SET po_vendor_id = p_new_vendor_id,

Line 152: last_updated_by = FND_GLOBAL.user_id,

148:
149: UPDATE pos_supplier_registrations
150: SET po_vendor_id = p_new_vendor_id,
151: last_update_date = SYSDATE,
152: last_updated_by = FND_GLOBAL.user_id,
153: last_update_login = FND_GLOBAL.login_id
154: WHERE po_vendor_id = p_old_vendor_id;
155:
156: UPDATE pos_sup_bank_account_requests

Line 153: last_update_login = FND_GLOBAL.login_id

149: UPDATE pos_supplier_registrations
150: SET po_vendor_id = p_new_vendor_id,
151: last_update_date = SYSDATE,
152: last_updated_by = FND_GLOBAL.user_id,
153: last_update_login = FND_GLOBAL.login_id
154: WHERE po_vendor_id = p_old_vendor_id;
155:
156: UPDATE pos_sup_bank_account_requests
157: SET vendor_id = p_new_vendor_id,

Line 159: last_updated_by = FND_GLOBAL.user_id,

155:
156: UPDATE pos_sup_bank_account_requests
157: SET vendor_id = p_new_vendor_id,
158: last_update_date = SYSDATE,
159: last_updated_by = FND_GLOBAL.user_id,
160: last_update_login = FND_GLOBAL.login_id
161: WHERE vendor_id = p_old_vendor_id;
162: */
163:

Line 160: last_update_login = FND_GLOBAL.login_id

156: UPDATE pos_sup_bank_account_requests
157: SET vendor_id = p_new_vendor_id,
158: last_update_date = SYSDATE,
159: last_updated_by = FND_GLOBAL.user_id,
160: last_update_login = FND_GLOBAL.login_id
161: WHERE vendor_id = p_old_vendor_id;
162: */
163:
164: -- If it is the last site then merge supplier profile info

Line 199: last_updated_by = FND_GLOBAL.user_id,

195: -- transfer classifications of the merged-from vendor to the merged-to vendor
196: UPDATE pos_sup_products_services
197: SET vendor_id = p_new_vendor_id,
198: last_update_date = SYSDATE,
199: last_updated_by = FND_GLOBAL.user_id,
200: last_update_login = FND_GLOBAL.login_id
201: WHERE vendor_id = p_old_vendor_id;
202: END IF;
203:

Line 200: last_update_login = FND_GLOBAL.login_id

196: UPDATE pos_sup_products_services
197: SET vendor_id = p_new_vendor_id,
198: last_update_date = SYSDATE,
199: last_updated_by = FND_GLOBAL.user_id,
200: last_update_login = FND_GLOBAL.login_id
201: WHERE vendor_id = p_old_vendor_id;
202: END IF;
203:
204: ELSE