DBA Data[Home] [Help]

APPS.WIP_BOMROUTINGUTIL_PVT dependencies on WIP_OPERATION_COMPETENCIES

Line 535: DELETE FROM WIP_OPERATION_COMPETENCIES

531: if ( l_logLevel <= wip_constants.full_logging ) then
532: wip_logger.log('begin to load competence', l_retStatus);
533: end if;
534:
535: DELETE FROM WIP_OPERATION_COMPETENCIES
536: WHERE WIP_ENTITY_ID = p_wipEntityID
537: AND ORGANIZATION_ID = p_orgID;
538:
539:

Line 540: INSERT INTO WIP_OPERATION_COMPETENCIES

536: WHERE WIP_ENTITY_ID = p_wipEntityID
537: AND ORGANIZATION_ID = p_orgID;
538:
539:
540: INSERT INTO WIP_OPERATION_COMPETENCIES
541: (LEVEL_ID, ORGANIZATION_ID,
542: WIP_ENTITY_ID, OPERATION_SEQ_NUM, OPERATION_SEQUENCE_ID,
543: STANDARD_OPERATION_ID, COMPETENCE_ID, RATING_LEVEL_ID,
544: QUALIFICATION_TYPE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,