eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_SCHEDULE_UTIL dependencies on OE_ORDER_PUB

Line 289: l_model_line_rec OE_ORDER_PUB.line_rec_type;

285: x_return_status OUT NOCOPY VARCHAR2
286:
287: )
288: IS
289: l_model_line_rec OE_ORDER_PUB.line_rec_type;
290: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
291: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
292: l_ship_set VARCHAR2(30);
293: lTableName VARCHAR2(30);

Line 834: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

830: Description : This API calls Inventory's APIs to reserve.
831: --------------------------------------------------------------------- */
832:
833: Procedure Reserve_line
834: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
835: ,p_quantity_to_reserve IN NUMBER
836: ,p_quantity2_to_reserve IN NUMBER DEFAULT NULL -- INVCONV
837: ,p_rsv_update IN BOOLEAN DEFAULT FALSE
838: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1071: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

1067: is satisfied.
1068: --------------------------------------------------------------------- */
1069:
1070: Procedure Unreserve_Line
1071: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
1072: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 6628134
1073: ,p_quantity_to_unreserve IN NUMBER
1074: ,p_quantity2_to_unreserve IN NUMBER DEFAULT NULL -- INVCONV
1075: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1385: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,

1381: Other wise log a schedule or reschedule delayed request.
1382:
1383: -------------------------------------------------------------------------*/
1384: Procedure Log_Set_Request
1385: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,
1386: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type,
1387: p_sch_action IN VARCHAR2,
1388: p_caller IN VARCHAR2,
1389: x_return_status OUT NOCOPY VARCHAR2)

Line 1386: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type,

1382:
1383: -------------------------------------------------------------------------*/
1384: Procedure Log_Set_Request
1385: (p_line_rec IN OE_ORDER_PUB.Line_rec_type,
1386: p_old_line_rec IN OE_ORDER_PUB.Line_rec_type,
1387: p_sch_action IN VARCHAR2,
1388: p_caller IN VARCHAR2,
1389: x_return_status OUT NOCOPY VARCHAR2)
1390:

