[Home] [Help]
33: DELETE FROM FLM_SEQ_TASK_DEMANDS
34: WHERE SEQ_TASK_ID = p_seq_task_id;
35:
36: l_debug_line := 40;
37: DELETE FROM FLM_SEQ_TASK_LINES
38: WHERE SEQ_TASK_ID = p_seq_task_id;
39:
40: l_debug_line := 50;
41: DELETE FROM FLM_FILTER_CRITERIA
363: l_count_rows NUMBER;
364:
365: CURSOR line_list IS
366: SELECT LINE_ID
367: FROM FLM_SEQ_TASK_LINES
368: WHERE SEQ_TASK_ID = p_seq_task_id;
369: BEGIN
370: SAVEPOINT flm_insert_demands;
371: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
636:
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,
658:
659: l_debug_line := 10;
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: INSERT INTO FLM_SEQ_TASK_LINES (
663: SEQ_TASK_ID,
664: LINE_ID,
665: OBJECT_VERSION_NUMBER,
666: ORGANIZATION_ID,
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,
809:
810: l_debug_line := 10;
811: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;