[Home] [Help]
25: DELETE FROM FLM_SEQ_TASK_EXCEPTIONS
26: WHERE SEQ_TASK_ID = p_seq_task_id;
27:
28: l_debug_line := 20;
29: DELETE FROM FLM_SEQ_TASK_CONSTRAINTS
30: WHERE SEQ_TASK_ID = p_seq_task_id;
31:
32: l_debug_line := 30;
33: DELETE FROM FLM_SEQ_TASK_DEMANDS
637: END delete_criteria;
638:
639: /***************************************************************************************
640: * To insert lines from WIP_LINES into FLM_SEQ_TASK_LINES and all constraints on the *
641: * line default rule from FLM_SEQ_TASK_CONSTRAINTS into FLM_SEQ_TASK_CONSTRAINTS. *
642: ***************************************************************************************/
643: PROCEDURE insert_line_constraints(p_seq_task_id IN NUMBER,
644: p_line_id IN NUMBER,
645: p_org_id IN NUMBER,
711: NULL
712: FROM WIP_LINES
713: WHERE LINE_ID = p_line_id AND ORGANIZATION_ID = p_org_id;
714:
715: INSERT INTO FLM_SEQ_TASK_CONSTRAINTS (
716: SEQ_TASK_ID,
717: LINE_ID,
718: PARENT_CONSTRAINT_NUMBER,
719: CONSTRAINT_NUMBER,
790:
791: END insert_line_constraints;
792:
793: /*****************************************************************************************************
794: * To delete lines from FLM_SEQ_TASK_LINES and line contraints from FLM_SEQ_TASK_CONSTRAINTS table. *
795: *****************************************************************************************************/
796: PROCEDURE delete_line_constraints(p_seq_task_id IN NUMBER,
797: p_init_msg_list IN VARCHAR2,
798: x_return_status OUT NOCOPY VARCHAR2,
812:
813: DELETE FROM FLM_SEQ_TASK_LINES WHERE SEQ_TASK_ID = p_seq_task_id;
814: l_debug_line := 20;
815:
816: DELETE FROM FLM_SEQ_TASK_CONSTRAINTS WHERE SEQ_TASK_ID = p_seq_task_id;
817: l_debug_line := 30;
818:
819: EXCEPTION
820: