APPS.OE_SCHEDULE_UTIL dependencies on MRP_ATP_PUB

Line 315: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;

311:
312: )
313: IS
314: l_model_line_rec OE_ORDER_PUB.line_rec_type;
315: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
316: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
317: l_ship_set VARCHAR2(30);
318: lTableName VARCHAR2(30);
319: lMessageName VARCHAR2(30);

Line 316: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;

312: )
313: IS
314: l_model_line_rec OE_ORDER_PUB.line_rec_type;
315: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
316: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
317: l_ship_set VARCHAR2(30);
318: lTableName VARCHAR2(30);
319: lMessageName VARCHAR2(30);
320: lErrorMessage VARCHAR2(2000);

Line 372: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr

368: Get_Lead_Time
369: (p_ato_line_id => l_model_line_rec.ato_line_id,
370: p_ship_from_org_id => l_model_line_rec.ship_from_org_id);
371:
372: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr
373: (l_model_line_rec.Inventory_Item_Id);
374:
375: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
376: (l_model_line_rec.ship_from_org_id);

Line 375: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr

371:
372: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr
373: (l_model_line_rec.Inventory_Item_Id);
374:
375: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
376: (l_model_line_rec.ship_from_org_id);
377:
378: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
379: (l_model_line_rec.line_id);

Line 378: l_model_rec.Identifier := MRP_ATP_PUB.number_arr

374:
375: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
376: (l_model_line_rec.ship_from_org_id);
377:
378: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
379: (l_model_line_rec.line_id);
380:
381: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
382: (660);

Line 381: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr

377:
378: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
379: (l_model_line_rec.line_id);
380:
381: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
382: (660);
383:
384: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
385: (l_model_line_rec.sold_to_org_id);

Line 384: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr

380:
381: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
382: (660);
383:
384: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
385: (l_model_line_rec.sold_to_org_id);
386:
387: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
388: (l_model_line_rec.ship_to_org_id);

Line 387: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr

383:
384: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
385: (l_model_line_rec.sold_to_org_id);
386:
387: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
388: (l_model_line_rec.ship_to_org_id);
389:
390: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
391: (null);

Line 390: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr

386:
387: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
388: (l_model_line_rec.ship_to_org_id);
389:
390: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
391: (null);
392:
393: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
394: (l_model_line_rec.ordered_quantity);

Line 393: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr

389:
390: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
391: (null);
392:
393: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
394: (l_model_line_rec.ordered_quantity);
395:
396: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
397: (l_model_line_rec.order_quantity_uom);

Line 396: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr

392:
393: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
394: (l_model_line_rec.ordered_quantity);
395:
396: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
397: (l_model_line_rec.order_quantity_uom);
398:
399: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
400: (l_model_line_rec.Earliest_Acceptable_Date);

Line 399: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr

395:
396: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
397: (l_model_line_rec.order_quantity_uom);
398:
399: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
400: (l_model_line_rec.Earliest_Acceptable_Date);
401:
402: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
403: (l_model_line_rec.request_date);

Line 402: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr

398:
399: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
400: (l_model_line_rec.Earliest_Acceptable_Date);
401:
402: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
403: (l_model_line_rec.request_date);
404:
405: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
406: (l_model_line_rec.request_date);

Line 405: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr

401:
402: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
403: (l_model_line_rec.request_date);
404:
405: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
406: (l_model_line_rec.request_date);
407:
408: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
409: (l_model_line_rec.Latest_Acceptable_Date);

Line 408: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr

404:
405: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
406: (l_model_line_rec.request_date);
407:
408: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
409: (l_model_line_rec.Latest_Acceptable_Date);
410:
411: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
412: (l_model_line_rec.Delivery_Lead_Time);

Line 411: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr

407:
408: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
409: (l_model_line_rec.Latest_Acceptable_Date);
410:
411: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
412: (l_model_line_rec.Delivery_Lead_Time);
413: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
414: (l_st_atp_lead_time);
415:

Line 413: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr

409: (l_model_line_rec.Latest_Acceptable_Date);
410:
411: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
412: (l_model_line_rec.Delivery_Lead_Time);
413: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
414: (l_st_atp_lead_time);
415:
416: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
417: (l_model_line_rec.Freight_Carrier_Code);

Line 416: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr

412: (l_model_line_rec.Delivery_Lead_Time);
413: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
414: (l_st_atp_lead_time);
415:
416: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
417: (l_model_line_rec.Freight_Carrier_Code);
418:
419: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
420: (null);

Line 419: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr

415:
416: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
417: (l_model_line_rec.Freight_Carrier_Code);
418:
419: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
420: (null);
421:
422: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
423: (l_model_line_rec.Demand_Class_Code);

Line 422: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr

418:
419: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
420: (null);
421:
422: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
423: (l_model_line_rec.Demand_Class_Code);
424:
425: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
426: (l_model_line_rec.ship_set_id);

Line 425: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr

421:
422: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
423: (l_model_line_rec.Demand_Class_Code);
424:
425: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
426: (l_model_line_rec.ship_set_id);
427:
428: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
429: (l_model_line_rec.arrival_set_id);

Line 428: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr

424:
425: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
426: (l_model_line_rec.ship_set_id);
427:
428: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
429: (l_model_line_rec.arrival_set_id);
430:
431: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
432: (null);

Line 431: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr

427:
428: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
429: (l_model_line_rec.arrival_set_id);
430:
431: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
432: (null);
433:
434: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
435: (null);

Line 434: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr

430:
431: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
432: (null);
433:
434: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
435: (null);
436:
437: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
438: (null);

Line 437: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr

433:
434: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
435: (null);
436:
437: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
438: (null);
439:
440: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
441: (null);

Line 440: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr

436:
437: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
438: (null);
439:
440: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
441: (null);
442:
443: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
444: (null);

Line 443: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr

439:
440: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
441: (null);
442:
443: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
444: (null);
445:
446: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
447: (null);

Line 446: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr

442:
443: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
444: (null);
445:
446: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
447: (null);
448:
449: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
450: (null);

Line 449: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr

445:
446: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
447: (null);
448:
449: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
450: (null);
451:
452: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
453: (null);

Line 452: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr

448:
449: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
450: (null);
451:
452: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
453: (null);
454:
455: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
456: (null);

Line 455: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr

451:
452: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
453: (null);
454:
455: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
456: (null);
457:
458: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
459: (null);

Line 458: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr

454:
455: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
456: (null);
457:
458: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
459: (null);
460:
461: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
462: (null);

Line 461: l_model_rec.Message := MRP_ATP_PUB.char2000_arr

457:
458: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
459: (null);
460:
461: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
462: (null);
463:
464: l_model_rec.Action := MRP_ATP_PUB.number_arr
465: (null);

Line 464: l_model_rec.Action := MRP_ATP_PUB.number_arr

460:
461: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
462: (null);
463:
464: l_model_rec.Action := MRP_ATP_PUB.number_arr
465: (null);
466:
467: l_order_number := Get_order_number(l_model_line_rec.header_id);
468:

Line 469: l_model_rec.Order_number := MRP_ATP_PUB.number_arr

465: (null);
466:
467: l_order_number := Get_order_number(l_model_line_rec.header_id);
468:
469: l_model_rec.Order_number := MRP_ATP_PUB.number_arr
470: (l_order_number);
471:
472: IF l_debug_level > 0 THEN
473: oe_debug_pub.add( '1.. CALLING CTO GET_BOM_MANDATORY_COMPS' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

Line 2508: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ

2504: Description : This procedure create l_count records each for each table
2505: in the record of tables of MRP's p_atp_rec.
2506: ------------------------------------------------------------------------*/
2507: Procedure Initialize_mrp_record
2508: ( p_x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ
2509: ,l_count IN NUMBER)
2510: IS
2511: l_return_status VARCHAR2(1);
2512: --

Line 2599: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,

2595: Scheduling Enhancements ER 2736896
2596: Checks whether a split is needed based on the MRP record returned
2597: */
2598: PROCEDURE check_split_needed(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
2599: p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
2600: p_index IN NUMBER,
2601: p_split_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type,
2602: p_line_action IN VARCHAR2,
2603: p_config_exists IN VARCHAR2,

Line 3414: ,x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)

3410: ,p_partial_set IN BOOLEAN := FALSE
3411: ,p_config_line_id IN NUMBER := NULL
3412: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004
3413: ,p_index IN OUT NOCOPY NUMBER
3414: ,x_atp_rec IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)
3415: IS
3416: I NUMBER := p_index;
3417: l_insert_flag NUMBER;
3418: l_oe_flag VARCHAR2(1);

Line 3431: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;

3427: l_organization_id NUMBER;
3428: l_inventory_item_id NUMBER;
3429: l_result NUMBER := 1;
3430:
3431: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
3432: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
3433:
3434: lTableName VARCHAR2(30);
3435: lMessageName VARCHAR2(30);

Line 3432: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;

3428: l_inventory_item_id NUMBER;
3429: l_result NUMBER := 1;
3430:
3431: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
3432: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
3433:
3434: lTableName VARCHAR2(30);
3435: lMessageName VARCHAR2(30);
3436: lErrorMessage VARCHAR2(2000);

Line 4166: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr

4162:
4163: --Load Model Rec to pass to ATO's API
4164: --Load Model Rec to pass to ATO's API
4165:
4166: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr
4167: (x_atp_rec.Inventory_Item_Id(I));
4168:
4169: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
4170: (x_atp_rec.Source_Organization_Id(I));

Line 4169: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr

4165:
4166: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr
4167: (x_atp_rec.Inventory_Item_Id(I));
4168:
4169: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
4170: (x_atp_rec.Source_Organization_Id(I));
4171:
4172: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
4173: (x_atp_rec.Identifier(I));

Line 4172: l_model_rec.Identifier := MRP_ATP_PUB.number_arr

4168:
4169: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
4170: (x_atp_rec.Source_Organization_Id(I));
4171:
4172: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
4173: (x_atp_rec.Identifier(I));
4174:
4175: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
4176: (x_atp_rec.Calling_Module(I));

Line 4175: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr

