APPS.WIP_WS_PTPKPI_PK dependencies on WIP_WS_PTPKPI_ACTUAL

Line 498: from wip_ws_ptpkpi_actual

494:
495: l_stmt_no := 10;
496:
497: delete
498: from wip_ws_ptpkpi_actual
499: where shift_start_time < trunc(sysdate) - 30
500: and organization_id = p_org_id;
501:
502: wip_ws_util.trace_log('Deleted old records. Number of records deleted = '||sql%rowcount);

Line 511: from wip_ws_ptpkpi_actual

507: Begin
508: -- Bug 16177462
509: /* select shift_id, shift_start_time
510: into RecentShiftid, RecentShiftStartTime
511: from wip_ws_ptpkpi_actual
512: where shift_start_time in
513: (select max(shift_start_Time)
514: from wip_ws_ptpkpi_actual)
515: and rownum = 1;*/

Line 514: from wip_ws_ptpkpi_actual)

510: into RecentShiftid, RecentShiftStartTime
511: from wip_ws_ptpkpi_actual
512: where shift_start_time in
513: (select max(shift_start_Time)
514: from wip_ws_ptpkpi_actual)
515: and rownum = 1;*/
516:
517: select shift_start_time
518: into RecentShiftStartTime

Line 519: from wip_ws_ptpkpi_actual

515: and rownum = 1;*/
516:
517: select shift_start_time
518: into RecentShiftStartTime
519: from wip_ws_ptpkpi_actual
520: where shift_start_time in
521: (select max(shift_start_Time)
522: from wip_ws_ptpkpi_actual)
523: and rownum = 1;

Line 522: from wip_ws_ptpkpi_actual)

518: into RecentShiftStartTime
519: from wip_ws_ptpkpi_actual
520: where shift_start_time in
521: (select max(shift_start_Time)
522: from wip_ws_ptpkpi_actual)
523: and rownum = 1;
524:
525: Exception When no_data_found then
526:

Line 539: delete from wip_ws_ptpkpi_actual

535:
536: /*
537: If RecentShiftid is not null then
538: -- remove possible partial aggregated data for the most recent shift
539: delete from wip_ws_ptpkpi_actual
540: where shift_start_time >= RecentShiftStartTime;
541: End if;
542: */
543:

Line 544: delete from wip_ws_ptpkpi_actual

540: where shift_start_time >= RecentShiftStartTime;
541: End if;
542: */
543:
544: delete from wip_ws_ptpkpi_actual
545: where shift_start_time >= sysdate-7
546: and organization_id = p_org_id;
547: -- process each row and find out whether the quantity should be
548: -- counted as a positive/negative move, scrap, or reject.

Line 880: insert into wip_ws_ptpkpi_actual(

876: wip_ws_util.trace_log(' After loop');
877: l_stmt_no := 120;
878:
879: -- aggregate the temp data and insert to the actual table
880: insert into wip_ws_ptpkpi_actual(
881: organization_id,
882: department_id,
883: wip_entity_id,
884: shift_id,