DBA Data[Home] [Help]

APPS.WIP_BOMROUTINGUTIL_PVT dependencies on FND_GLOBAL

Line 176: fnd_global.user_id,

172: bos.operation_seq_num,
173: p_orgID,
174: p_repSchedID,
175: sysdate,
176: fnd_global.user_id,
177: sysdate,
178: fnd_global.user_id,
179: fnd_global.login_id,
180: fnd_global.conc_request_id,

Line 178: fnd_global.user_id,

174: p_repSchedID,
175: sysdate,
176: fnd_global.user_id,
177: sysdate,
178: fnd_global.user_id,
179: fnd_global.login_id,
180: fnd_global.conc_request_id,
181: fnd_global.prog_appl_id,
182: fnd_global.conc_program_id,

Line 179: fnd_global.login_id,

175: sysdate,
176: fnd_global.user_id,
177: sysdate,
178: fnd_global.user_id,
179: fnd_global.login_id,
180: fnd_global.conc_request_id,
181: fnd_global.prog_appl_id,
182: fnd_global.conc_program_id,
183: sysdate,

Line 180: fnd_global.conc_request_id,

176: fnd_global.user_id,
177: sysdate,
178: fnd_global.user_id,
179: fnd_global.login_id,
180: fnd_global.conc_request_id,
181: fnd_global.prog_appl_id,
182: fnd_global.conc_program_id,
183: sysdate,
184: min(bos.operation_sequence_id),

Line 181: fnd_global.prog_appl_id,

177: sysdate,
178: fnd_global.user_id,
179: fnd_global.login_id,
180: fnd_global.conc_request_id,
181: fnd_global.prog_appl_id,
182: fnd_global.conc_program_id,
183: sysdate,
184: min(bos.operation_sequence_id),
185: bos.department_id,

Line 182: fnd_global.conc_program_id,

178: fnd_global.user_id,
179: fnd_global.login_id,
180: fnd_global.conc_request_id,
181: fnd_global.prog_appl_id,
182: fnd_global.conc_program_id,
183: sysdate,
184: min(bos.operation_sequence_id),
185: bos.department_id,
186: round(p_qty, 6),

Line 242: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,

238: (eng.status_type in (1, 4, 7) and l_excludeECO = 2)))
239: and bos2.acd_type = 3)
240: group by bos.operation_seq_num,
241: bos.department_id, bos.count_point_type, bos.backflush_flag, bos.minimum_transfer_quantity,
242: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,
243: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,
244: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,
245: bos.long_description, bos.attribute_category, bos.attribute1, bos.attribute2,
246: bos.attribute3, bos.attribute4, bos.attribute5, bos.attribute6, bos.attribute7, bos.attribute8,

Line 243: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,

239: and bos2.acd_type = 3)
240: group by bos.operation_seq_num,
241: bos.department_id, bos.count_point_type, bos.backflush_flag, bos.minimum_transfer_quantity,
242: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,
243: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,
244: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,
245: bos.long_description, bos.attribute_category, bos.attribute1, bos.attribute2,
246: bos.attribute3, bos.attribute4, bos.attribute5, bos.attribute6, bos.attribute7, bos.attribute8,
247: bos.attribute9, bos.attribute10, bos.attribute11, bos.attribute12, bos.attribute13,

Line 244: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,

240: group by bos.operation_seq_num,
241: bos.department_id, bos.count_point_type, bos.backflush_flag, bos.minimum_transfer_quantity,
242: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,
243: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,
244: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,
245: bos.long_description, bos.attribute_category, bos.attribute1, bos.attribute2,
246: bos.attribute3, bos.attribute4, bos.attribute5, bos.attribute6, bos.attribute7, bos.attribute8,
247: bos.attribute9, bos.attribute10, bos.attribute11, bos.attribute12, bos.attribute13,
248: bos.attribute14, bos.attribute15, bos.check_skill;

Line 325: fnd_global.user_id,

321: bor.resource_seq_num,
322: p_orgID,
323: p_repSchedID,
324: sysdate,
325: fnd_global.user_id,
326: sysdate,
327: fnd_global.user_id,
328: fnd_global.login_id,
329: fnd_global.conc_request_id,

Line 327: fnd_global.user_id,

323: p_repSchedID,
324: sysdate,
325: fnd_global.user_id,
326: sysdate,
327: fnd_global.user_id,
328: fnd_global.login_id,
329: fnd_global.conc_request_id,
330: fnd_global.prog_appl_id,
331: fnd_global.conc_program_id,

Line 328: fnd_global.login_id,

324: sysdate,
325: fnd_global.user_id,
326: sysdate,
327: fnd_global.user_id,
328: fnd_global.login_id,
329: fnd_global.conc_request_id,
330: fnd_global.prog_appl_id,
331: fnd_global.conc_program_id,
332: sysdate,

Line 329: fnd_global.conc_request_id,

325: fnd_global.user_id,
326: sysdate,
327: fnd_global.user_id,
328: fnd_global.login_id,
329: fnd_global.conc_request_id,
330: fnd_global.prog_appl_id,
331: fnd_global.conc_program_id,
332: sysdate,
333: bor.resource_id,

Line 330: fnd_global.prog_appl_id,