4171:
4172: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
4173: (x_atp_rec.Identifier(I));
4174:
4175: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
4176: (x_atp_rec.Calling_Module(I));
4177:
4178: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
4179: (x_atp_rec.Customer_Id(I));

Line 4178: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr

4174:
4175: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
4176: (x_atp_rec.Calling_Module(I));
4177:
4178: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
4179: (x_atp_rec.Customer_Id(I));
4180:
4181: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
4182: (x_atp_rec.Customer_Site_Id(I));

Line 4181: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr

4177:
4178: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
4179: (x_atp_rec.Customer_Id(I));
4180:
4181: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
4182: (x_atp_rec.Customer_Site_Id(I));
4183:
4184: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
4185: (x_atp_rec.Destination_Time_Zone(I));

Line 4184: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr

4180:
4181: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
4182: (x_atp_rec.Customer_Site_Id(I));
4183:
4184: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
4185: (x_atp_rec.Destination_Time_Zone(I));
4186:
4187: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
4188: (x_atp_rec.Quantity_Ordered(I));

Line 4187: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr

4183:
4184: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
4185: (x_atp_rec.Destination_Time_Zone(I));
4186:
4187: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
4188: (x_atp_rec.Quantity_Ordered(I));
4189:
4190: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
4191: (x_atp_rec.Quantity_UOM(I));

Line 4190: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr

4186:
4187: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
4188: (x_atp_rec.Quantity_Ordered(I));
4189:
4190: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
4191: (x_atp_rec.Quantity_UOM(I));
4192:
4193: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
4194: (x_atp_rec.Earliest_Acceptable_Date(I));

Line 4193: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr

4189:
4190: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
4191: (x_atp_rec.Quantity_UOM(I));
4192:
4193: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
4194: (x_atp_rec.Earliest_Acceptable_Date(I));
4195:
4196: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
4197: (x_atp_rec.Requested_Ship_Date(I));

Line 4196: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr

4192:
4193: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
4194: (x_atp_rec.Earliest_Acceptable_Date(I));
4195:
4196: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
4197: (x_atp_rec.Requested_Ship_Date(I));
4198:
4199: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
4200: (x_atp_rec.Requested_Arrival_Date(I));

Line 4199: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr

4195:
4196: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
4197: (x_atp_rec.Requested_Ship_Date(I));
4198:
4199: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
4200: (x_atp_rec.Requested_Arrival_Date(I));
4201:
4202: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
4203: (x_atp_rec.Latest_Acceptable_Date(I));

Line 4202: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr

4198:
4199: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
4200: (x_atp_rec.Requested_Arrival_Date(I));
4201:
4202: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
4203: (x_atp_rec.Latest_Acceptable_Date(I));
4204:
4205: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
4206: (x_atp_rec.Delivery_Lead_Time(I));

Line 4205: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr

4201:
4202: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
4203: (x_atp_rec.Latest_Acceptable_Date(I));
4204:
4205: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
4206: (x_atp_rec.Delivery_Lead_Time(I));
4207:
4208: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
4209: (x_atp_rec.Atp_lead_Time(I));

Line 4208: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr

4204:
4205: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
4206: (x_atp_rec.Delivery_Lead_Time(I));
4207:
4208: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
4209: (x_atp_rec.Atp_lead_Time(I));
4210:
4211: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
4212: (x_atp_rec.Freight_Carrier(I));

Line 4211: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr

4207:
4208: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
4209: (x_atp_rec.Atp_lead_Time(I));
4210:
4211: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
4212: (x_atp_rec.Freight_Carrier(I));
4213:
4214: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
4215: (x_atp_rec.Ship_Method(I));

Line 4214: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr

4210:
4211: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
4212: (x_atp_rec.Freight_Carrier(I));
4213:
4214: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
4215: (x_atp_rec.Ship_Method(I));
4216:
4217: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
4218: (x_atp_rec.Demand_Class(I));

Line 4217: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr

4213:
4214: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
4215: (x_atp_rec.Ship_Method(I));
4216:
4217: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
4218: (x_atp_rec.Demand_Class(I));
4219:
4220: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
4221: (x_atp_rec.Ship_Set_Name(I));

Line 4220: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr

4216:
4217: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
4218: (x_atp_rec.Demand_Class(I));
4219:
4220: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
4221: (x_atp_rec.Ship_Set_Name(I));
4222:
4223: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
4224: (x_atp_rec.Arrival_Set_Name(I));

Line 4223: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr

4219:
4220: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
4221: (x_atp_rec.Ship_Set_Name(I));
4222:
4223: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
4224: (x_atp_rec.Arrival_Set_Name(I));
4225:
4226: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
4227: (x_atp_rec.Override_Flag(I));

Line 4226: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr

4222:
4223: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
4224: (x_atp_rec.Arrival_Set_Name(I));
4225:
4226: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
4227: (x_atp_rec.Override_Flag(I));
4228:
4229: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
4230: (x_atp_rec.Ship_Date(I));

Line 4229: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr

4225:
4226: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
4227: (x_atp_rec.Override_Flag(I));
4228:
4229: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
4230: (x_atp_rec.Ship_Date(I));
4231:
4232: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
4233: (x_atp_rec.Available_Quantity(I));

