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:
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: Exception When no_data_found then
518:

Line 531: delete from wip_ws_ptpkpi_actual

527:
528: /*
529: If RecentShiftid is not null then
530: -- remove possible partial aggregated data for the most recent shift
531: delete from wip_ws_ptpkpi_actual
532: where shift_start_time >= RecentShiftStartTime;
533: End if;
534: */
535:

Line 536: delete from wip_ws_ptpkpi_actual

532: where shift_start_time >= RecentShiftStartTime;
533: End if;
534: */
535:
536: delete from wip_ws_ptpkpi_actual
537: where shift_start_time >= sysdate-7
538: and organization_id = p_org_id;
539: -- process each row and find out whether the quantity should be
540: -- counted as a positive/negative move, scrap, or reject.

Line 872: insert into wip_ws_ptpkpi_actual(

868: wip_ws_util.trace_log(' After loop');
869: l_stmt_no := 120;
870:
871: -- aggregate the temp data and insert to the actual table
872: insert into wip_ws_ptpkpi_actual(
873: organization_id,
874: department_id,
875: wip_entity_id,
876: shift_id,