[Home] [Help]
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
34: WHERE SEQ_TASK_ID = p_seq_task_id;
35:
36: l_debug_line := 40;
37: DELETE FROM FLM_SEQ_TASK_LINES
329: END line_available_capacity;
330:
331:
332: /**********************************************************************************
333: * To insert demand from MRP_UNSCHEDULED_ORDERS_V to FLM_SEQ_TASK_DEMANDS table. *
334: **********************************************************************************/
335: PROCEDURE insert_demands(p_seq_task_id IN NUMBER,
336: p_max_rows IN NUMBER,
337: p_init_msg_list IN VARCHAR2,
473: return;
474: END IF;
475:
476: IF (p_max_rows IS NULL OR p_max_rows <> -1) THEN
477: l_cursor_insert := 'INSERT INTO FLM_SEQ_TASK_DEMANDS (SEQ_TASK_ID,ALTERNATE_ROUTING_DESIGNATOR,LINE_ID,'||
478: 'DEMAND_ID,SPLIT_NUMBER,OBJECT_VERSION_NUMBER,ORGANIZATION_ID,PRIMARY_ITEM_ID,'||
479: 'OPEN_QTY,REQUESTED_QTY,FULFILLED_QTY,'||
480: 'CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,'||
481: 'LAST_UPDATE_DATE,LAST_UPDATED_BY,REQUEST_ID,PROGRAM_ID,PROGRAM_APPLICATION_ID,'||
555: END get_demand_qty;
556:
557:
558: /*******************************************************
559: * To delete demands from FLM_SEQ_TASK_DEMANDS table. *
560: *******************************************************/
561: PROCEDURE delete_demands(p_seq_task_id IN NUMBER,
562: p_init_msg_list IN VARCHAR2,
563: x_return_status OUT NOCOPY VARCHAR2,
574:
575: l_debug_line := 10;
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577:
578: DELETE FROM FLM_SEQ_TASK_DEMANDS WHERE SEQ_TASK_ID = p_seq_task_id;
579: l_debug_line := 20;
580:
581: EXCEPTION
582: WHEN OTHERS THEN