Line 4232: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr

4228:
4229: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
4230: (x_atp_rec.Ship_Date(I));
4231:
4232: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
4233: (x_atp_rec.Available_Quantity(I));
4234:
4235: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
4236: (x_atp_rec.Requested_Date_Quantity(I));

Line 4235: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr

4231:
4232: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
4233: (x_atp_rec.Available_Quantity(I));
4234:
4235: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
4236: (x_atp_rec.Requested_Date_Quantity(I));
4237:
4238: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
4239: (x_atp_rec.Group_Ship_Date(I));

Line 4238: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr

4234:
4235: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
4236: (x_atp_rec.Requested_Date_Quantity(I));
4237:
4238: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
4239: (x_atp_rec.Group_Ship_Date(I));
4240:
4241: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
4242: (x_atp_rec.Group_Arrival_Date(I));

Line 4241: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr

4237:
4238: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
4239: (x_atp_rec.Group_Ship_Date(I));
4240:
4241: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
4242: (x_atp_rec.Group_Arrival_Date(I));
4243:
4244: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
4245: (x_atp_rec.Vendor_Id(I));

Line 4244: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr

4240:
4241: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
4242: (x_atp_rec.Group_Arrival_Date(I));
4243:
4244: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
4245: (x_atp_rec.Vendor_Id(I));
4246:
4247: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
4248: (x_atp_rec.Vendor_Site_Id(I));

Line 4247: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr

4243:
4244: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
4245: (x_atp_rec.Vendor_Id(I));
4246:
4247: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
4248: (x_atp_rec.Vendor_Site_Id(I));
4249:
4250: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
4251: (x_atp_rec.Insert_Flag(I));

Line 4250: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr

4246:
4247: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
4248: (x_atp_rec.Vendor_Site_Id(I));
4249:
4250: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
4251: (x_atp_rec.Insert_Flag(I));
4252:
4253: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
4254: (x_atp_rec.Error_Code(I));

Line 4253: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr

4249:
4250: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
4251: (x_atp_rec.Insert_Flag(I));
4252:
4253: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
4254: (x_atp_rec.Error_Code(I));
4255:
4256: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
4257: (x_atp_rec.Message(I));

Line 4256: l_model_rec.Message := MRP_ATP_PUB.char2000_arr

4252:
4253: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
4254: (x_atp_rec.Error_Code(I));
4255:
4256: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
4257: (x_atp_rec.Message(I));
4258:
4259: l_model_rec.Action := MRP_ATP_PUB.number_arr
4260: (x_atp_rec.action(I));

Line 4259: l_model_rec.Action := MRP_ATP_PUB.number_arr

4255:
4256: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
4257: (x_atp_rec.Message(I));
4258:
4259: l_model_rec.Action := MRP_ATP_PUB.number_arr
4260: (x_atp_rec.action(I));
4261:
4262: l_model_rec.order_number := MRP_ATP_PUB.number_arr
4263: (x_atp_rec.order_number(I));

Line 4262: l_model_rec.order_number := MRP_ATP_PUB.number_arr

4258:
4259: l_model_rec.Action := MRP_ATP_PUB.number_arr
4260: (x_atp_rec.action(I));
4261:
4262: l_model_rec.order_number := MRP_ATP_PUB.number_arr
4263: (x_atp_rec.order_number(I));
4264:
4265: IF x_atp_rec.Old_Source_Organization_Id.Exists(I) THEN
4266: l_model_rec.Old_Source_Organization_Id := MRP_ATP_PUB.number_arr

Line 4266: l_model_rec.Old_Source_Organization_Id := MRP_ATP_PUB.number_arr

4262: l_model_rec.order_number := MRP_ATP_PUB.number_arr
4263: (x_atp_rec.order_number(I));
4264:
4265: IF x_atp_rec.Old_Source_Organization_Id.Exists(I) THEN
4266: l_model_rec.Old_Source_Organization_Id := MRP_ATP_PUB.number_arr
4267: (x_atp_rec.Old_Source_Organization_Id(I));
4268: END IF;
4269:
4270: IF x_atp_rec.Old_Demand_Class.Exists(I) THEN

Line 4272: MRP_ATP_PUB.char30_arr(x_atp_rec.Old_Demand_Class(I));

4268: END IF;
4269:
4270: IF x_atp_rec.Old_Demand_Class.Exists(I) THEN
4271: l_model_rec.Old_Demand_Class :=
4272: MRP_ATP_PUB.char30_arr(x_atp_rec.Old_Demand_Class(I));
4273: END IF;
4274:
4275: BEGIN
4276: IF l_debug_level > 0 THEN

Line 4433: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)

4429: Procedure Load_MRP_request_from_rec
4430: ( p_line_rec IN OE_ORDER_PUB.Line_rec_Type
4431: ,p_old_line_rec IN OE_ORDER_PUB.Line_rec_Type
4432: ,p_sch_action IN VARCHAR2 := NULL
4433: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)
4434:
4435: IS
4436: l_mrp_calc_sd VARCHAR2(240);
4437: l_type_code VARCHAR2(30);

