DBA Data[Home] [Help]

APPS.WIP_BOMROUTINGUTIL_PVT dependencies on FND_GLOBAL

Line 152: fnd_global.user_id,

148: bos.operation_seq_num,
149: p_orgID,
150: p_repSchedID,
151: sysdate,
152: fnd_global.user_id,
153: sysdate,
154: fnd_global.user_id,
155: fnd_global.login_id,
156: fnd_global.conc_request_id,

Line 154: fnd_global.user_id,

150: p_repSchedID,
151: sysdate,
152: fnd_global.user_id,
153: sysdate,
154: fnd_global.user_id,
155: fnd_global.login_id,
156: fnd_global.conc_request_id,
157: fnd_global.prog_appl_id,
158: fnd_global.conc_program_id,

Line 155: fnd_global.login_id,

151: sysdate,
152: fnd_global.user_id,
153: sysdate,
154: fnd_global.user_id,
155: fnd_global.login_id,
156: fnd_global.conc_request_id,
157: fnd_global.prog_appl_id,
158: fnd_global.conc_program_id,
159: sysdate,

Line 156: fnd_global.conc_request_id,

152: fnd_global.user_id,
153: sysdate,
154: fnd_global.user_id,
155: fnd_global.login_id,
156: fnd_global.conc_request_id,
157: fnd_global.prog_appl_id,
158: fnd_global.conc_program_id,
159: sysdate,
160: min(bos.operation_sequence_id),

Line 157: fnd_global.prog_appl_id,

153: sysdate,
154: fnd_global.user_id,
155: fnd_global.login_id,
156: fnd_global.conc_request_id,
157: fnd_global.prog_appl_id,
158: fnd_global.conc_program_id,
159: sysdate,
160: min(bos.operation_sequence_id),
161: bos.department_id,

Line 158: fnd_global.conc_program_id,

154: fnd_global.user_id,
155: fnd_global.login_id,
156: fnd_global.conc_request_id,
157: fnd_global.prog_appl_id,
158: fnd_global.conc_program_id,
159: sysdate,
160: min(bos.operation_sequence_id),
161: bos.department_id,
162: round(p_qty, 6),

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

214: (eng.status_type in (1, 4, 7) and l_excludeECO = 2)))
215: and bos2.acd_type = 3)
216: group by bos.operation_seq_num,
217: bos.department_id, bos.count_point_type, bos.backflush_flag, bos.minimum_transfer_quantity,
218: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,
219: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,
220: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,
221: bos.long_description, bos.attribute_category, bos.attribute1, bos.attribute2,
222: bos.attribute3, bos.attribute4, bos.attribute5, bos.attribute6, bos.attribute7, bos.attribute8,

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

215: and bos2.acd_type = 3)
216: group by bos.operation_seq_num,
217: bos.department_id, bos.count_point_type, bos.backflush_flag, bos.minimum_transfer_quantity,
218: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,
219: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,
220: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,
221: bos.long_description, bos.attribute_category, bos.attribute1, bos.attribute2,
222: bos.attribute3, bos.attribute4, bos.attribute5, bos.attribute6, bos.attribute7, bos.attribute8,
223: bos.attribute9, bos.attribute10, bos.attribute11, bos.attribute12, bos.attribute13,

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

216: group by bos.operation_seq_num,
217: bos.department_id, bos.count_point_type, bos.backflush_flag, bos.minimum_transfer_quantity,
218: p_orgID, p_wipEntityID, p_repSchedID, p_qty, p_startDate, p_endDate, sysdate, fnd_global.user_id,
219: fnd_global.login_id, fnd_global.conc_request_id, fnd_global.prog_appl_id,
220: fnd_global.conc_program_id, bos.standard_operation_id, bos.operation_description,
221: bos.long_description, bos.attribute_category, bos.attribute1, bos.attribute2,
222: bos.attribute3, bos.attribute4, bos.attribute5, bos.attribute6, bos.attribute7, bos.attribute8,
223: bos.attribute9, bos.attribute10, bos.attribute11, bos.attribute12, bos.attribute13,
224: bos.attribute14, bos.attribute15, bos.check_skill;

Line 301: fnd_global.user_id,

297: bor.resource_seq_num,
298: p_orgID,
299: p_repSchedID,
300: sysdate,
301: fnd_global.user_id,
302: sysdate,
303: fnd_global.user_id,
304: fnd_global.login_id,
305: fnd_global.conc_request_id,

Line 303: fnd_global.user_id,

299: p_repSchedID,
300: sysdate,
301: fnd_global.user_id,
302: sysdate,
303: fnd_global.user_id,
304: fnd_global.login_id,
305: fnd_global.conc_request_id,
306: fnd_global.prog_appl_id,
307: fnd_global.conc_program_id,

Line 304: fnd_global.login_id,

300: sysdate,
301: fnd_global.user_id,
302: sysdate,
303: fnd_global.user_id,
304: fnd_global.login_id,
305: fnd_global.conc_request_id,
306: fnd_global.prog_appl_id,
307: fnd_global.conc_program_id,
308: sysdate,

Line 305: fnd_global.conc_request_id,

301: fnd_global.user_id,
302: sysdate,
303: fnd_global.user_id,
304: fnd_global.login_id,
305: fnd_global.conc_request_id,
306: fnd_global.prog_appl_id,
307: fnd_global.conc_program_id,
308: sysdate,
309: bor.resource_id,

Line 306: fnd_global.prog_appl_id,

