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_ORDER_SCH_UTIL dependencies on OE_ORDER_PUB

Line 24: FUNCTION Item_Is_Ato_Model(p_line_rec IN OE_ORDER_PUB.line_rec_type)

20: (p_schedule_ship_date IN DATE,
21: p_source_document_id IN VARCHAR2,
22: p_source_document_line_id IN VARCHAR2);
23:
24: FUNCTION Item_Is_Ato_Model(p_line_rec IN OE_ORDER_PUB.line_rec_type)
25: RETURN BOOLEAN
26: IS
27: --
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 68: FUNCTION Group_Scheduling_Required(p_line_rec OE_ORDER_PUB.line_rec_type,

64: function, will then log a delayed request to split the
65: scheduling on the line.
66:
67: ----------------------------------------------------------------------- */
68: FUNCTION Group_Scheduling_Required(p_line_rec OE_ORDER_PUB.line_rec_type,
69: p_old_line_rec OE_ORDER_PUB.line_rec_type)
70: RETURN BOOLEAN
71: IS
72: --

Line 69: p_old_line_rec OE_ORDER_PUB.line_rec_type)

65: scheduling on the line.
66:
67: ----------------------------------------------------------------------- */
68: FUNCTION Group_Scheduling_Required(p_line_rec OE_ORDER_PUB.line_rec_type,
69: p_old_line_rec OE_ORDER_PUB.line_rec_type)
70: RETURN BOOLEAN
71: IS
72: --
73: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 386: (p_x_line_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_rec_type,

382: Description :
383: ----------------------------------------------------------------------- */
384:
385: Procedure Update_Group_Sch_Results
386: (p_x_line_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_rec_type,
387: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
388: IS
389: l_line_rec OE_ORDER_PUB.line_rec_type;
390: --

Line 389: l_line_rec OE_ORDER_PUB.line_rec_type;

385: Procedure Update_Group_Sch_Results
386: (p_x_line_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_rec_type,
387: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
388: IS
389: l_line_rec OE_ORDER_PUB.line_rec_type;
390: --
391: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
392: --
393: BEGIN

Line 465: (p_line_rec IN OE_ORDER_PUB.line_rec_type,

461:
462:
463: ----------------------------------------------------------- */
464: PROCEDURE Build_Included_Items
465: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
466: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
467: IS
468: --l_line_tbl OE_ORDER_PUB.line_tbl_type;
469: l_validation_org NUMBER;

Line 466: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type)

462:
463: ----------------------------------------------------------- */
464: PROCEDURE Build_Included_Items
465: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
466: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
467: IS
468: --l_line_tbl OE_ORDER_PUB.line_tbl_type;
469: l_validation_org NUMBER;
470: l_group_id NUMBER;

Line 468: --l_line_tbl OE_ORDER_PUB.line_tbl_type;

464: PROCEDURE Build_Included_Items
465: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
466: x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type)
467: IS
468: --l_line_tbl OE_ORDER_PUB.line_tbl_type;
469: l_validation_org NUMBER;
470: l_group_id NUMBER;
471: l_session_id NUMBER;
472: l_levels NUMBER;

Line 630: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type

626: complete PTO. We need to get included items associated with the
627: parent before we schedule the line.
628: ---------------------------------------------------------------*/
629: Procedure Schedule_Parent_line
630: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
631: , p_write_to_db IN VARCHAR2
632: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
633: , p_recursive_call IN VARCHAR2
634: , x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type

Line 632: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

628: ---------------------------------------------------------------*/
629: Procedure Schedule_Parent_line
630: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
631: , p_write_to_db IN VARCHAR2
632: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
633: , p_recursive_call IN VARCHAR2
634: , x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type
635: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
636: IS

Line 637: l_line_rec OE_ORDER_PUB.line_rec_type;

633: , p_recursive_call IN VARCHAR2
634: , x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type
635: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
636: IS
637: l_line_rec OE_ORDER_PUB.line_rec_type;
638: l_line_tbl OE_ORDER_PUB.line_tbl_type;
639: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
640: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
641: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 638: l_line_tbl OE_ORDER_PUB.line_tbl_type;

634: , x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type
635: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
636: IS
637: l_line_rec OE_ORDER_PUB.line_rec_type;
638: l_line_tbl OE_ORDER_PUB.line_tbl_type;
639: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
640: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
641: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
642: l_inc_upd_tbl OE_ORDER_PUB.line_tbl_type;

Line 639: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;

635: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
636: IS
637: l_line_rec OE_ORDER_PUB.line_rec_type;
638: l_line_tbl OE_ORDER_PUB.line_tbl_type;
639: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
640: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
641: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
642: l_inc_upd_tbl OE_ORDER_PUB.line_tbl_type;
643: l_inc_upd_index NUMBER;

Line 640: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;

636: IS
637: l_line_rec OE_ORDER_PUB.line_rec_type;
638: l_line_tbl OE_ORDER_PUB.line_tbl_type;
639: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
640: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
641: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
642: l_inc_upd_tbl OE_ORDER_PUB.line_tbl_type;
643: l_inc_upd_index NUMBER;
644: l_inc_old_tbl OE_ORDER_PUB.line_tbl_type;

Line 641: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

637: l_line_rec OE_ORDER_PUB.line_rec_type;
638: l_line_tbl OE_ORDER_PUB.line_tbl_type;
639: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
640: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
641: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
642: l_inc_upd_tbl OE_ORDER_PUB.line_tbl_type;
643: l_inc_upd_index NUMBER;
644: l_inc_old_tbl OE_ORDER_PUB.line_tbl_type;
645: l_inc_old_index NUMBER;

Line 642: l_inc_upd_tbl OE_ORDER_PUB.line_tbl_type;

638: l_line_tbl OE_ORDER_PUB.line_tbl_type;
639: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
640: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
641: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
642: l_inc_upd_tbl OE_ORDER_PUB.line_tbl_type;
643: l_inc_upd_index NUMBER;
644: l_inc_old_tbl OE_ORDER_PUB.line_tbl_type;
645: l_inc_old_index NUMBER;
646: l_top_old_tbl OE_ORDER_PUB.line_tbl_type;

Line 644: l_inc_old_tbl OE_ORDER_PUB.line_tbl_type;

640: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
641: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
642: l_inc_upd_tbl OE_ORDER_PUB.line_tbl_type;
643: l_inc_upd_index NUMBER;
644: l_inc_old_tbl OE_ORDER_PUB.line_tbl_type;
645: l_inc_old_index NUMBER;
646: l_top_old_tbl OE_ORDER_PUB.line_tbl_type;
647: l_top_old_index NUMBER;
648: l_explode BOOLEAN;

Line 646: l_top_old_tbl OE_ORDER_PUB.line_tbl_type;

642: l_inc_upd_tbl OE_ORDER_PUB.line_tbl_type;
643: l_inc_upd_index NUMBER;
644: l_inc_old_tbl OE_ORDER_PUB.line_tbl_type;
645: l_inc_old_index NUMBER;
646: l_top_old_tbl OE_ORDER_PUB.line_tbl_type;
647: l_top_old_index NUMBER;
648: l_explode BOOLEAN;
649: l_old_ordered_quantity NUMBER;
650: l_out_line_rec OE_ORDER_PUB.line_rec_type;

Line 650: l_out_line_rec OE_ORDER_PUB.line_rec_type;

646: l_top_old_tbl OE_ORDER_PUB.line_tbl_type;
647: l_top_old_index NUMBER;
648: l_explode BOOLEAN;
649: l_old_ordered_quantity NUMBER;
650: l_out_line_rec OE_ORDER_PUB.line_rec_type;
651: K NUMBER :=0;
652: atp_count NUMBER :=0;
653: l_out_atp_tbl OE_ATP.atp_tbl_type;
654: l_return_status VARCHAR2(1);

Line 1020: (p_line_rec IN OE_ORDER_PUB.line_rec_type,

1016: Procedure Name : Reschedule_Set
1017: Description : ** Currently Not Used **
1018: -------------------------------------------------------------------------- */
1019: Procedure Reschedule_Set
1020: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
1021: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
1022: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1023: IS
1024: l_return_status VARCHAR2(1);

Line 1021: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

1017: Description : ** Currently Not Used **
1018: -------------------------------------------------------------------------- */
1019: Procedure Reschedule_Set
1020: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
1021: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
1022: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1023: IS
1024: l_return_status VARCHAR2(1);
1025: l_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 1025: l_line_tbl OE_ORDER_PUB.line_tbl_type;

1021: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
1022: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1023: IS
1024: l_return_status VARCHAR2(1);
1025: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1026: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1027: l_atp_tbl OE_ATP.atp_tbl_type;
1028: l_count NUMBER;
1029: --

Line 1026: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

1022: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1023: IS
1024: l_return_status VARCHAR2(1);
1025: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1026: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1027: l_atp_tbl OE_ATP.atp_tbl_type;
1028: l_count NUMBER;
1029: --
1030: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1091: Procedure Action_Undemand(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

1087: Description : This procedure is called from SCHEDULE LINE proecudure
1088: to perform the UNDEMAD on the line when an item is changed.
1089: --------------------------------------------------------------------- */
1090:
1091: Procedure Action_Undemand(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
1092: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1093:
1094: IS
1095: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 1095: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

1091: Procedure Action_Undemand(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
1092: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1093:
1094: IS
1095: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1096: l_return_status VARCHAR2(1);
1097: l_msg_count NUMBER;
1098: l_msg_data VARCHAR2(2000);
1099: l_session_id NUMBER := 0;

Line 1178: Procedure Schedule_line( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

1174: 4. Sch_Multi_Selected_Lines (in OEXVGRPB.pls)
1175:
1176: -------------------------------------------------------------------------- */
1177:
1178: Procedure Schedule_line( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
1179: p_write_to_db IN VARCHAR2,
1180: p_update_flag IN VARCHAR2 := FND_API.G_TRUE,
1181: p_recursive_call IN VARCHAR2 := FND_API.G_TRUE,
1182: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

Line 1182: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

1178: Procedure Schedule_line( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
1179: p_write_to_db IN VARCHAR2,
1180: p_update_flag IN VARCHAR2 := FND_API.G_TRUE,
1181: p_recursive_call IN VARCHAR2 := FND_API.G_TRUE,
1182: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
1183: x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type,
1184: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1185: )
1186: IS

Line 1188: l_line_rec OE_ORDER_PUB.line_rec_type;

1184: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1185: )
1186: IS
1187: l_schedule_line_rec request_rec_type;
1188: l_line_rec OE_ORDER_PUB.line_rec_type;
1189: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1190: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1191: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1192: l_out_line_rec OE_ORDER_PUB.line_rec_type;

Line 1189: l_line_tbl OE_ORDER_PUB.line_tbl_type;

1185: )
1186: IS
1187: l_schedule_line_rec request_rec_type;
1188: l_line_rec OE_ORDER_PUB.line_rec_type;
1189: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1190: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1191: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1192: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1193: l_out_atp_tbl OE_ATP.atp_tbl_type;

Line 1190: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;

1186: IS
1187: l_schedule_line_rec request_rec_type;
1188: l_line_rec OE_ORDER_PUB.line_rec_type;
1189: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1190: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1191: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1192: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1193: l_out_atp_tbl OE_ATP.atp_tbl_type;
1194: l_request_rec request_rec_type;

Line 1191: l_old_line_rec OE_ORDER_PUB.line_rec_type;

1187: l_schedule_line_rec request_rec_type;
1188: l_line_rec OE_ORDER_PUB.line_rec_type;
1189: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1190: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1191: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1192: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1193: l_out_atp_tbl OE_ATP.atp_tbl_type;
1194: l_request_rec request_rec_type;
1195: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

Line 1192: l_out_line_rec OE_ORDER_PUB.line_rec_type;

1188: l_line_rec OE_ORDER_PUB.line_rec_type;
1189: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1190: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1191: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1192: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1193: l_out_atp_tbl OE_ATP.atp_tbl_type;
1194: l_request_rec request_rec_type;
1195: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
1196: l_out_request_rec request_rec_type;

Line 2081: ( p_line_tbl IN OE_ORDER_PUB.line_tbl_type

2077: updated to the database.
2078: --------------------------------------------------------------------- */
2079:
2080: Procedure Update_line_record
2081: ( p_line_tbl IN OE_ORDER_PUB.line_tbl_type
2082: , p_x_new_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
2083: , p_write_to_db IN VARCHAR2
2084: , p_recursive_call IN VARCHAR2
2085: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 2082: , p_x_new_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

2078: --------------------------------------------------------------------- */
2079:
2080: Procedure Update_line_record
2081: ( p_line_tbl IN OE_ORDER_PUB.line_tbl_type
2082: , p_x_new_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
2083: , p_write_to_db IN VARCHAR2
2084: , p_recursive_call IN VARCHAR2
2085: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2086: IS

Line 2088: l_line_rec OE_ORDER_PUB.line_rec_type;

2084: , p_recursive_call IN VARCHAR2
2085: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2086: IS
2087: l_schedule_line_rec request_rec_type;
2088: l_line_rec OE_ORDER_PUB.line_rec_type;
2089: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2090: l_sch_rec sch_rec_type;
2091: I NUMBER;
2092: l_return_status VARCHAR2(1);

Line 2089: l_old_line_rec OE_ORDER_PUB.line_rec_type;

2085: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2086: IS
2087: l_schedule_line_rec request_rec_type;
2088: l_line_rec OE_ORDER_PUB.line_rec_type;
2089: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2090: l_sch_rec sch_rec_type;
2091: I NUMBER;
2092: l_return_status VARCHAR2(1);
2093: l_msg_count NUMBER;

Line 2096: l_line_tbl OE_ORDER_PUB.line_tbl_type;

2092: l_return_status VARCHAR2(1);
2093: l_msg_count NUMBER;
2094: l_msg_data VARCHAR2(2000);
2095: l_control_rec OE_GLOBALS.control_rec_type;
2096: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2097: l_process_requests BOOLEAN;
2098: is_set_recursion VARCHAR2(1) := 'Y';
2099: /*
2100: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 2100: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

2096: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2097: l_process_requests BOOLEAN;
2098: is_set_recursion VARCHAR2(1) := 'Y';
2099: /*
2100: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2101: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
2102: l_header_rec OE_Order_PUB.Header_Rec_Type;
2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2101: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

2097: l_process_requests BOOLEAN;
2098: is_set_recursion VARCHAR2(1) := 'Y';
2099: /*
2100: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2101: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
2102: l_header_rec OE_Order_PUB.Header_Rec_Type;
2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2102: l_header_rec OE_Order_PUB.Header_Rec_Type;

2098: is_set_recursion VARCHAR2(1) := 'Y';
2099: /*
2100: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2101: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
2102: l_header_rec OE_Order_PUB.Header_Rec_Type;
2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;

2099: /*
2100: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2101: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
2102: l_header_rec OE_Order_PUB.Header_Rec_Type;
2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2100: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2101: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
2102: l_header_rec OE_Order_PUB.Header_Rec_Type;
2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2101: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
2102: l_header_rec OE_Order_PUB.Header_Rec_Type;
2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2102: l_header_rec OE_Order_PUB.Header_Rec_Type;
2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2103: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2104: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

2105: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2113: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

2106: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2113: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2114: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

2107: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2113: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2114: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2115: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

2108: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2113: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2114: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2115: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2116: */

Line 2113: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

2109: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2113: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2114: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2115: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2116: */
2117: --

Line 2114: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

2110: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2113: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2114: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2115: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2116: */
2117: --
2118: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2115: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

2111: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
2112: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
2113: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
2114: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
2115: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
2116: */
2117: --
2118: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2119: --

Line 2342: FUNCTION Need_Scheduling(p_line_rec IN OE_ORDER_PUB.line_rec_type,

2338: Function Name : Need_Scheduling
2339: Description : This API will return to the calling process if scheduling
2340: needs to be performed on the line or not.
2341: --------------------------------------------------------------------- */
2342: FUNCTION Need_Scheduling(p_line_rec IN OE_ORDER_PUB.line_rec_type,
2343: p_old_line_rec IN OE_ORDER_PUB.line_rec_type)
2344: RETURN BOOLEAN
2345: IS
2346: l_schedule_action_code VARCHAR2(30);

Line 2343: p_old_line_rec IN OE_ORDER_PUB.line_rec_type)

2339: Description : This API will return to the calling process if scheduling
2340: needs to be performed on the line or not.
2341: --------------------------------------------------------------------- */
2342: FUNCTION Need_Scheduling(p_line_rec IN OE_ORDER_PUB.line_rec_type,
2343: p_old_line_rec IN OE_ORDER_PUB.line_rec_type)
2344: RETURN BOOLEAN
2345: IS
2346: l_schedule_action_code VARCHAR2(30);
2347: l_schedule_status_code VARCHAR2(30);

Line 2764: Procedure Validate_Line(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

2760: IF the profile OE:Schedule Line on Hold is set to 'Y'
2761: we will perform scheduling on lines on hold. If it is
2762: set to 'N', we will not perform scheduling.
2763: --------------------------------------------------------------------- */
2764: Procedure Validate_Line(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
2765: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
2766: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2767: IS
2768: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2765: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

2761: we will perform scheduling on lines on hold. If it is
2762: set to 'N', we will not perform scheduling.
2763: --------------------------------------------------------------------- */
2764: Procedure Validate_Line(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
2765: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
2766: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2767: IS
2768: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2769: l_msg_count NUMBER;

Line 3216: FUNCTION Scheduling_Activity(p_line_rec IN OE_ORDER_PUB.line_rec_type)

3212: /*---------------------------------------------------------------------
3213: Procedure Name : Scheduling_Activity
3214: Description : ** CURRENT NOT USED **
3215: --------------------------------------------------------------------- */
3216: FUNCTION Scheduling_Activity(p_line_rec IN OE_ORDER_PUB.line_rec_type)
3217: RETURN BOOLEAN
3218: IS
3219: --
3220: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3230: Procedure Check_Item_Attribute(p_line_rec IN OE_ORDER_PUB.line_rec_type)

3226: /*---------------------------------------------------------------------
3227: Procedure Name : Check_Item_Attributes
3228: Description : ** CURRENT NOT USED **
3229: --------------------------------------------------------------------- */
3230: Procedure Check_Item_Attribute(p_line_rec IN OE_ORDER_PUB.line_rec_type)
3231: IS
3232: l_item_rec OE_ORDER_CACHE.item_rec_type;
3233: --
3234: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3540: Procedure Action_Schedule(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

3536: Description : This procedure is called from Process_Request proecudure
3537: to perform the action of SCHEDULE or RESERVE on the line.
3538: --------------------------------------------------------------------- */
3539:
3540: Procedure Action_Schedule(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
3541: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
3542: p_action IN VARCHAR2,
3543: p_qty_to_reserve IN NUMBER := null,
3544: p_qty2_to_reserve IN NUMBER := null, -- INVCONV

Line 3541: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

3537: to perform the action of SCHEDULE or RESERVE on the line.
3538: --------------------------------------------------------------------- */
3539:
3540: Procedure Action_Schedule(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
3541: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
3542: p_action IN VARCHAR2,
3543: p_qty_to_reserve IN NUMBER := null,
3544: p_qty2_to_reserve IN NUMBER := null, -- INVCONV
3545: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 3547: l_line_rec OE_ORDER_PUB.line_rec_type;

3543: p_qty_to_reserve IN NUMBER := null,
3544: p_qty2_to_reserve IN NUMBER := null, -- INVCONV
3545: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3546: IS
3547: l_line_rec OE_ORDER_PUB.line_rec_type;
3548: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3549: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3550: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3551: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 3548: l_old_line_rec OE_ORDER_PUB.line_rec_type;

3544: p_qty2_to_reserve IN NUMBER := null, -- INVCONV
3545: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3546: IS
3547: l_line_rec OE_ORDER_PUB.line_rec_type;
3548: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3549: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3550: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3551: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3552: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 3549: l_out_line_rec OE_ORDER_PUB.line_rec_type;

3545: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3546: IS
3547: l_line_rec OE_ORDER_PUB.line_rec_type;
3548: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3549: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3550: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3551: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3552: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3553: l_old_atp_tbl OE_ATP.atp_tbl_type;

Line 3550: l_line_tbl OE_ORDER_PUB.line_tbl_type;

3546: IS
3547: l_line_rec OE_ORDER_PUB.line_rec_type;
3548: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3549: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3550: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3551: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3552: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3553: l_old_atp_tbl OE_ATP.atp_tbl_type;
3554: l_return_status VARCHAR2(1);

Line 3551: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

3547: l_line_rec OE_ORDER_PUB.line_rec_type;
3548: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3549: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3550: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3551: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3552: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3553: l_old_atp_tbl OE_ATP.atp_tbl_type;
3554: l_return_status VARCHAR2(1);
3555: l_msg_count NUMBER;

Line 3552: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

3548: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3549: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3550: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3551: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3552: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3553: l_old_atp_tbl OE_ATP.atp_tbl_type;
3554: l_return_status VARCHAR2(1);
3555: l_msg_count NUMBER;
3556: l_msg_data VARCHAR2(2000);

Line 3945: Procedure Action_UnSchedule(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

3941: Description : This procedure is called from Process_Request proecudure
3942: to perform the action of UNSCHEDULE or UNRESERVE on the line.
3943: --------------------------------------------------------------------- */
3944:
3945: Procedure Action_UnSchedule(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
3946: p_action IN VARCHAR2,
3947: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
3948: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3949: IS

Line 3947: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

3943: --------------------------------------------------------------------- */
3944:
3945: Procedure Action_UnSchedule(p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
3946: p_action IN VARCHAR2,
3947: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
3948: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3949: IS
3950:
3951: l_line_rec OE_ORDER_PUB.line_rec_type;

Line 3951: l_line_rec OE_ORDER_PUB.line_rec_type;

3947: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
3948: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3949: IS
3950:
3951: l_line_rec OE_ORDER_PUB.line_rec_type;
3952: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3953: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3954: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3955: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 3952: l_old_line_rec OE_ORDER_PUB.line_rec_type;

3948: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3949: IS
3950:
3951: l_line_rec OE_ORDER_PUB.line_rec_type;
3952: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3953: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3954: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3955: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3956: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 3953: l_out_line_rec OE_ORDER_PUB.line_rec_type;

3949: IS
3950:
3951: l_line_rec OE_ORDER_PUB.line_rec_type;
3952: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3953: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3954: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3955: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3956: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3957: l_old_atp_tbl OE_ATP.atp_tbl_type;

Line 3954: l_line_tbl OE_ORDER_PUB.line_tbl_type;

3950:
3951: l_line_rec OE_ORDER_PUB.line_rec_type;
3952: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3953: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3954: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3955: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3956: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3957: l_old_atp_tbl OE_ATP.atp_tbl_type;
3958: l_return_status VARCHAR2(1);

Line 3955: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

3951: l_line_rec OE_ORDER_PUB.line_rec_type;
3952: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3953: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3954: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3955: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3956: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3957: l_old_atp_tbl OE_ATP.atp_tbl_type;
3958: l_return_status VARCHAR2(1);
3959: l_msg_count NUMBER;

Line 3956: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

3952: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3953: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3954: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3955: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3956: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3957: l_old_atp_tbl OE_ATP.atp_tbl_type;
3958: l_return_status VARCHAR2(1);
3959: l_msg_count NUMBER;
3960: l_msg_data VARCHAR2(2000);

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

4100: belong to any set.
4101:
4102: --------------------------------------------------------------------- */
4103:
4104: Procedure Process_request( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
4105: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
4106: x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type,
4107: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4108: IS

Line 4105: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,

4101:
4102: --------------------------------------------------------------------- */
4103:
4104: Procedure Process_request( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
4105: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
4106: x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type,
4107: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4108: IS
4109:

Line 4111: l_line_rec OE_ORDER_PUB.line_rec_type;

4107: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4108: IS
4109:
4110: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4111: l_line_rec OE_ORDER_PUB.line_rec_type;
4112: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4113: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4115: l_out_atp_rec OE_ATP.atp_rec_type;

Line 4112: l_line_tbl OE_ORDER_PUB.line_tbl_type;

4108: IS
4109:
4110: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4111: l_line_rec OE_ORDER_PUB.line_rec_type;
4112: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4113: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4115: l_out_atp_rec OE_ATP.atp_rec_type;
4116: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 4113: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

4109:
4110: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4111: l_line_rec OE_ORDER_PUB.line_rec_type;
4112: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4113: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4115: l_out_atp_rec OE_ATP.atp_rec_type;
4116: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
4117: l_out_atp_tbl OE_ATP.atp_tbl_type;

Line 4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;

4110: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4111: l_line_rec OE_ORDER_PUB.line_rec_type;
4112: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4113: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4115: l_out_atp_rec OE_ATP.atp_rec_type;
4116: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
4117: l_out_atp_tbl OE_ATP.atp_tbl_type;
4118: l_old_line_rec OE_ORDER_PUB.line_rec_type;

Line 4116: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

4112: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4113: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4115: l_out_atp_rec OE_ATP.atp_rec_type;
4116: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
4117: l_out_atp_tbl OE_ATP.atp_tbl_type;
4118: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4119: l_action VARCHAR2(30);
4120: l_old_status VARCHAR2(30);

Line 4118: l_old_line_rec OE_ORDER_PUB.line_rec_type;

4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4115: l_out_atp_rec OE_ATP.atp_rec_type;
4116: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
4117: l_out_atp_tbl OE_ATP.atp_tbl_type;
4118: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4119: l_action VARCHAR2(30);
4120: l_old_status VARCHAR2(30);
4121: l_msg_count NUMBER;
4122: l_msg_data VARCHAR2(2000);

Line 5759: ( p_line_tbl IN Oe_Order_Pub.Line_Tbl_Type

5755: components, and we pass them along with the ATO model
5756: to MRP.
5757: ----------------------------------------------------------------------------- */
5758: Procedure Load_MRP_Request
5759: ( p_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
5760: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
5761: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
5762: IS
5763: I number := 1;

Line 5760: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type

5756: to MRP.
5757: ----------------------------------------------------------------------------- */
5758: Procedure Load_MRP_Request
5759: ( p_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
5760: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
5761: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
5762: IS
5763: I number := 1;
5764: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 5766: l_line_rec Oe_Order_Pub.Line_Rec_Type;

5762: IS
5763: I number := 1;
5764: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
5765: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
5766: l_line_rec Oe_Order_Pub.Line_Rec_Type;
5767: l_old_line_rec Oe_Order_Pub.Line_Rec_Type;
5768:
5769: l_type_code VARCHAR2(30);
5770: l_st_atp_lead_time NUMBER;

Line 5767: l_old_line_rec Oe_Order_Pub.Line_Rec_Type;

5763: I number := 1;
5764: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
5765: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
5766: l_line_rec Oe_Order_Pub.Line_Rec_Type;
5767: l_old_line_rec Oe_Order_Pub.Line_Rec_Type;
5768:
5769: l_type_code VARCHAR2(30);
5770: l_st_atp_lead_time NUMBER;
5771: l_st_ato_line_id NUMBER;

Line 6604: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

6600: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
6601: as the identifier.
6602: ----------------------------------------------------------------------------- */
6603: Procedure Load_INV_Request
6604: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
6605: , p_quantity_to_reserve IN NUMBER
6606: , p_quantity2_to_reserve IN NUMBER -- INVCONV
6607: , x_reservation_rec OUT NOCOPY /* file.sql.39 change */ Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
6608: IS

Line 6733: ( p_line_rec IN Oe_Order_Pub.line_rec_type

6729: ----------------------------------------------------------------------------- */
6730:
6731:
6732: FUNCTION Schedule_Attribute_Changed
6733: ( p_line_rec IN Oe_Order_Pub.line_rec_type
6734: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
6735: RETURN BOOLEAN
6736: IS
6737: --

Line 6734: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)

6730:
6731:
6732: FUNCTION Schedule_Attribute_Changed
6733: ( p_line_rec IN Oe_Order_Pub.line_rec_type
6734: , p_old_line_rec IN Oe_Order_Pub.line_rec_type)
6735: RETURN BOOLEAN
6736: IS
6737: --
6738: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 6825: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type

6821: is satisfied.
6822: --------------------------------------------------------------------- */
6823:
6824: Procedure Unreserve_Line
6825: ( p_line_rec IN OE_ORDER_PUB.Line_Rec_Type
6826: , p_quantity_to_unreserve IN NUMBER
6827: , p_quantity2_to_unreserve IN NUMBER -- INVCONV
6828: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
6829: IS

Line 6830: l_line_rec OE_ORDER_PUB.line_rec_type;

6826: , p_quantity_to_unreserve IN NUMBER
6827: , p_quantity2_to_unreserve IN NUMBER -- INVCONV
6828: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
6829: IS
6830: l_line_rec OE_ORDER_PUB.line_rec_type;
6831: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6832: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
6833: l_msg_count NUMBER;
6834: l_msg_data VARCHAR2(240);

Line 7098: ( p_line_rec IN OE_ORDER_PUB.line_rec_type

7094: The group attributes are populated on the x_group_req_rec
7095: based on the ones changed.
7096: -------------------------------------------------------------------------- */
7097: Procedure Create_Group_Request
7098: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
7099: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type
7100: , x_group_req_rec OUT NOCOPY /* file.sql.39 change */ OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
7101: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7102: )

Line 7099: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type

7095: based on the ones changed.
7096: -------------------------------------------------------------------------- */
7097: Procedure Create_Group_Request
7098: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
7099: , p_old_line_rec IN OE_ORDER_PUB.line_rec_type
7100: , x_group_req_rec OUT NOCOPY /* file.sql.39 change */ OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
7101: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7102: )
7103: IS

Line 7286: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

7282: while loading the results.
7283: -------------------------------------------------------------------------- */
7284: Procedure Load_Results
7285: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ
7286: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
7287: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.ATP_Tbl_Type
7288: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
7289: IS
7290: I NUMBER := 0;

Line 7293: l_line_rec OE_ORDER_PUB.line_rec_type;

7289: IS
7290: I NUMBER := 0;
7291: J NUMBER := 0;
7292: ATP NUMBER := 0;
7293: l_line_rec OE_ORDER_PUB.line_rec_type;
7294: l_atp_rec OE_ATP.atp_rec_type;
7295: l_msg_count NUMBER;
7296: l_msg_data VARCHAR2(2000);
7297: l_explanation VARCHAR2(80);

Line 8148: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)

8144: SEGMENT3 : stores the ont_source_code value
8145:
8146: -------------------------------------------------------------------------- */
8147: Procedure Insert_Into_Mtl_Sales_Orders
8148: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)
8149: IS
8150: l_order_type_name VARCHAR2(80);
8151: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
8152: l_sales_order_id NUMBER;

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

8305: /* Function find line
8306:
8307: This is be used to find the line in the pl/sql table.
8308: */
8309: FUNCTION Find_line( p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
8310: p_line_id IN NUMBER)
8311: Return BOOLEAN
8312: IS
8313: --

Line 8345: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type)

8341: If the ato model is part of set, then whole set information will
8342: be passed to MRP and so on */
8343:
8344: PROCEDURE PROCESS_SPLIT
8345: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type)
8346:
8347: IS
8348: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8349: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 8348: l_line_tbl OE_ORDER_PUB.line_tbl_type;

8344: PROCEDURE PROCESS_SPLIT
8345: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type)
8346:
8347: IS
8348: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8349: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
8350: K NUMBER;
8351: I NUMBER;
8352: l_ato_line_id NUMBER;

Line 8349: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;

8345: (p_x_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type)
8346:
8347: IS
8348: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8349: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
8350: K NUMBER;
8351: I NUMBER;
8352: l_ato_line_id NUMBER;
8353: l_entity VARCHAR2(30);

Line 8610: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type

8606:
8607:
8608: ---------------------------------------------------------------------- */
8609: Procedure SPLIT_SCHEDULING
8610: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
8611: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
8612: IS
8613: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8614: l_header_id NUMBER;

Line 8631: l_line_tbl OE_ORDER_PUB.line_tbl_type;

8627: l_x_error_code NUMBER;
8628: l_lock_records VARCHAR2(1);
8629: l_sort_by_req_date NUMBER;
8630: continue_loop BOOLEAN := TRUE;
8631: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8632: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
8633: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
8634: l_line_rec OE_ORDER_PUB.line_rec_type;
8635: l_out_line_rec OE_ORDER_PUB.line_rec_type;

Line 8632: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

8628: l_lock_records VARCHAR2(1);
8629: l_sort_by_req_date NUMBER;
8630: continue_loop BOOLEAN := TRUE;
8631: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8632: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
8633: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
8634: l_line_rec OE_ORDER_PUB.line_rec_type;
8635: l_out_line_rec OE_ORDER_PUB.line_rec_type;
8636: l_split_line_rec OE_ORDER_PUB.line_rec_type;

Line 8633: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;

8629: l_sort_by_req_date NUMBER;
8630: continue_loop BOOLEAN := TRUE;
8631: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8632: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
8633: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
8634: l_line_rec OE_ORDER_PUB.line_rec_type;
8635: l_out_line_rec OE_ORDER_PUB.line_rec_type;
8636: l_split_line_rec OE_ORDER_PUB.line_rec_type;
8637: l_out_split_line_rec OE_ORDER_PUB.line_rec_type;

Line 8634: l_line_rec OE_ORDER_PUB.line_rec_type;

8630: continue_loop BOOLEAN := TRUE;
8631: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8632: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
8633: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
8634: l_line_rec OE_ORDER_PUB.line_rec_type;
8635: l_out_line_rec OE_ORDER_PUB.line_rec_type;
8636: l_split_line_rec OE_ORDER_PUB.line_rec_type;
8637: l_out_split_line_rec OE_ORDER_PUB.line_rec_type;
8638: K NUMBER;

Line 8635: l_out_line_rec OE_ORDER_PUB.line_rec_type;

8631: l_line_tbl OE_ORDER_PUB.line_tbl_type;
8632: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
8633: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
8634: l_line_rec OE_ORDER_PUB.line_rec_type;
8635: l_out_line_rec OE_ORDER_PUB.line_rec_type;
8636: l_split_line_rec OE_ORDER_PUB.line_rec_type;
8637: l_out_split_line_rec OE_ORDER_PUB.line_rec_type;
8638: K NUMBER;
8639: J NUMBER;

Line 8636: l_split_line_rec OE_ORDER_PUB.line_rec_type;

8632: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
8633: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
8634: l_line_rec OE_ORDER_PUB.line_rec_type;
8635: l_out_line_rec OE_ORDER_PUB.line_rec_type;
8636: l_split_line_rec OE_ORDER_PUB.line_rec_type;
8637: l_out_split_line_rec OE_ORDER_PUB.line_rec_type;
8638: K NUMBER;
8639: J NUMBER;
8640:

Line 8637: l_out_split_line_rec OE_ORDER_PUB.line_rec_type;

8633: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
8634: l_line_rec OE_ORDER_PUB.line_rec_type;
8635: l_out_line_rec OE_ORDER_PUB.line_rec_type;
8636: l_split_line_rec OE_ORDER_PUB.line_rec_type;
8637: l_out_split_line_rec OE_ORDER_PUB.line_rec_type;
8638: K NUMBER;
8639: J NUMBER;
8640:
8641: -- INVCONV

Line 9559: l_line_rec OE_ORDER_PUB.line_rec_type;

9555: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9556: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
9557: IS
9558: l_schedule_line_rec request_rec_type;
9559: l_line_rec OE_ORDER_PUB.line_rec_type;
9560: l_sch_rec sch_rec_type;
9561: I NUMBER;
9562: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9563: l_msg_count NUMBER := 0;

Line 9566: l_line_tbl OE_ORDER_PUB.line_tbl_type;

9562: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9563: l_msg_count NUMBER := 0;
9564: l_msg_data VARCHAR2(2000) := null;
9565: l_control_rec OE_GLOBALS.control_rec_type;
9566: l_line_tbl OE_ORDER_PUB.line_tbl_type;
9567: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
9568: l_mrp_line_tbl OE_SCHEDULE_UTIL.mrp_line_tbl_type;
9569: /*
9570: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

Line 9567: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

9563: l_msg_count NUMBER := 0;
9564: l_msg_data VARCHAR2(2000) := null;
9565: l_control_rec OE_GLOBALS.control_rec_type;
9566: l_line_tbl OE_ORDER_PUB.line_tbl_type;
9567: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
9568: l_mrp_line_tbl OE_SCHEDULE_UTIL.mrp_line_tbl_type;
9569: /*
9570: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
9571: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 9570: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

9566: l_line_tbl OE_ORDER_PUB.line_tbl_type;
9567: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
9568: l_mrp_line_tbl OE_SCHEDULE_UTIL.mrp_line_tbl_type;
9569: /*
9570: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
9571: l_header_rec OE_Order_PUB.Header_Rec_Type;
9572: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 9571: l_header_rec OE_Order_PUB.Header_Rec_Type;

9567: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
9568: l_mrp_line_tbl OE_SCHEDULE_UTIL.mrp_line_tbl_type;
9569: /*
9570: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
9571: l_header_rec OE_Order_PUB.Header_Rec_Type;
9572: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 9572: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;

9568: l_mrp_line_tbl OE_SCHEDULE_UTIL.mrp_line_tbl_type;
9569: /*
9570: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
9571: l_header_rec OE_Order_PUB.Header_Rec_Type;
9572: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

9569: /*
9570: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
9571: l_header_rec OE_Order_PUB.Header_Rec_Type;
9572: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

9570: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
9571: l_header_rec OE_Order_PUB.Header_Rec_Type;
9572: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

9571: l_header_rec OE_Order_PUB.Header_Rec_Type;
9572: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

9572: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

9573: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

9574: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
9582: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

9575: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
9582: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
9583: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

9576: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
9582: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
9583: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
9584: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

9577: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
9582: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
9583: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
9584: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
9585: */

Line 9582: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

9578: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
9582: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
9583: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
9584: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
9585: */
9586: l_file_val VARCHAR2(80);

Line 9583: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

9579: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
9582: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
9583: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
9584: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
9585: */
9586: l_file_val VARCHAR2(80);
9587: --

Line 9584: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

9580: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
9581: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
9582: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
9583: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
9584: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
9585: */
9586: l_file_val VARCHAR2(80);
9587: --
9588: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 9718: l_model_line_rec OE_ORDER_PUB.line_rec_type;

9714: p_insert_code IN NUMBER,
9715: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9716: )
9717: IS
9718: l_model_line_rec OE_ORDER_PUB.line_rec_type;
9719: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
9720: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
9721: l_ship_set VARCHAR2(30);
9722: lTableName VARCHAR2(30);

Line 10124: l_line_rec OE_ORDER_PUB.line_rec_type;

10120: END Update_PO;
10121:
10122: Procedure Delete_Row(p_line_id IN NUMBER)
10123: IS
10124: l_line_rec OE_ORDER_PUB.line_rec_type;
10125: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10126: l_sales_order_id NUMBER;
10127: --
10128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;