Line 2066: ( p_line_rec IN Oe_Order_Pub.line_rec_type

2062: ----------------------------------------------------------------------------- */
2063:
2064:
2065: FUNCTION Schedule_Attribute_Changed
2066: ( p_line_rec IN Oe_Order_Pub.line_rec_type
2067: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
2068: RETURN BOOLEAN
2069: IS
2070: --

Line 2067: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)

2063:
2064:
2065: FUNCTION Schedule_Attribute_Changed
2066: ( p_line_rec IN Oe_Order_Pub.line_rec_type
2067: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
2068: RETURN BOOLEAN
2069: IS
2070: --
2071: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2178: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type

2174: fields - schedule_ship_date, schedule_arrival_date,
2175: visible_demand_flag, and schedule_status_code.
2176: ------------------------------------------------------------------------*/
2177: PROCEDURE Inactive_Demand_Scheduling
2178: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type
2179: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
2180: , p_sch_action IN VARCHAR2 := NULL
2181: , x_return_status OUT NOCOPY VARCHAR2
2182:

Line 2179: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

2175: visible_demand_flag, and schedule_status_code.
2176: ------------------------------------------------------------------------*/
2177: PROCEDURE Inactive_Demand_Scheduling
2178: ( p_x_old_line_rec IN OE_ORDER_PUB.line_rec_type
2179: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
2180: , p_sch_action IN VARCHAR2 := NULL
2181: , x_return_status OUT NOCOPY VARCHAR2
2182:
2183: ) IS

Line 2518: ( p_line_rec IN OE_ORDER_PUB.line_rec_type

2514: CTO's GET_MANDATORY_COMPONENTS API to get the mandatory
2515: components, and we pass them along with the ATO model to MRP.
2516: -------------------------------------------------------------------- */
2517: Procedure Load_MRP_request
2518: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
2519: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
2520: ,p_sch_action IN VARCHAR2 := NULL
2521: ,p_mrp_calc_sd IN VARCHAR2
2522: ,p_type_code IN VARCHAR2

Line 2519: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

2515: components, and we pass them along with the ATO model to MRP.
2516: -------------------------------------------------------------------- */
2517: Procedure Load_MRP_request
2518: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
2519: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
2520: ,p_sch_action IN VARCHAR2 := NULL
2521: ,p_mrp_calc_sd IN VARCHAR2
2522: ,p_type_code IN VARCHAR2
2523: ,p_order_number IN NUMBER

Line 3524: ( p_line_rec IN OE_ORDER_PUB.Line_rec_Type

3520: CTO's GET_MANDATORY_COMPONENTS API to get the mandatory
3521: components, and we pass them along with the ATO model to MRP.
3522: -------------------------------------------------------------------- */
3523: Procedure Load_MRP_request_from_rec
3524: ( p_line_rec IN OE_ORDER_PUB.Line_rec_Type
3525: ,p_old_line_rec IN OE_ORDER_PUB.Line_rec_Type
3526: ,p_sch_action IN VARCHAR2 := NULL
3527: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)
3528:

Line 3525: ,p_old_line_rec IN OE_ORDER_PUB.Line_rec_Type

3521: components, and we pass them along with the ATO model to MRP.
3522: -------------------------------------------------------------------- */
3523: Procedure Load_MRP_request_from_rec
3524: ( p_line_rec IN OE_ORDER_PUB.Line_rec_Type
3525: ,p_old_line_rec IN OE_ORDER_PUB.Line_rec_Type
3526: ,p_sch_action IN VARCHAR2 := NULL
3527: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)
3528:
3529: IS

Line 3597: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

3593: components, and we pass them along with the ATO model to MRP.
3594:
3595: -------------------------------------------------------------------- */
3596: Procedure Load_MRP_request_from_tbl
3597: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
3598: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
3599: ,p_partial_set IN BOOLEAN := FALSE
3600: ,p_sch_action IN VARCHAR2 := NULL
3601: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004

Line 3598: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type

3594:
3595: -------------------------------------------------------------------- */
3596: Procedure Load_MRP_request_from_tbl
3597: ( p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
3598: ,p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
3599: ,p_partial_set IN BOOLEAN := FALSE
3600: ,p_sch_action IN VARCHAR2 := NULL
3601: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004
3602: ,x_mrp_atp_rec OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ)

Line 3813: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

3809: while loading the results.
3810: -------------------------------------------------------------------------- */
3811: Procedure Load_Results_from_rec
3812: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
3813: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3814: , p_index IN NUMBER := 1
3815: , p_sch_action IN VARCHAR2 := NULL
3816: , p_config_exists IN VARCHAR2 := 'N'
3817: , p_partial_set IN BOOLEAN := FALSE

Line 4943: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type

4939: for call to Inactive_Demand_Scheduling()
4940: -------------------------------------------------------------------------- */
4941: Procedure Load_Results_from_tbl
4942: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
4943: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
4944: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
4945: , p_sch_action IN VARCHAR2 := NULL
4946: , p_partial IN BOOLEAN := FALSE
4947: , p_partial_set IN BOOLEAN := FALSE

Line 4944: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

4940: -------------------------------------------------------------------------- */
4941: Procedure Load_Results_from_tbl
4942: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
4943: , p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
4944: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
4945: , p_sch_action IN VARCHAR2 := NULL
4946: , p_partial IN BOOLEAN := FALSE
4947: , p_partial_set IN BOOLEAN := FALSE
4948: , x_return_status OUT NOCOPY VARCHAR2)

Line 5343: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type

5339: END Load_Results_from_tbl;
5340:
5341: Procedure Display_Sch_Errors
5342: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
5343: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type
5344: := OE_ORDER_PUB.G_MISS_LINE_TBL
5345: , p_line_id IN NUMBER DEFAULT NULL)
5346:
5347: IS

Line 5344: := OE_ORDER_PUB.G_MISS_LINE_TBL

5340:
5341: Procedure Display_Sch_Errors
5342: ( p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ
5343: , p_line_tbl IN OE_ORDER_PUB.line_tbl_type
5344: := OE_ORDER_PUB.G_MISS_LINE_TBL
5345: , p_line_id IN NUMBER DEFAULT NULL)
5346:
5347: IS
5348:

Line 5536: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

5532: Description : Create and call MRP API.
5533: --------------------------------------------------------------------- */
5534:
5535: Procedure Call_MRP_ATP
5536: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
5537: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
5538: ,x_return_status OUT NOCOPY VARCHAR2)
5539:
5540: IS

Line 5537: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

5533: --------------------------------------------------------------------- */
5534:
5535: Procedure Call_MRP_ATP
5536: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
5537: ,p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
5538: ,x_return_status OUT NOCOPY VARCHAR2)
5539:
5540: IS
5541: l_msg_count NUMBER;

