APPS.WIP_WS_PTPKPI_PK dependencies on WIP_WS_PTPKPI_UTIL

Line 218: WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(

214: wo.organization_id,
215: wo.department_id,
216: wo.wip_entity_id,
217: wo.operation_seq_num,
218: WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(
219: wo.organization_id, wo.department_id, null, wo.last_unit_completion_date
220: ) ,
221: wo.scheduled_quantity-wo.cumulative_scrap_quantity ,
222: msi.primary_uom_code,

Line 223: WIP_WS_PTPKPI_UTIL.get_operation_lead_time(

219: wo.organization_id, wo.department_id, null, wo.last_unit_completion_date
220: ) ,
221: wo.scheduled_quantity-wo.cumulative_scrap_quantity ,
222: msi.primary_uom_code,
223: WIP_WS_PTPKPI_UTIL.get_operation_lead_time(
224: wo.organization_id, wo.wip_entity_id, wo.operation_seq_num
225: ) ,
226: fnd_global.CONC_REQUEST_ID,
227: sysdate,

Line 231: WIP_WS_PTPKPI_UTIL.get_datetime_for_shift(:p_org_id,WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(

227: sysdate,
228: :guserid,
229: sysdate,
230: :guserid,
231: WIP_WS_PTPKPI_UTIL.get_datetime_for_shift(:p_org_id,WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(
232: wo.organization_id, wo.department_id, null, wo.last_unit_completion_date
233: ),1)
234: from
235: wip_operations wo,

Line 374: WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(

370: wo.department_id ,
371: wo.wip_entity_id ,
372: wo.operation_seq_num,
373: wmt1.PRIMARY_QUANTITY,
374: WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(
375: wo.organization_id,
376: wo.department_id,
377: null,
378: wmt1.transaction_date

Line 385: WIP_WS_PTPKPI_UTIL.get_operation_lead_time(

381: FM_INTRAOPERATION_STEP_TYPE fm_step,
382: to_operation_seq_num to_op,
383: TO_INTRAOPERATION_STEP_TYPE to_step,
384: wmt1.primary_uom primary_uom_code,
385: WIP_WS_PTPKPI_UTIL.get_operation_lead_time(
386: wmt1.organization_id,
387: wmt1.wip_entity_id,
388: wo.operation_seq_num) op_lead_time,
389: wo.operation_seq_num op

Line 559: WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(

555: wo.department_id ,
556: wo.wip_entity_id ,
557: wo.operation_seq_num,
558: wmt1.PRIMARY_QUANTITY,
559: WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(
560: wo.organization_id,
561: wo.department_id,
562: null,
563: wmt1.transaction_date

Line 570: WIP_WS_PTPKPI_UTIL.get_operation_lead_time(

566: FM_INTRAOPERATION_STEP_TYPE fm_step,
567: to_operation_seq_num to_op,
568: TO_INTRAOPERATION_STEP_TYPE to_step,
569: wmt1.primary_uom primary_uom_code,
570: WIP_WS_PTPKPI_UTIL.get_operation_lead_time(
571: wdj.organization_id,
572: wdj.wip_entity_id,
573: wo.operation_seq_num) op_lead_time,
574: wo.operation_seq_num op

Line 908: WIP_WS_PTPKPI_UTIL.get_datetime_for_shift(p_org_id,shift_id,1),

904: sum(nvl(scrap_qty,0)) ,
905: sum(nvl(reject_qty,0)),
906: t.primary_uom_code,
907: t.op_lead_time,
908: WIP_WS_PTPKPI_UTIL.get_datetime_for_shift(p_org_id,shift_id,1),
909: fnd_global.CONC_REQUEST_ID,
910: sysdate,
911: g_user_id,
912: sysdate,