Line 4508: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)

4504: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
4505: ,p_partial_set IN BOOLEAN := FALSE
4506: ,p_sch_action IN VARCHAR2 := NULL
4507: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004
4508: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)
4509:
4510: IS
4511: l_mrp_calc_sd VARCHAR2(240);
4512: l_type_code VARCHAR2(30);

Line 4731: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

4727: We ignore the mandatory components which we passed to MRP
4728: while loading the results.
4729: -------------------------------------------------------------------------- */
4730: Procedure Load_Results_from_rec
4731: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
4732: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
4733: , p_index IN NUMBER := 1
4734: , p_sch_action IN VARCHAR2 := NULL
4735: , p_config_exists IN VARCHAR2 := 'N'

Line 6008: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

6004: Added parameter p_old_line_tbl to support bug 1955004
6005: for call to Inactive_Demand_Scheduling()
6006: -------------------------------------------------------------------------- */
6007: Procedure Load_Results_from_tbl
6008: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
6009: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
6010: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
6011: , p_sch_action IN VARCHAR2 := NULL
6012: , p_partial IN BOOLEAN := FALSE

Line 6422: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ

6418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6419: END Load_Results_from_tbl;
6420:
6421: Procedure Display_Sch_Errors
6422: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
6423: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type
6424: := OE_ORDER_PUB.G_MISS_LINE_TBL
6425: , p_line_id IN NUMBER DEFAULT NULL)
6426:

Line 6623: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

6619:
6620: IS
6621: l_msg_count NUMBER;
6622: l_session_id NUMBER := 0;
6623: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6624: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6625: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6626: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6627: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 6624: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

6620: IS
6621: l_msg_count NUMBER;
6622: l_session_id NUMBER := 0;
6623: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6624: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6625: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6626: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6627: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
6628: l_mrp_msg_data VARCHAR2(200);

Line 6625: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6621: l_msg_count NUMBER;
6622: l_session_id NUMBER := 0;
6623: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6624: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6625: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6626: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6627: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
6628: l_mrp_msg_data VARCHAR2(200);
6629:

Line 6626: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6622: l_session_id NUMBER := 0;
6623: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6624: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6625: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6626: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6627: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
6628: l_mrp_msg_data VARCHAR2(200);
6629:
6630: --

Line 6627: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

6623: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6624: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
6625: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6626: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6627: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
6628: l_mrp_msg_data VARCHAR2(200);
6629:
6630: --
6631: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 6699: MRP_ATP_PUB.Call_ATP