Line 5678: (p_line_rec IN OE_ORDER_PUB.line_rec_type)

5674: END IF;
5675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5676: END Call_MRP_ATP;
5677: PROCEDURE Cascade_Override_atp
5678: (p_line_rec IN OE_ORDER_PUB.line_rec_type)
5679: IS
5680: --
5681: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5682: --

Line 5953: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

5949: Description : This procedure is called to perform atp_check on a single
5950: line
5951: --------------------------------------------------------------------- */
5952: Procedure Action_ATP
5953: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
5954: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
5955: x_return_status OUT NOCOPY VARCHAR2)
5956:
5957: IS

Line 5954: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

5950: line
5951: --------------------------------------------------------------------- */
5952: Procedure Action_ATP
5953: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
5954: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
5955: x_return_status OUT NOCOPY VARCHAR2)
5956:
5957: IS
5958: l_msg_count NUMBER;

Line 6160: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

6156: Description : This procedure is called from Process_Request proecudure
6157: to perform the action of SCHEDULE or RESERVE on the line.
6158: --------------------------------------------------------------------- */
6159: Procedure Action_Schedule
6160: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
6161: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6162: p_sch_action IN VARCHAR2,
6163: p_qty_to_reserve IN NUMBER := Null,
6164: x_return_status OUT NOCOPY VARCHAR2)

Line 6161: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

6157: to perform the action of SCHEDULE or RESERVE on the line.
6158: --------------------------------------------------------------------- */
6159: Procedure Action_Schedule
6160: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
6161: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6162: p_sch_action IN VARCHAR2,
6163: p_qty_to_reserve IN NUMBER := Null,
6164: x_return_status OUT NOCOPY VARCHAR2)
6165:

Line 6467: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

6463: to perform the action of UNSCHEDULE or UNRESERVE on the line.
6464: --------------------------------------------------------------------- */
6465:
6466: Procedure Action_UnSchedule
6467: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6468: p_sch_action IN VARCHAR2,
6469: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
6470: x_return_status OUT NOCOPY VARCHAR2)
6471:

Line 6469: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

6465:
6466: Procedure Action_UnSchedule
6467: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6468: p_sch_action IN VARCHAR2,
6469: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
6470: x_return_status OUT NOCOPY VARCHAR2)
6471:
6472: IS
6473:

Line 6632: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

6628: to perform the UNDEMAD on the line when an item is changed.
6629: --------------------------------------------------------------------- */
6630:
6631: Procedure Action_Undemand
6632: (p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6633: x_return_status OUT NOCOPY VARCHAR2)
6634:
6635:
6636: IS

Line 6756: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

6752: Procedure Name : Action_Reserve
6753: Description : This procedure is called from Process_Request proecudure
6754: --------------------------------------------------------------------- */
6755: Procedure Action_Reserve
6756: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
6757: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6758: x_return_status OUT NOCOPY VARCHAR2)
6759:
6760: IS

Line 6757: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

6753: Description : This procedure is called from Process_Request proecudure
6754: --------------------------------------------------------------------- */
6755: Procedure Action_Reserve
6756: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
6757: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6758: x_return_status OUT NOCOPY VARCHAR2)
6759:
6760: IS
6761: l_old_reserved_qty NUMBER :=nvl(p_old_line_rec.reserved_quantity,0);

