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