DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on CST_STD_COST_ADJ_DEBUG

Line 1493: CST_STD_COST_ADJ_DEBUG

1489: num_rows => x_num_rows);
1490: end if;
1491:
1492: /* Fix for Bug#3125050. Changed CST_STD_COST_ADJ_TEMP TO
1493: CST_STD_COST_ADJ_DEBUG
1494: */
1495: x_purge_rec.table_name := 'CST_STD_COST_ADJ_DEBUG';
1496:
1497:

Line 1495: x_purge_rec.table_name := 'CST_STD_COST_ADJ_DEBUG';

1491:
1492: /* Fix for Bug#3125050. Changed CST_STD_COST_ADJ_TEMP TO
1493: CST_STD_COST_ADJ_DEBUG
1494: */
1495: x_purge_rec.table_name := 'CST_STD_COST_ADJ_DEBUG';
1496:
1497:
1498: if (p_option = REPORT_ONLY) then
1499: SELECT COUNT(*) INTO x_num_rows

Line 1500: FROM CST_STD_COST_ADJ_DEBUG

1496:
1497:
1498: if (p_option = REPORT_ONLY) then
1499: SELECT COUNT(*) INTO x_num_rows
1500: FROM CST_STD_COST_ADJ_DEBUG
1501: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1502: AND ORGANIZATION_ID = x_purge_rec.org_id;
1503: else
1504: DELETE FROM CST_STD_COST_ADJ_DEBUG

Line 1504: DELETE FROM CST_STD_COST_ADJ_DEBUG

1500: FROM CST_STD_COST_ADJ_DEBUG
1501: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1502: AND ORGANIZATION_ID = x_purge_rec.org_id;
1503: else
1504: DELETE FROM CST_STD_COST_ADJ_DEBUG
1505: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1506: AND ORGANIZATION_ID = x_purge_rec.org_id;
1507:
1508: x_num_rows := SQL%ROWCOUNT ;