Line 6974: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

6970: Procedure Name : Action_Reschedule
6971: Description : This procedure is called from Process_Request proecudure
6972: --------------------------------------------------------------------- */
6973: Procedure Action_Reschedule
6974: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
6975: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6976: x_return_status OUT NOCOPY VARCHAR2,
6977:
6978: x_reserve_later OUT NOCOPY VARCHAR2)

Line 6975: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

6971: Description : This procedure is called from Process_Request proecudure
6972: --------------------------------------------------------------------- */
6973: Procedure Action_Reschedule
6974: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
6975: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
6976: x_return_status OUT NOCOPY VARCHAR2,
6977:
6978: x_reserve_later OUT NOCOPY VARCHAR2)
6979:

Line 7651: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

7647: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
7648: as the identifier.
7649: ----------------------------------------------------------------------------- */
7650: Procedure Load_INV_Request
7651: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
7652: , p_quantity_to_reserve IN NUMBER
7653: , p_quantity2_to_reserve IN NUMBER DEFAULT NULL
7654: , x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
7655:

Line 7876: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)

7872: /*---------------------------------------------------------------
7873: Handle_External_Lines
7874: ----------------------------------------------------------------*/
7875: PROCEDURE Handle_External_Lines
7876: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7877: IS
7878:
7879: l_line_tbl OE_ORDER_PUB.line_tbl_type;
7880: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 7879: l_line_tbl OE_ORDER_PUB.line_tbl_type;

7875: PROCEDURE Handle_External_Lines
7876: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7877: IS
7878:
7879: l_line_tbl OE_ORDER_PUB.line_tbl_type;
7880: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
7881: l_line_rec OE_ORDER_PUB.line_rec_type
7882: := OE_Order_Pub.G_MISS_LINE_REC;
7883: l_control_rec OE_GLOBALS.control_rec_type;

Line 7880: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

7876: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7877: IS
7878:
7879: l_line_tbl OE_ORDER_PUB.line_tbl_type;
7880: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
7881: l_line_rec OE_ORDER_PUB.line_rec_type
7882: := OE_Order_Pub.G_MISS_LINE_REC;
7883: l_control_rec OE_GLOBALS.control_rec_type;
7884: l_index NUMBER;

Line 7881: l_line_rec OE_ORDER_PUB.line_rec_type

7877: IS
7878:
7879: l_line_tbl OE_ORDER_PUB.line_tbl_type;
7880: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
7881: l_line_rec OE_ORDER_PUB.line_rec_type
7882: := OE_Order_Pub.G_MISS_LINE_REC;
7883: l_control_rec OE_GLOBALS.control_rec_type;
7884: l_index NUMBER;
7885: l_return_status VARCHAR2(1);

Line 7882: := OE_Order_Pub.G_MISS_LINE_REC;

7878:
7879: l_line_tbl OE_ORDER_PUB.line_tbl_type;
7880: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
7881: l_line_rec OE_ORDER_PUB.line_rec_type
7882: := OE_Order_Pub.G_MISS_LINE_REC;
7883: l_control_rec OE_GLOBALS.control_rec_type;
7884: l_index NUMBER;
7885: l_return_status VARCHAR2(1);
7886:

Line 8034: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

8030:
8031: Added new call to Handle_External_Lines for config dropshipments.
8032: -----------------------------------------------------------------*/
8033: Procedure Schedule_line
8034: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
8035: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
8036: p_caller IN VARCHAR2 := SCH_INTERNAL,
8037: x_return_status OUT NOCOPY VARCHAR2 )
8038:

Line 8035: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

8031: Added new call to Handle_External_Lines for config dropshipments.
8032: -----------------------------------------------------------------*/
8033: Procedure Schedule_line
8034: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
8035: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
8036: p_caller IN VARCHAR2 := SCH_INTERNAL,
8037: x_return_status OUT NOCOPY VARCHAR2 )
8038:
8039: IS

Line 8040: l_old_line_rec OE_ORDER_PUB.line_rec_type;

