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 551: WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(

547: wo.department_id ,
548: wo.wip_entity_id ,
549: wo.operation_seq_num,
550: wmt1.PRIMARY_QUANTITY,
551: WIP_WS_PTPKPI_UTIL.get_shift_id_for_date(
552: wo.organization_id,
553: wo.department_id,
554: null,
555: wmt1.transaction_date

Line 562: WIP_WS_PTPKPI_UTIL.get_operation_lead_time(

558: FM_INTRAOPERATION_STEP_TYPE fm_step,
559: to_operation_seq_num to_op,
560: TO_INTRAOPERATION_STEP_TYPE to_step,
561: wmt1.primary_uom primary_uom_code,
562: WIP_WS_PTPKPI_UTIL.get_operation_lead_time(
563: wdj.organization_id,
564: wdj.wip_entity_id,
565: wo.operation_seq_num) op_lead_time,
566: wo.operation_seq_num op

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

896: sum(nvl(scrap_qty,0)) ,
897: sum(nvl(reject_qty,0)),
898: t.primary_uom_code,
899: t.op_lead_time,
900: WIP_WS_PTPKPI_UTIL.get_datetime_for_shift(p_org_id,shift_id,1),
901: fnd_global.CONC_REQUEST_ID,
902: sysdate,
903: g_user_id,
904: sysdate,