DBA Data[Home] [Help]

APPS.OKE_PA_MDS_RELIEF_PKG dependencies on FND_GLOBAL

Line 164: last_updated_by = fnd_global.user_id,

160:
161: update mrp_schedule_dates
162: set schedule_quantity = l_qty,
163: last_update_date = sysdate,
164: last_updated_by = fnd_global.user_id,
165: request_id = fnd_global.conc_request_id,
166: program_application_id = fnd_global.prog_appl_id,
167: program_id = fnd_global.conc_program_id,
168: program_update_date = sysdate,

Line 165: request_id = fnd_global.conc_request_id,

161: update mrp_schedule_dates
162: set schedule_quantity = l_qty,
163: last_update_date = sysdate,
164: last_updated_by = fnd_global.user_id,
165: request_id = fnd_global.conc_request_id,
166: program_application_id = fnd_global.prog_appl_id,
167: program_id = fnd_global.conc_program_id,
168: program_update_date = sysdate,
169: old_transaction_id = l_mds_tbl(i).mtl_transaction_id

Line 166: program_application_id = fnd_global.prog_appl_id,

162: set schedule_quantity = l_qty,
163: last_update_date = sysdate,
164: last_updated_by = fnd_global.user_id,
165: request_id = fnd_global.conc_request_id,
166: program_application_id = fnd_global.prog_appl_id,
167: program_id = fnd_global.conc_program_id,
168: program_update_date = sysdate,
169: old_transaction_id = l_mds_tbl(i).mtl_transaction_id
170: where mps_transaction_id = l_mds_tbl(i).mps_transaction_id

Line 167: program_id = fnd_global.conc_program_id,

163: last_update_date = sysdate,
164: last_updated_by = fnd_global.user_id,
165: request_id = fnd_global.conc_request_id,
166: program_application_id = fnd_global.prog_appl_id,
167: program_id = fnd_global.conc_program_id,
168: program_update_date = sysdate,
169: old_transaction_id = l_mds_tbl(i).mtl_transaction_id
170: where mps_transaction_id = l_mds_tbl(i).mps_transaction_id
171: and schedule_level = 2;

Line 202: fnd_global.user_id,

198: 3, -- R_WORK_ORDER 1, R_PURCH_ORDER 2, R_SALES_ORDER 3
199: null, -- l_mds_tbl(i).mtl_transaction_id,
200: null, -- No order line_num
201: SYSDATE,
202: fnd_global.user_id,
203: SYSDATE,
204: fnd_global.user_id,
205: fnd_global.login_id,
206: fnd_global.conc_request_id,

Line 204: fnd_global.user_id,

200: null, -- No order line_num
201: SYSDATE,
202: fnd_global.user_id,
203: SYSDATE,
204: fnd_global.user_id,
205: fnd_global.login_id,
206: fnd_global.conc_request_id,
207: fnd_global.prog_appl_id,
208: fnd_global.conc_program_id,

Line 205: fnd_global.login_id,

201: SYSDATE,
202: fnd_global.user_id,
203: SYSDATE,
204: fnd_global.user_id,
205: fnd_global.login_id,
206: fnd_global.conc_request_id,
207: fnd_global.prog_appl_id,
208: fnd_global.conc_program_id,
209: SYSDATE,

Line 206: fnd_global.conc_request_id,

202: fnd_global.user_id,
203: SYSDATE,
204: fnd_global.user_id,
205: fnd_global.login_id,
206: fnd_global.conc_request_id,
207: fnd_global.prog_appl_id,
208: fnd_global.conc_program_id,
209: SYSDATE,
210: l_mds_tbl(i).transaction_date,

Line 207: fnd_global.prog_appl_id,

203: SYSDATE,
204: fnd_global.user_id,
205: fnd_global.login_id,
206: fnd_global.conc_request_id,
207: fnd_global.prog_appl_id,
208: fnd_global.conc_program_id,
209: SYSDATE,
210: l_mds_tbl(i).transaction_date,
211: l_mds_tbl(i).order_quantity,

Line 208: fnd_global.conc_program_id,

204: fnd_global.user_id,
205: fnd_global.login_id,
206: fnd_global.conc_request_id,
207: fnd_global.prog_appl_id,
208: fnd_global.conc_program_id,
209: SYSDATE,
210: l_mds_tbl(i).transaction_date,
211: l_mds_tbl(i).order_quantity,
212: l_mds_tbl(i).primary_quantity * -1,