8036: p_caller IN VARCHAR2 := SCH_INTERNAL,
8037: x_return_status OUT NOCOPY VARCHAR2 )
8038:
8039: IS
8040: l_old_line_rec OE_ORDER_PUB.line_rec_type;
8041: l_sales_order_id NUMBER;
8042: l_need_sch BOOLEAN;
8043: l_line_action VARCHAR2(30) := Null;
8044: l_auto_sch VARCHAR2(1) := Null;

Line 8707: (p_line_rec IN OE_ORDER_PUB.line_rec_type,

8703: -- we will not do scheduling for lines with source_type=EXTERNAL
8704: -- We should not perform scheduling if the line is already scheduled
8705: --------------------------------------------------------------------- */
8706: FUNCTION Need_Scheduling
8707: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
8708: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
8709: x_line_action OUT NOCOPY VARCHAR2,
8710:
8711: x_auto_sch OUT NOCOPY VARCHAR2

Line 8708: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

8704: -- We should not perform scheduling if the line is already scheduled
8705: --------------------------------------------------------------------- */
8706: FUNCTION Need_Scheduling
8707: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
8708: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
8709: x_line_action OUT NOCOPY VARCHAR2,
8710:
8711: x_auto_sch OUT NOCOPY VARCHAR2
8712:

Line 9327: (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

9323: we will perform scheduling on lines on hold. If it is
9324: set to 'N', we will not perform scheduling.
9325: --------------------------------------------------------------------- */
9326: Procedure Validate_Line
9327: (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
9328: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
9329: p_sch_action IN VARCHAR2,
9330: p_caller IN VARCHAR2 := SCH_EXTERNAL,
9331: x_return_status OUT NOCOPY VARCHAR2)

Line 9328: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

9324: set to 'N', we will not perform scheduling.
9325: --------------------------------------------------------------------- */
9326: Procedure Validate_Line
9327: (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
9328: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
9329: p_sch_action IN VARCHAR2,
9330: p_caller IN VARCHAR2 := SCH_EXTERNAL,
9331: x_return_status OUT NOCOPY VARCHAR2)
9332:

Line 10559: Procedure Process_request(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

10555: or it could be just a simple standard line which does not
10556: belong to any set.
10557:
10558: --------------------------------------------------------------------- */
10559: Procedure Process_request(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
10560: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
10561: p_caller IN VARCHAR2,
10562: p_sch_action IN VARCHAR2,
10563: x_return_status OUT NOCOPY VARCHAR2)

Line 10560: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

10556: belong to any set.
10557:
10558: --------------------------------------------------------------------- */
10559: Procedure Process_request(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
10560: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
10561: p_caller IN VARCHAR2,
10562: p_sch_action IN VARCHAR2,
10563: x_return_status OUT NOCOPY VARCHAR2)
10564:

Line 10567: l_orig_line_rec OE_ORDER_PUB.line_rec_type;

10563: x_return_status OUT NOCOPY VARCHAR2)
10564:
10565: IS
10566: l_update_flag VARCHAR2(1):= FND_API.G_TRUE;
10567: l_orig_line_rec OE_ORDER_PUB.line_rec_type;
10568: l_reserve_later VARCHAR2(1) := 'N';
10569: l_qty_to_reserve NUMBER;
10570: l_qty2_to_reserve NUMBER; -- INVCONV
10571: --

Line 11247: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)

11243: SEGMENT3 : stores the ont_source_code value
11244:
11245: -------------------------------------------------------------------------- */
11246: Procedure Insert_Into_Mtl_Sales_Orders
11247: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)
11248: IS
11249: l_order_type_name VARCHAR2(80);
11250: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
11251: l_sales_order_id NUMBER;

Line 11362: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

11358: on the line and the result needs to be verified and/or
11359: updated to the database.
11360: --------------------------------------------------------------------- */
11361: Procedure call_process_order
11362: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
11363: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
11364: , p_control_rec IN OE_GLOBALS.control_rec_type
11365: , p_caller IN VARCHAR2
11366: , x_return_status OUT NOCOPY VARCHAR2)