302: sysdate,
303: fnd_global.user_id,
304: fnd_global.login_id,
305: fnd_global.conc_request_id,
306: fnd_global.prog_appl_id,
307: fnd_global.conc_program_id,
308: sysdate,
309: bor.resource_id,
310: br.unit_of_measure,

Line 307: fnd_global.conc_program_id,

303: fnd_global.user_id,
304: fnd_global.login_id,
305: fnd_global.conc_request_id,
306: fnd_global.prog_appl_id,
307: fnd_global.conc_program_id,
308: sysdate,
309: bor.resource_id,
310: br.unit_of_measure,
311: bor.basis_type,

Line 499: x_created_by => fnd_global.user_id,

495: x_to_entity_name => 'WIP_DISCRETE_OPERATIONS',
496: x_to_pk1_value => to_char(p_wipEntityID),
497: x_to_pk2_value => to_char(op_attach.operation_seq_num),
498: x_to_pk3_value => to_char(p_orgID),
499: x_created_by => fnd_global.user_id,
500: x_last_update_login => fnd_global.login_id,
501: x_program_application_id => fnd_global.prog_appl_id,
502: x_program_id => fnd_global.conc_program_id,
503: x_request_id => fnd_global.conc_request_id);

Line 500: x_last_update_login => fnd_global.login_id,

496: x_to_pk1_value => to_char(p_wipEntityID),
497: x_to_pk2_value => to_char(op_attach.operation_seq_num),
498: x_to_pk3_value => to_char(p_orgID),
499: x_created_by => fnd_global.user_id,
500: x_last_update_login => fnd_global.login_id,
501: x_program_application_id => fnd_global.prog_appl_id,
502: x_program_id => fnd_global.conc_program_id,
503: x_request_id => fnd_global.conc_request_id);
504: END LOOP;

Line 501: x_program_application_id => fnd_global.prog_appl_id,

497: x_to_pk2_value => to_char(op_attach.operation_seq_num),
498: x_to_pk3_value => to_char(p_orgID),
499: x_created_by => fnd_global.user_id,
500: x_last_update_login => fnd_global.login_id,
501: x_program_application_id => fnd_global.prog_appl_id,
502: x_program_id => fnd_global.conc_program_id,
503: x_request_id => fnd_global.conc_request_id);
504: END LOOP;
505:

Line 502: x_program_id => fnd_global.conc_program_id,

498: x_to_pk3_value => to_char(p_orgID),
499: x_created_by => fnd_global.user_id,
500: x_last_update_login => fnd_global.login_id,
501: x_program_application_id => fnd_global.prog_appl_id,
502: x_program_id => fnd_global.conc_program_id,
503: x_request_id => fnd_global.conc_request_id);
504: END LOOP;
505:
506: /* Added for 12.1.1 Skills Validation project.*/

Line 503: x_request_id => fnd_global.conc_request_id);

499: x_created_by => fnd_global.user_id,
500: x_last_update_login => fnd_global.login_id,
501: x_program_application_id => fnd_global.prog_appl_id,
502: x_program_id => fnd_global.conc_program_id,
503: x_request_id => fnd_global.conc_request_id);
504: END LOOP;
505:
506: /* Added for 12.1.1 Skills Validation project.*/
507: if ( l_logLevel <= wip_constants.full_logging ) then

Line 825: fnd_global.user_id,

821: decode(l_compTbl(l_count).wip_supply_type,
822: wip_constants.phantom, -1*l_opSeq, l_opSeq),
823: null,
824: sysdate,
825: fnd_global.user_id,
826: sysdate,
827: fnd_global.user_id,
828: fnd_global.login_id,
829: fnd_global.conc_request_id,

Line 827: fnd_global.user_id,

823: null,
824: sysdate,
825: fnd_global.user_id,
826: sysdate,
827: fnd_global.user_id,
828: fnd_global.login_id,
829: fnd_global.conc_request_id,
830: fnd_global.prog_appl_id,
831: fnd_global.conc_program_id,

Line 828: fnd_global.login_id,

824: sysdate,
825: fnd_global.user_id,
826: sysdate,
827: fnd_global.user_id,
828: fnd_global.login_id,
829: fnd_global.conc_request_id,
830: fnd_global.prog_appl_id,
831: fnd_global.conc_program_id,
832: sysdate,

Line 829: fnd_global.conc_request_id,

825: fnd_global.user_id,
826: sysdate,
827: fnd_global.user_id,
828: fnd_global.login_id,
829: fnd_global.conc_request_id,
830: fnd_global.prog_appl_id,
831: fnd_global.conc_program_id,
832: sysdate,
833: l_compTbl(l_count).component_sequence_id,

Line 830: fnd_global.prog_appl_id,

826: sysdate,
827: fnd_global.user_id,
828: fnd_global.login_id,
829: fnd_global.conc_request_id,
830: fnd_global.prog_appl_id,
831: fnd_global.conc_program_id,
832: sysdate,
833: l_compTbl(l_count).component_sequence_id,
834: l_compTbl(l_count).wip_supply_type,

Line 831: fnd_global.conc_program_id,

827: fnd_global.user_id,
828: fnd_global.login_id,
829: fnd_global.conc_request_id,
830: fnd_global.prog_appl_id,
831: fnd_global.conc_program_id,
832: sysdate,
833: l_compTbl(l_count).component_sequence_id,
834: l_compTbl(l_count).wip_supply_type,
835: p_jobStartDate,