[Home] [Help]
108: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
109: --
110: BEGIN
111:
112: SELECT mrp_atp_schedule_temp_s.nextval
113: INTO MRP_SESSION_ID
114: from dual;
115:
116: return MRP_SESSION_ID;
291: Procedure Name : Insert_Mandatory_Components
292: Description : This procedure is called from the form side, when the user
293: clicks on global availability button and the item to check
294: global availability is an ATO Model. We insert the mandatory
295: components in MRP_ATP_SCHEDULE_TEMP for global availability.
296: --------------------------------------------------------------------------*/
297: Procedure Insert_Mandatory_Components
298: (p_order_number IN NUMBER,
299: p_ato_line_id IN NUMBER,
551:
552: END IF;
553:
554:
555: INSERT INTO MRP_ATP_SCHEDULE_TEMP
556: (INVENTORY_ITEM_ID,
557: SR_INSTANCE_ID,
558: SOURCE_ORGANIZATION_ID,
559: CUSTOMER_ID,
17730: ELSE
17731: l_insert_code := 2;
17732: END IF;
17733:
17734: -- Insert into mrp_atp_schedule_temp table
17735:
17736: INSERT INTO MRP_ATP_SCHEDULE_TEMP
17737: (INVENTORY_ITEM_ID,
17738: SR_INSTANCE_ID,
17732: END IF;
17733:
17734: -- Insert into mrp_atp_schedule_temp table
17735:
17736: INSERT INTO MRP_ATP_SCHEDULE_TEMP
17737: (INVENTORY_ITEM_ID,
17738: SR_INSTANCE_ID,
17739: SOURCE_ORGANIZATION_ID,
17740: CUSTOMER_ID,
18046: l_conc_line_number :=
18047: OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(l_line_id);
18048:
18049:
18050: -- Insert into mrp_atp_schedule_temp table
18051:
18052: INSERT INTO MRP_ATP_SCHEDULE_TEMP
18053: (INVENTORY_ITEM_ID,
18054: SR_INSTANCE_ID,
18048:
18049:
18050: -- Insert into mrp_atp_schedule_temp table
18051:
18052: INSERT INTO MRP_ATP_SCHEDULE_TEMP
18053: (INVENTORY_ITEM_ID,
18054: SR_INSTANCE_ID,
18055: SOURCE_ORGANIZATION_ID,
18056: CUSTOMER_ID,