Line 11363: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

11359: updated to the database.
11360: --------------------------------------------------------------------- */
11361: Procedure call_process_order
11362: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
11363: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
11364: , p_control_rec IN OE_GLOBALS.control_rec_type
11365: , p_caller IN VARCHAR2
11366: , x_return_status OUT NOCOPY VARCHAR2)
11367:

Line 11476: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

11472: on the line and the result needs to be verified and/or
11473: updated to the database.
11474: --------------------------------------------------------------------- */
11475: Procedure Process_Group_of_Lines
11476: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
11477: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
11478: , p_caller IN VARCHAR2
11479: , x_return_status OUT NOCOPY VARCHAR2)
11480:

Line 11477: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

11473: updated to the database.
11474: --------------------------------------------------------------------- */
11475: Procedure Process_Group_of_Lines
11476: ( p_x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
11477: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
11478: , p_caller IN VARCHAR2
11479: , x_return_status OUT NOCOPY VARCHAR2)
11480:
11481: IS

Line 11753: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

11749: either call process order or do a direct update.
11750: p_call_prn is call process_request and notify.
11751: --------------------------------------------------------------------- */
11752: Procedure Process_Line
11753: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
11754: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
11755: , p_caller IN VARCHAR2
11756: , p_call_prn IN BOOLEAN := TRUE
11757: , x_return_status OUT NOCOPY VARCHAR2)

Line 11754: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

11750: p_call_prn is call process_request and notify.
11751: --------------------------------------------------------------------- */
11752: Procedure Process_Line
11753: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
11754: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
11755: , p_caller IN VARCHAR2
11756: , p_call_prn IN BOOLEAN := TRUE
11757: , x_return_status OUT NOCOPY VARCHAR2)
11758:

Line 11761: l_line_tbl OE_ORDER_PUB.line_tbl_type;

11757: , x_return_status OUT NOCOPY VARCHAR2)
11758:
11759: IS
11760: l_process_requests BOOLEAN;
11761: l_line_tbl OE_ORDER_PUB.line_tbl_type;
11762: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
11763: l_sec_result NUMBER;
11764: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
11765: l_control_rec OE_GLOBALS.control_rec_type;

Line 11762: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

11758:
11759: IS
11760: l_process_requests BOOLEAN;
11761: l_line_tbl OE_ORDER_PUB.line_tbl_type;
11762: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
11763: l_sec_result NUMBER;
11764: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
11765: l_control_rec OE_GLOBALS.control_rec_type;
11766: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 12288: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

12284: PROCEDURE ATP_Check
12285:
12286: --------------------------------------------------------*/
12287: Procedure ATP_Check
12288: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
12289: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
12290: p_validate IN VARCHAR2 := FND_API.G_TRUE,
12291: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
12292:

Line 12289: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

12285:
12286: --------------------------------------------------------*/
12287: Procedure ATP_Check
12288: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
12289: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
12290: p_validate IN VARCHAR2 := FND_API.G_TRUE,
12291: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
12292:
12293: x_return_status OUT NOCOPY VARCHAR2

Line 12409: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,

12405: PROCEDURE Multi_ATP_Check
12406:
12407: --------------------------------------------------------*/
12408: PROCEDURE Multi_ATP_Check
12409: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
12410: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
12411: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
12412:
12413: x_return_status OUT NOCOPY VARCHAR2

Line 12410: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

12406:
12407: --------------------------------------------------------*/
12408: PROCEDURE Multi_ATP_Check
12409: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
12410: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
12411: x_atp_tbl OUT NOCOPY OE_ATP.atp_tbl_type,
12412:
12413: x_return_status OUT NOCOPY VARCHAR2
12414:

Line 12633: l_line_rec OE_ORDER_PUB.line_rec_type;

12629: END Multi_ATP_Check;
12630:
12631: Procedure Delete_Row(p_line_id IN NUMBER)
12632: IS
12633: l_line_rec OE_ORDER_PUB.line_rec_type;
12634: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12635: l_sales_order_id NUMBER;
12636: l_ato_exists VARCHAR2(1);
12637: l_request_search_rslt BOOLEAN;

