[Home] [Help]
83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
84: --
85: BEGIN
86:
87: SELECT mrp_atp_schedule_temp_s.nextval
88: INTO MRP_SESSION_ID
89: from dual;
90:
91: return MRP_SESSION_ID;
266: Procedure Name : Insert_Mandatory_Components
267: Description : This procedure is called from the form side, when the user
268: clicks on global availability button and the item to check
269: global availability is an ATO Model. We insert the mandatory
270: components in MRP_ATP_SCHEDULE_TEMP for global availability.
271: --------------------------------------------------------------------------*/
272: Procedure Insert_Mandatory_Components
273: (p_order_number IN NUMBER,
274: p_ato_line_id IN NUMBER,
526:
527: END IF;
528:
529:
530: INSERT INTO MRP_ATP_SCHEDULE_TEMP
531: (INVENTORY_ITEM_ID,
532: SR_INSTANCE_ID,
533: SOURCE_ORGANIZATION_ID,
534: CUSTOMER_ID,
15183: ELSE
15184: l_insert_code := 2;
15185: END IF;
15186:
15187: -- Insert into mrp_atp_schedule_temp table
15188:
15189: INSERT INTO MRP_ATP_SCHEDULE_TEMP
15190: (INVENTORY_ITEM_ID,
15191: SR_INSTANCE_ID,
15185: END IF;
15186:
15187: -- Insert into mrp_atp_schedule_temp table
15188:
15189: INSERT INTO MRP_ATP_SCHEDULE_TEMP
15190: (INVENTORY_ITEM_ID,
15191: SR_INSTANCE_ID,
15192: SOURCE_ORGANIZATION_ID,
15193: CUSTOMER_ID,
15498: l_conc_line_number :=
15499: OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(l_line_id);
15500:
15501:
15502: -- Insert into mrp_atp_schedule_temp table
15503:
15504: INSERT INTO MRP_ATP_SCHEDULE_TEMP
15505: (INVENTORY_ITEM_ID,
15506: SR_INSTANCE_ID,
15500:
15501:
15502: -- Insert into mrp_atp_schedule_temp table
15503:
15504: INSERT INTO MRP_ATP_SCHEDULE_TEMP
15505: (INVENTORY_ITEM_ID,
15506: SR_INSTANCE_ID,
15507: SOURCE_ORGANIZATION_ID,
15508: CUSTOMER_ID,