DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on WIP_RESOURCE_ACTUAL_TIMES

Line 1685: --Purge records from WIP_RESOURCE_ACTUAL_TIMES

1681:
1682:
1683: --
1684: --Bug#4715338 START - Purge Time Entry records
1685: --Purge records from WIP_RESOURCE_ACTUAL_TIMES
1686: --
1687: x_purge_rec.table_name := 'WIP_RESOURCE_ACTUAL_TIMES';
1688:
1689: if (p_option = REPORT_ONLY) then

Line 1687: x_purge_rec.table_name := 'WIP_RESOURCE_ACTUAL_TIMES';

1683: --
1684: --Bug#4715338 START - Purge Time Entry records
1685: --Purge records from WIP_RESOURCE_ACTUAL_TIMES
1686: --
1687: x_purge_rec.table_name := 'WIP_RESOURCE_ACTUAL_TIMES';
1688:
1689: if (p_option = REPORT_ONLY) then
1690: SELECT COUNT(*) INTO X_NUM_ROWS
1691: FROM WIP_RESOURCE_ACTUAL_TIMES

Line 1691: FROM WIP_RESOURCE_ACTUAL_TIMES

1687: x_purge_rec.table_name := 'WIP_RESOURCE_ACTUAL_TIMES';
1688:
1689: if (p_option = REPORT_ONLY) then
1690: SELECT COUNT(*) INTO X_NUM_ROWS
1691: FROM WIP_RESOURCE_ACTUAL_TIMES
1692: WHERE ORGANIZATION_ID = X_PURGE_REC.ORG_ID AND
1693: WIP_ENTITY_ID = X_PURGE_REC.WIP_ENTITY_ID;
1694: else
1695: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

Line 1695: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

1691: FROM WIP_RESOURCE_ACTUAL_TIMES
1692: WHERE ORGANIZATION_ID = X_PURGE_REC.ORG_ID AND
1693: WIP_ENTITY_ID = X_PURGE_REC.WIP_ENTITY_ID;
1694: else
1695: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
1696: WHERE ORGANIZATION_ID = X_PURGE_REC.ORG_ID AND
1697: WIP_ENTITY_ID = X_PURGE_REC.WIP_ENTITY_ID;
1698: x_num_rows := SQL%ROWCOUNT ;
1699: end if;