Line 12993: FUNCTION Find_line( p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

12989: /* Function find line
12990:
12991: This is be used to find the line in the pl/sql table.
12992: */
12993: FUNCTION Find_line( p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
12994: p_line_id IN NUMBER)
12995: Return BOOLEAN
12996: IS
12997: --

Line 13029: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

13025: If the ato model is part of set, then whole set information will
13026: be passed to MRP and so on */
13027:
13028: PROCEDURE PROCESS_SPLIT
13029: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
13030: x_return_status OUT NOCOPY VARCHAR2)
13031:
13032: IS
13033: l_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 13033: l_line_tbl OE_ORDER_PUB.line_tbl_type;

13029: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
13030: x_return_status OUT NOCOPY VARCHAR2)
13031:
13032: IS
13033: l_line_tbl OE_ORDER_PUB.line_tbl_type;
13034: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
13035: K NUMBER;
13036: I NUMBER;
13037: l_ato_line_id NUMBER;

Line 13034: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;

13030: x_return_status OUT NOCOPY VARCHAR2)
13031:
13032: IS
13033: l_line_tbl OE_ORDER_PUB.line_tbl_type;
13034: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
13035: K NUMBER;
13036: I NUMBER;
13037: l_ato_line_id NUMBER;
13038: l_entity VARCHAR2(30);

Line 13304: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

13300: ---------------------------------------------------------------------- */
13301:
13302:
13303: Procedure SPLIT_SCHEDULING
13304: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
13305: , x_return_status OUT NOCOPY VARCHAR2)
13306:
13307: IS
13308: l_rsv_qty NUMBER := 0;

Line 13882: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type

13878:
13879:
13880: -------------------------------------------------------------*/
13881: Procedure Schedule_Split_Lines
13882: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
13883: , x_return_status OUT NOCOPY VARCHAR2)
13884: IS
13885: l_line_tbl OE_ORDER_PUB.line_Tbl_Type;
13886: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

Line 13885: l_line_tbl OE_ORDER_PUB.line_Tbl_Type;

13881: Procedure Schedule_Split_Lines
13882: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
13883: , x_return_status OUT NOCOPY VARCHAR2)
13884: IS
13885: l_line_tbl OE_ORDER_PUB.line_Tbl_Type;
13886: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
13887: BEGIN
13888:
13889: oe_debug_pub.add('Entering Schedule_Split_Lines',1);

Line 13886: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

13882: ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
13883: , x_return_status OUT NOCOPY VARCHAR2)
13884: IS
13885: l_line_tbl OE_ORDER_PUB.line_Tbl_Type;
13886: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
13887: BEGIN
13888:
13889: oe_debug_pub.add('Entering Schedule_Split_Lines',1);
13890:

Line 13973: l_line_rec OE_ORDER_PUB.line_rec_type;

13969: , x_return_status OUT NOCOPY VARCHAR2)
13970:
13971: IS
13972: /*
13973: l_line_rec OE_ORDER_PUB.line_rec_type;
13974: I NUMBER;
13975: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13976: l_msg_count NUMBER := 0;
13977: l_msg_data VARCHAR2(2000) := null;

Line 13979: l_line_tbl OE_ORDER_PUB.line_tbl_type;

13975: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13976: l_msg_count NUMBER := 0;
13977: l_msg_data VARCHAR2(2000) := null;
13978: l_control_rec OE_GLOBALS.control_rec_type;
13979: l_line_tbl OE_ORDER_PUB.line_tbl_type;
13980: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
13981: l_file_val VARCHAR2(80);
13982: */
13983: --

Line 13980: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

13976: l_msg_count NUMBER := 0;
13977: l_msg_data VARCHAR2(2000) := null;
13978: l_control_rec OE_GLOBALS.control_rec_type;
13979: l_line_tbl OE_ORDER_PUB.line_tbl_type;
13980: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
13981: l_file_val VARCHAR2(80);
13982: */
13983: --
13984: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 14028: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;