326: sysdate,
327: fnd_global.user_id,
328: fnd_global.login_id,
329: fnd_global.conc_request_id,
330: fnd_global.prog_appl_id,
331: fnd_global.conc_program_id,
332: sysdate,
333: bor.resource_id,
334: br.unit_of_measure,

Line 331: fnd_global.conc_program_id,

327: fnd_global.user_id,
328: fnd_global.login_id,
329: fnd_global.conc_request_id,
330: fnd_global.prog_appl_id,
331: fnd_global.conc_program_id,
332: sysdate,
333: bor.resource_id,
334: br.unit_of_measure,
335: bor.basis_type,

Line 523: x_created_by => fnd_global.user_id,

519: x_to_entity_name => 'WIP_DISCRETE_OPERATIONS',
520: x_to_pk1_value => to_char(p_wipEntityID),
521: x_to_pk2_value => to_char(op_attach.operation_seq_num),
522: x_to_pk3_value => to_char(p_orgID),
523: x_created_by => fnd_global.user_id,
524: x_last_update_login => fnd_global.login_id,
525: x_program_application_id => fnd_global.prog_appl_id,
526: x_program_id => fnd_global.conc_program_id,
527: x_request_id => fnd_global.conc_request_id);

Line 524: x_last_update_login => fnd_global.login_id,

520: x_to_pk1_value => to_char(p_wipEntityID),
521: x_to_pk2_value => to_char(op_attach.operation_seq_num),
522: x_to_pk3_value => to_char(p_orgID),
523: x_created_by => fnd_global.user_id,
524: x_last_update_login => fnd_global.login_id,
525: x_program_application_id => fnd_global.prog_appl_id,
526: x_program_id => fnd_global.conc_program_id,
527: x_request_id => fnd_global.conc_request_id);
528: END LOOP;

Line 525: x_program_application_id => fnd_global.prog_appl_id,

521: x_to_pk2_value => to_char(op_attach.operation_seq_num),
522: x_to_pk3_value => to_char(p_orgID),
523: x_created_by => fnd_global.user_id,
524: x_last_update_login => fnd_global.login_id,
525: x_program_application_id => fnd_global.prog_appl_id,
526: x_program_id => fnd_global.conc_program_id,
527: x_request_id => fnd_global.conc_request_id);
528: END LOOP;
529:

Line 526: x_program_id => fnd_global.conc_program_id,

522: x_to_pk3_value => to_char(p_orgID),
523: x_created_by => fnd_global.user_id,
524: x_last_update_login => fnd_global.login_id,
525: x_program_application_id => fnd_global.prog_appl_id,
526: x_program_id => fnd_global.conc_program_id,
527: x_request_id => fnd_global.conc_request_id);
528: END LOOP;
529:
530: /* Added for 12.1.1 Skills Validation project.*/

Line 527: x_request_id => fnd_global.conc_request_id);

523: x_created_by => fnd_global.user_id,
524: x_last_update_login => fnd_global.login_id,
525: x_program_application_id => fnd_global.prog_appl_id,
526: x_program_id => fnd_global.conc_program_id,
527: x_request_id => fnd_global.conc_request_id);
528: END LOOP;
529:
530: /* Added for 12.1.1 Skills Validation project.*/
531: if ( l_logLevel <= wip_constants.full_logging ) then

Line 873: fnd_global.user_id,

869: decode(l_compTbl(l_count).wip_supply_type,
870: wip_constants.phantom, -1*l_opSeq, l_opSeq),
871: null,
872: sysdate,
873: fnd_global.user_id,
874: sysdate,
875: fnd_global.user_id,
876: fnd_global.login_id,
877: fnd_global.conc_request_id,

Line 875: fnd_global.user_id,

871: null,
872: sysdate,
873: fnd_global.user_id,
874: sysdate,
875: fnd_global.user_id,
876: fnd_global.login_id,
877: fnd_global.conc_request_id,
878: fnd_global.prog_appl_id,
879: fnd_global.conc_program_id,

Line 876: fnd_global.login_id,

872: sysdate,
873: fnd_global.user_id,
874: sysdate,
875: fnd_global.user_id,
876: fnd_global.login_id,
877: fnd_global.conc_request_id,
878: fnd_global.prog_appl_id,
879: fnd_global.conc_program_id,
880: sysdate,

Line 877: fnd_global.conc_request_id,

873: fnd_global.user_id,
874: sysdate,
875: fnd_global.user_id,
876: fnd_global.login_id,
877: fnd_global.conc_request_id,
878: fnd_global.prog_appl_id,
879: fnd_global.conc_program_id,
880: sysdate,
881: l_compTbl(l_count).component_sequence_id,

Line 878: fnd_global.prog_appl_id,

874: sysdate,
875: fnd_global.user_id,
876: fnd_global.login_id,
877: fnd_global.conc_request_id,
878: fnd_global.prog_appl_id,
879: fnd_global.conc_program_id,
880: sysdate,
881: l_compTbl(l_count).component_sequence_id,
882: l_compTbl(l_count).wip_supply_type,

Line 879: fnd_global.conc_program_id,

875: fnd_global.user_id,
876: fnd_global.login_id,
877: fnd_global.conc_request_id,
878: fnd_global.prog_appl_id,
879: fnd_global.conc_program_id,
880: sysdate,
881: l_compTbl(l_count).component_sequence_id,
882: l_compTbl(l_count).wip_supply_type,
883: p_jobStartDate,