6695: END;
6696: */
6697:
6698:
6699: MRP_ATP_PUB.Call_ATP
6700: ( p_session_id => l_session_id
6701: , p_atp_rec => l_mrp_atp_rec
6702: , x_atp_rec => l_out_mrp_atp_rec
6703: , x_atp_supply_demand => l_atp_supply_demand

Line 6711: oe_debug_pub.add( '3. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

6707: , x_msg_data => l_mrp_msg_data
6708: , x_msg_count => l_msg_count);
6709:
6710: IF l_debug_level > 0 THEN
6711: oe_debug_pub.add( '3. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
6712: END IF;
6713:
6714: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7043: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

7039: IS
7040: l_msg_count NUMBER;
7041: l_mrp_msg_data VARCHAR2(2000);
7042: --l_session_id NUMBER := 0;
7043: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7044: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7045: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7046: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7047: l_on_hand_qty NUMBER;

Line 7044: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

7040: l_msg_count NUMBER;
7041: l_mrp_msg_data VARCHAR2(2000);
7042: --l_session_id NUMBER := 0;
7043: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7044: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7045: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7046: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7047: l_on_hand_qty NUMBER;
7048: l_avail_to_reserve NUMBER;

Line 7045: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

7041: l_mrp_msg_data VARCHAR2(2000);
7042: --l_session_id NUMBER := 0;
7043: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7044: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7045: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7046: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7047: l_on_hand_qty NUMBER;
7048: l_avail_to_reserve NUMBER;
7049: l_on_hand_qty2 NUMBER; -- INVCONV

Line 7046: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

7042: --l_session_id NUMBER := 0;
7043: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7044: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7045: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7046: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7047: l_on_hand_qty NUMBER;
7048: l_avail_to_reserve NUMBER;
7049: l_on_hand_qty2 NUMBER; -- INVCONV
7050: l_avail_to_reserve2 NUMBER; -- INVCONV

Line 7106: MRP_ATP_PUB.Call_ATP

7102: IF l_debug_level > 0 THEN
7103: oe_debug_pub.add('1. Calling MRP API with session id '||l_session_id,0.5); -- debug level changed to 0.5 for bug 13435459
7104: END IF;
7105:
7106: MRP_ATP_PUB.Call_ATP
7107: ( p_session_id => l_session_id
7108: , p_atp_rec => l_mrp_atp_rec
7109: , x_atp_rec => l_mrp_atp_rec
7110: , x_atp_supply_demand => l_atp_supply_demand

Line 7118: oe_debug_pub.add('5. After Calling MRP_ATP_PUB.Call_ATP' ||

7114: , x_msg_data => l_mrp_msg_data
7115: , x_msg_count => l_msg_count);
7116:
7117: IF l_debug_level > 0 THEN
7118: oe_debug_pub.add('5. After Calling MRP_ATP_PUB.Call_ATP' ||
7119: x_return_status,0.5); -- debug level changed to 0.5 for bug 13435459
7120: END IF;
7121: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7437: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

7433:
7434: IS
7435: l_msg_count NUMBER;
7436: --l_session_id NUMBER := 0;
7437: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7438: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7439: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7440: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7441: l_mrp_msg_data VARCHAR2(200);

Line 7438: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

7434: IS
7435: l_msg_count NUMBER;
7436: --l_session_id NUMBER := 0;
7437: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7438: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7439: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7440: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7441: l_mrp_msg_data VARCHAR2(200);
7442: l_old_reserved_quantity NUMBER;

Line 7439: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

7435: l_msg_count NUMBER;
7436: --l_session_id NUMBER := 0;
7437: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7438: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7439: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7440: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7441: l_mrp_msg_data VARCHAR2(200);
7442: l_old_reserved_quantity NUMBER;
7443: l_qty_to_reserve NUMBER;

Line 7440: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

7436: --l_session_id NUMBER := 0;
7437: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7438: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7439: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7440: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7441: l_mrp_msg_data VARCHAR2(200);
7442: l_old_reserved_quantity NUMBER;
7443: l_qty_to_reserve NUMBER;
7444:

Line 7496: MRP_ATP_PUB.Call_ATP

7492: IF l_debug_level > 0 THEn
7493: oe_debug_pub.add('1. Calling MRP API with session id '||l_session_id,0.5); -- debug level changed to 0.5 for bug 13435459
7494: END IF;
7495:
7496: MRP_ATP_PUB.Call_ATP
7497: ( p_session_id => l_session_id
7498: , p_atp_rec => l_mrp_atp_rec
7499: , x_atp_rec => l_mrp_atp_rec
7500: , x_atp_supply_demand => l_atp_supply_demand

Line 7508: oe_debug_pub.add('1. After Calling MRP_ATP_PUB.Call_ATP' ||

7504: , x_msg_data => l_mrp_msg_data
7505: , x_msg_count => l_msg_count);
7506:
7507: IF l_debug_level>0 THEN
7508: oe_debug_pub.add('1. After Calling MRP_ATP_PUB.Call_ATP' ||
7509: x_return_status,0.5); -- debug level changed to 0.5 for bug 13435459
7510: END IF;
7511: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7512: oe_debug_pub.add('Error is' || l_mrp_msg_data,1);

Line 7756: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

7752:
7753: l_msg_count NUMBER;
7754: --l_msg_data VARCHAR2(2000);
7755: --l_session_id NUMBER := 0;
7756: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7757: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7758: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7759: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7760: l_mrp_msg_data VARCHAR2(200);

Line 7757: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

7753: l_msg_count NUMBER;
7754: --l_msg_data VARCHAR2(2000);
7755: --l_session_id NUMBER := 0;
7756: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7757: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7758: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7759: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7760: l_mrp_msg_data VARCHAR2(200);
7761: l_qty_to_unreserve NUMBER;

Line 7758: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

7754: --l_msg_data VARCHAR2(2000);
7755: --l_session_id NUMBER := 0;
7756: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7757: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7758: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7759: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7760: l_mrp_msg_data VARCHAR2(200);
7761: l_qty_to_unreserve NUMBER;
7762: l_qty2_to_unreserve NUMBER; -- INVCONV

Line 7759: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

7755: --l_session_id NUMBER := 0;
7756: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7757: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7758: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7759: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7760: l_mrp_msg_data VARCHAR2(200);
7761: l_qty_to_unreserve NUMBER;
7762: l_qty2_to_unreserve NUMBER; -- INVCONV
7763: --

Line 7824: MRP_ATP_PUB.Call_ATP

7820: IF l_debug_level > 0 THEn
7821: oe_debug_pub.add('1. Calling MRP API with session id '||l_session_id,0.5); -- debug level changed to 0.5 for bug 13435459
7822: END IF;
7823:
7824: MRP_ATP_PUB.Call_ATP
7825: ( p_session_id => l_session_id
7826: , p_atp_rec => l_mrp_atp_rec
7827: , x_atp_rec => l_mrp_atp_rec
7828: , x_atp_supply_demand => l_atp_supply_demand

Line 7835: oe_debug_pub.add('2. After Calling MRP_ATP_PUB.Call_ATP' ||

7831: , x_return_status => x_return_status
7832: , x_msg_data => l_mrp_msg_data
7833: , x_msg_count => l_msg_count);
7834: IF l_debug_level > 0 THEN
7835: oe_debug_pub.add('2. After Calling MRP_ATP_PUB.Call_ATP' ||
7836: x_return_status,0.5); -- debug level changed to 0.5 for bug 13435459
7837: END IF;
7838:
7839: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 7921: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

7917: IS
7918: l_msg_count NUMBER;
7919: l_msg_data VARCHAR2(2000);
7920: l_session_id NUMBER := 0;
7921: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7922: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7923: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7924: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7925: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 7922: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

7918: l_msg_count NUMBER;
7919: l_msg_data VARCHAR2(2000);
7920: l_session_id NUMBER := 0;
7921: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7922: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7923: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7924: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7925: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7926: -- Bug 1955004

Line 7923: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

7919: l_msg_data VARCHAR2(2000);
7920: l_session_id NUMBER := 0;
7921: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7922: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7923: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7924: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7925: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7926: -- Bug 1955004
7927: l_scheduling_level_code VARCHAR2(30);

Line 7924: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

7920: l_session_id NUMBER := 0;
7921: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7922: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7923: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7924: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7925: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7926: -- Bug 1955004
7927: l_scheduling_level_code VARCHAR2(30);
7928:

Line 7925: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

7921: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7922: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
7923: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
7924: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
7925: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
7926: -- Bug 1955004
7927: l_scheduling_level_code VARCHAR2(30);
7928:
7929: --

Line 7984: MRP_ATP_PUB.Call_ATP

7980: IF l_debug_level > 0 THEN
7981: oe_debug_pub.add( '4. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
7982: END IF;
7983:
7984: MRP_ATP_PUB.Call_ATP
7985: ( p_session_id => l_session_id
7986: , p_atp_rec => l_mrp_atp_rec
7987: , x_atp_rec => l_out_mrp_atp_rec
7988: , x_atp_supply_demand => l_atp_supply_demand

Line 7996: oe_debug_pub.add( '4. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || X_RETURN_STATUS , 1 ) ;

7992: , x_msg_data => l_msg_data
7993: , x_msg_count => l_msg_count);
7994:
7995: IF l_debug_level > 0 THEN
7996: oe_debug_pub.add( '4. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || X_RETURN_STATUS , 1 ) ;
7997: END IF;
7998:
7999: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 14029: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

14025: IS
14026: l_msg_count NUMBER;
14027: l_mrp_msg_data VARCHAR2(2000);
14028: l_session_id NUMBER := 0;
14029: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14030: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14031: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14032: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14033: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 14030: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

14026: l_msg_count NUMBER;
14027: l_mrp_msg_data VARCHAR2(2000);
14028: l_session_id NUMBER := 0;
14029: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14030: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14031: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14032: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14033: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14034: l_on_hand_qty NUMBER;

Line 14031: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

14027: l_mrp_msg_data VARCHAR2(2000);
14028: l_session_id NUMBER := 0;
14029: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14030: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14031: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14032: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14033: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14034: l_on_hand_qty NUMBER;
14035: l_avail_to_reserve NUMBER;

Line 14032: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

14028: l_session_id NUMBER := 0;
14029: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14030: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14031: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14032: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14033: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14034: l_on_hand_qty NUMBER;
14035: l_avail_to_reserve NUMBER;
14036: l_on_hand_qty2 NUMBER; -- INVCONV

Line 14033: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

14029: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14030: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14031: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14032: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14033: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14034: l_on_hand_qty NUMBER;
14035: l_avail_to_reserve NUMBER;
14036: l_on_hand_qty2 NUMBER; -- INVCONV
14037: l_avail_to_reserve2 NUMBER; -- invconv

Line 14088: MRP_ATP_PUB.Call_ATP

14084: IF l_debug_level > 0 THEN
14085: oe_debug_pub.add( 'CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
14086: END IF;
14087:
14088: MRP_ATP_PUB.Call_ATP
14089: ( p_session_id => l_session_id
14090: , p_atp_rec => l_mrp_atp_rec
14091: , x_atp_rec => l_out_mrp_atp_rec
14092: , x_atp_supply_demand => l_atp_supply_demand

Line 14100: oe_debug_pub.add( ' AFTER CALLING MRP_ATP_PUB.CALL_ATP ' || X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

14096: , x_msg_data => l_mrp_msg_data
14097: , x_msg_count => l_msg_count);
14098:
14099: IF l_debug_level > 0 THEN
14100: oe_debug_pub.add( ' AFTER CALLING MRP_ATP_PUB.CALL_ATP ' || X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
14101: END IF;
14102:
14103: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
14104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 14888: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

14884: l_entity VARCHAR2(30);
14885:
14886: -- MRP API variables
14887: l_session_id NUMBER := 0;
14888: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14889: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14890: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14891: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14892: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 14889: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

14885:
14886: -- MRP API variables
14887: l_session_id NUMBER := 0;
14888: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14889: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14890: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14891: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14892: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14893: mrp_msg_data VARCHAR2(200);

Line 14890: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

14886: -- MRP API variables
14887: l_session_id NUMBER := 0;
14888: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14889: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14890: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14891: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14892: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14893: mrp_msg_data VARCHAR2(200);
14894: l_on_hand_qty NUMBER;

Line 14891: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

14887: l_session_id NUMBER := 0;
14888: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14889: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14890: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14891: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14892: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14893: mrp_msg_data VARCHAR2(200);
14894: l_on_hand_qty NUMBER;
14895: l_avail_to_reserve NUMBER;

Line 14892: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

14888: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14889: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
14890: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
14891: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
14892: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
14893: mrp_msg_data VARCHAR2(200);
14894: l_on_hand_qty NUMBER;
14895: l_avail_to_reserve NUMBER;
14896: l_out_atp_tbl OE_ATP.atp_tbl_type;

Line 15482: MRP_ATP_PUB.Call_ATP

15478: IF l_debug_level > 0 THEN
15479: oe_debug_pub.add( 'SPLIT CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
15480: END IF;
15481:
15482: MRP_ATP_PUB.Call_ATP
15483: ( p_session_id => l_session_id
15484: , p_atp_rec => l_mrp_atp_rec
15485: , x_atp_rec => l_out_mtp_atp_rec
15486: , x_atp_supply_demand => l_atp_supply_demand

Line 15495: oe_debug_pub.add( 'SPLIT. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS ,0.5 ) ; -- debug level changed to 0.5 for bug 13435459

15491: , x_msg_count => l_msg_count);
15492:
15493:
15494: IF l_debug_level > 0 THEN
15495: oe_debug_pub.add( 'SPLIT. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS ,0.5 ) ; -- debug level changed to 0.5 for bug 13435459
15496: END IF;
15497:
15498: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 18306: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

18302:
18303: IS
18304: l_msg_count NUMBER;
18305: l_session_id NUMBER := 0;
18306: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18307: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18308: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18309: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18310: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 18307: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

18303: IS
18304: l_msg_count NUMBER;
18305: l_session_id NUMBER := 0;
18306: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18307: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18308: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18309: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18310: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18311: l_mrp_msg_data VARCHAR2(200);

Line 18308: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

18304: l_msg_count NUMBER;
18305: l_session_id NUMBER := 0;
18306: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18307: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18308: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18309: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18310: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18311: l_mrp_msg_data VARCHAR2(200);
18312: l_old_line_rec OE_Order_Pub.Line_Rec_Type;

Line 18309: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

18305: l_session_id NUMBER := 0;
18306: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18307: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18308: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18309: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18310: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18311: l_mrp_msg_data VARCHAR2(200);
18312: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
18313: l_new_line_rec OE_Order_Pub.Line_Rec_Type;

Line 18310: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

18306: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18307: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18308: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18309: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18310: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18311: l_mrp_msg_data VARCHAR2(200);
18312: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
18313: l_new_line_rec OE_Order_Pub.Line_Rec_Type;
18314:

Line 18345: MRP_ATP_PUB.Call_ATP

18341: IF l_debug_level > 0 THEN
18342: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
18343: END IF;
18344:
18345: MRP_ATP_PUB.Call_ATP
18346: ( p_session_id => l_session_id
18347: , p_atp_rec => l_mrp_atp_rec
18348: , x_atp_rec => l_out_mrp_atp_rec
18349: , x_atp_supply_demand => l_atp_supply_demand

Line 18357: oe_debug_pub.add( '3. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

18353: , x_msg_data => l_mrp_msg_data
18354: , x_msg_count => l_msg_count);
18355:
18356: IF l_debug_level > 0 THEN
18357: oe_debug_pub.add( '3. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
18358: END IF;
18359:
18360: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
18361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 18421: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

18417:
18418: IS
18419: l_msg_count NUMBER;
18420: l_session_id NUMBER := 0;
18421: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18422: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18423: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18424: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18425: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 18422: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

18418: IS
18419: l_msg_count NUMBER;
18420: l_session_id NUMBER := 0;
18421: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18422: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18423: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18424: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18425: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18426: l_mrp_msg_data VARCHAR2(200);

Line 18423: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

18419: l_msg_count NUMBER;
18420: l_session_id NUMBER := 0;
18421: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18422: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18423: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18424: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18425: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18426: l_mrp_msg_data VARCHAR2(200);
18427: l_old_line_rec OE_Order_Pub.Line_Rec_Type;

Line 18424: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

18420: l_session_id NUMBER := 0;
18421: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18422: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18423: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18424: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18425: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18426: l_mrp_msg_data VARCHAR2(200);
18427: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
18428: l_new_line_rec OE_Order_Pub.Line_Rec_Type;

Line 18425: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

18421: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18422: l_out_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
18423: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18424: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18425: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18426: l_mrp_msg_data VARCHAR2(200);
18427: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
18428: l_new_line_rec OE_Order_Pub.Line_Rec_Type;
18429:

Line 18459: MRP_ATP_PUB.Call_ATP

18455: IF l_debug_level > 0 THEN
18456: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
18457: END IF;
18458:
18459: MRP_ATP_PUB.Call_ATP
18460: ( p_session_id => l_session_id
18461: , p_atp_rec => l_mrp_atp_rec
18462: , x_atp_rec => l_out_mrp_atp_rec
18463: , x_atp_supply_demand => l_atp_supply_demand

Line 18471: oe_debug_pub.add( '3. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

18467: , x_msg_data => l_mrp_msg_data
18468: , x_msg_count => l_msg_count);
18469:
18470: IF l_debug_level > 0 THEN
18471: oe_debug_pub.add( '3. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
18472: END IF;
18473:
18474: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
18475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;