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,
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,
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,
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),
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,
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),
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,
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,
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;
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,
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,
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,
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,
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,
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,
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);
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;
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:
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.*/
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
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,
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,
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,
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,
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,
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,