14024: IF l_debug_level > 0 THEN
14025: oe_debug_pub.add( 'RR: SCHEDULE_SHIP_DATE ' || P_MRP_LINE_TBL ( I ) .SCHEDULE_SHIP_DATE , 1 ) ;
14026: END IF;
14027:
14028: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
14029: l_line_rec.line_id := p_mrp_line_tbl(I).line_id;
14030: l_line_rec.schedule_ship_date :=
14031: p_mrp_line_tbl(I).schedule_ship_date;
14032: l_line_rec.schedule_arrival_date :=

Line 14483: PROCEDURE Do_Unreserve (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

14479: END IF;
14480: RETURN (FALSE);
14481: END Get_Pick_Status;
14482:
14483: PROCEDURE Do_Unreserve (p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
14484: ,p_quantity_to_unreserve IN NUMBER
14485: ,p_quantity2_to_unreserve IN NUMBER -- INVCONV
14486: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 5024936
14487: ,x_return_status OUT NOCOPY VARCHAR2)

Line 14791: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,

14787: date type code and scheduling action sets the promise date
14788: with schedule ship date/schedule arrival date.
14789: -------------------------------------------------------------------------- */
14790: PROCEDURE Promise_Date_for_Sch_Action
14791: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type,
14792: p_sch_action IN VARCHAR2,
14793: P_header_id IN NUMBER DEFAULT NULL)
14794: IS
14795: CURSOR order_header_id IS

Line 15642: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

15638: END Global_ATP;
15639:
15640:
15641: Procedure Cascade_Ship_Set_Attr
15642: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
15643: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
15644: IS
15645:
15646: l_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 15646: l_line_tbl OE_ORDER_PUB.line_tbl_type;

15642: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
15643: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
15644: IS
15645:
15646: l_line_tbl OE_ORDER_PUB.line_tbl_type;
15647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
15648: l_control_rec OE_GLOBALS.control_rec_type;
15649: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15650: --

Line 15647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

15643: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
15644: IS
15645:
15646: l_line_tbl OE_ORDER_PUB.line_tbl_type;
15647: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
15648: l_control_rec OE_GLOBALS.control_rec_type;
15649: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15650: --
15651: l_msg_count NUMBER;

Line 15763: l_old_line_rec OE_Order_Pub.Line_Rec_Type;

15759: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
15760: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
15761: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
15762: l_mrp_msg_data VARCHAR2(200);
15763: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
15764: l_new_line_rec OE_Order_Pub.Line_Rec_Type;
15765:
15766: --
15767: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 15764: l_new_line_rec OE_Order_Pub.Line_Rec_Type;

15760: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
15761: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
15762: l_mrp_msg_data VARCHAR2(200);
15763: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
15764: l_new_line_rec OE_Order_Pub.Line_Rec_Type;
15765:
15766: --
15767: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15768: --

Line 15910: l_line_tbl OE_ORDER_PUB.Line_tbl_type;

15906: l_atp_tbl OE_ATP.Atp_Tbl_Type;
15907: l_return_status VARCHAR2(1);
15908: l_msg_count NUMBER;
15909: l_msg_data VARCHAR2(2000);
15910: l_line_tbl OE_ORDER_PUB.Line_tbl_type;
15911: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;
15912:
15913: BEGIN
15914: oe_debug_pub.add( '6663462 : in schedule_delayed_lines ');

Line 15911: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;

15907: l_return_status VARCHAR2(1);
15908: l_msg_count NUMBER;
15909: l_msg_data VARCHAR2(2000);
15910: l_line_tbl OE_ORDER_PUB.Line_tbl_type;
15911: l_old_line_tbl OE_ORDER_PUB.Line_tbl_type;
15912:
15913: BEGIN
15914: oe_debug_pub.add( '6663462 : in schedule_delayed_lines ');
15915: l_line_tbl := OE_SCHEDULE_UTIL.OE_Delayed_Schedule_line_tbl;