391: END IF;
392:
393: SELECT wip_job_schedule_interface_s.nextval
394: INTO l_group_id
395: FROM DUAL;
396:
397: SELECT wip_interface_s.nextval
398: INTO l_interface_id
399: FROM DUAL;
395: FROM DUAL;
396:
397: SELECT wip_interface_s.nextval
398: INTO l_interface_id
399: FROM DUAL;
400:
401: IF p_action IN ('U','D') AND
402: l_subcontract_orders_rec.wip_entity_id IS NOT NULL
403: THEN
526: THEN
527:
528: SELECT wip_job_schedule_interface_s.nextval
529: INTO l_group_id
530: FROM DUAL;
531:
532: INSERT INTO
533: WIP_JOB_SCHEDULE_INTERFACE
534: ( bom_revision_date