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

Line 14: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

10: ---------------------------------------------------------------*/
11: PROCEDURE Print_Time(p_msg IN VARCHAR2);
12:
13: PROCEDURE Call_Mrp
14: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
15: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
16: ,p_sch_action IN VARCHAR2
17: ,p_partial IN BOOLEAN := FALSE
18: ,p_partial_set IN BOOLEAN := FALSE

Line 15: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type

11: PROCEDURE Print_Time(p_msg IN VARCHAR2);
12:
13: PROCEDURE Call_Mrp
14: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
15: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
16: ,p_sch_action IN VARCHAR2
17: ,p_partial IN BOOLEAN := FALSE
18: ,p_partial_set IN BOOLEAN := FALSE
19: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004

Line 23: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

19: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' -- 4405004
20: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
21:
22: PROCEDURE Handle_Unreserve
23: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
24: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
25: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
27:

Line 24: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

20: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
21:
22: PROCEDURE Handle_Unreserve
23: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
24: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
25: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
27:
28: PROCEDURE Reserve_Group

Line 29: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

25: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
27:
28: PROCEDURE Reserve_Group
29: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
30: ,p_sch_action IN VARCHAR2);
31:
32: PROCEDURE Unreserve_group
33: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

Line 33: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

29: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
30: ,p_sch_action IN VARCHAR2);
31:
32: PROCEDURE Unreserve_group
33: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
34: ,p_sch_action IN VARCHAR2 := 'X');
35:
36: Procedure Validate_Group_Request
37: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

Line 37: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

33: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
34: ,p_sch_action IN VARCHAR2 := 'X');
35:
36: Procedure Validate_Group_Request
37: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
38: ,p_request_type IN VARCHAR2
39: ,p_sch_action IN VARCHAR2
40: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
41:

Line 43: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

39: ,p_sch_action IN VARCHAR2
40: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
41:
42: PROCEDURE Is_Group_Scheduled
43: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
44: ,p_caller IN VARCHAR2 := 'X'
45: ,x_result OUT NOCOPY /* file.sql.39 change */ NUMBER);
46:
47: PROCEDURE Get_Reservations

Line 48: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

44: ,p_caller IN VARCHAR2 := 'X'
45: ,x_result OUT NOCOPY /* file.sql.39 change */ NUMBER);
46:
47: PROCEDURE Get_Reservations
48: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
49: ,x_reservation_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
50: ,x_reservation_qty2 OUT NOCOPY /* file.sql.39 change */ NUMBER -- INCONV
51: );
52:

Line 54: (p_line_rec IN OE_Order_PUB.Line_Rec_Type

50: ,x_reservation_qty2 OUT NOCOPY /* file.sql.39 change */ NUMBER -- INCONV
51: );
52:
53: PROCEDURE Log_Attribute_Changes
54: (p_line_rec IN OE_Order_PUB.Line_Rec_Type
55: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
56: ,x_unreserve_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
57:
58: --temp, just for testing

Line 55: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

51: );
52:
53: PROCEDURE Log_Attribute_Changes
54: (p_line_rec IN OE_Order_PUB.Line_Rec_Type
55: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
56: ,x_unreserve_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
57:
58: --temp, just for testing
59: PROCEDURE Call_ATP

Line 65: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

61: ,x_atp_rec OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ);
62:
63:
64: PROCEDURE Validate_And_Assign_Sch_Params
65: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
66: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
67: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type);
68:
69: PROCEDURE Get_Included_Items_To_Sch

Line 66: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

62:
63:
64: PROCEDURE Validate_And_Assign_Sch_Params
65: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
66: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
67: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type);
68:
69: PROCEDURE Get_Included_Items_To_Sch
70: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type

Line 67: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type);

63:
64: PROCEDURE Validate_And_Assign_Sch_Params
65: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
66: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
67: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type);
68:
69: PROCEDURE Get_Included_Items_To_Sch
70: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
71: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type

Line 70: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type

66: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
67: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type);
68:
69: PROCEDURE Get_Included_Items_To_Sch
70: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
71: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
72: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
73: ,p_in_index IN OUT NOCOPY /* file.sql.39 change */ NUMBER
74: ,p_req_index IN NUMBER);

Line 71: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type

67: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type);
68:
69: PROCEDURE Get_Included_Items_To_Sch
70: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
71: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
72: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
73: ,p_in_index IN OUT NOCOPY /* file.sql.39 change */ NUMBER
74: ,p_req_index IN NUMBER);
75:

Line 72: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type

68:
69: PROCEDURE Get_Included_Items_To_Sch
70: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
71: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
72: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
73: ,p_in_index IN OUT NOCOPY /* file.sql.39 change */ NUMBER
74: ,p_req_index IN NUMBER);
75:
76: -- this is temp, to be moved to oexuschb.pls

Line 78: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

74: ,p_req_index IN NUMBER);
75:
76: -- this is temp, to be moved to oexuschb.pls
77: PROCEDURE Call_Security_And_Defaulting
78: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
79: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
80: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
81:
82: PROCEDURE Handle_Direct_Update

Line 79: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

75:
76: -- this is temp, to be moved to oexuschb.pls
77: PROCEDURE Call_Security_And_Defaulting
78: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
79: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
80: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
81:
82: PROCEDURE Handle_Direct_Update
83: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

Line 83: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

79: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
80: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
81:
82: PROCEDURE Handle_Direct_Update
83: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
84: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
85: ,p_caller IN VARCHAR2);
86:
87:

Line 84: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

80: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
81:
82: PROCEDURE Handle_Direct_Update
83: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
84: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
85: ,p_caller IN VARCHAR2);
86:
87:
88: FUNCTION Check_for_Request( p_set_id IN NUMBER,

Line 222: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

218: schedule_ato delayed request
219: ----------------------------------------------------------*/
220:
221: PROCEDURE Log_Config_Sch_Request
222: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
223: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
224: ,p_sch_action IN VARCHAR2
225: ,p_caller IN VARCHAR2 := OE_SCHEDULE_UTIL.SCH_INTERNAL
226: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 223: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

219: ----------------------------------------------------------*/
220:
221: PROCEDURE Log_Config_Sch_Request
222: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
223: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
224: ,p_sch_action IN VARCHAR2
225: ,p_caller IN VARCHAR2 := OE_SCHEDULE_UTIL.SCH_INTERNAL
226: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
227: IS

Line 538: (p_line_rec IN OE_Order_PUB.Line_Rec_Type

534: very important because we are overwriting
535: x_qty_to_reserve and x_qty_to_unreserve.
536: ------------------------------------------------------------*/
537: PROCEDURE Log_Attribute_Changes
538: (p_line_rec IN OE_Order_PUB.Line_Rec_Type
539: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
540: ,x_unreserve_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
541: IS
542: l_diff_res_qty NUMBER;

Line 539: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

535: x_qty_to_reserve and x_qty_to_unreserve.
536: ------------------------------------------------------------*/
537: PROCEDURE Log_Attribute_Changes
538: (p_line_rec IN OE_Order_PUB.Line_Rec_Type
539: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
540: ,x_unreserve_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
541: IS
542: l_diff_res_qty NUMBER;
543: l_qty_to_reserve NUMBER;

Line 772: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

768: latest_acceptable_date if null, mrp can not give nay dates
769: other than passed.
770: -------------------------------------------------------------*/
771: PROCEDURE Schedule_SMC
772: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
773: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
774: IS
775: l_count NUMBER := 0;
776: l_msg_count NUMBER;

Line 778: l_line_tbl OE_ORDER_PUB.line_tbl_type;

774: IS
775: l_count NUMBER := 0;
776: l_msg_count NUMBER;
777: l_msg_data VARCHAR2(2000);
778: l_line_tbl OE_ORDER_PUB.line_tbl_type;
779: l_old_line_tbl OE_Order_PUB.line_tbl_type;
780: l_control_rec OE_GLOBALS.control_rec_type;
781: I NUMBER;
782: l_send_cancel_lines VARCHAR2(1); -- 2882255

Line 779: l_old_line_tbl OE_Order_PUB.line_tbl_type;

775: l_count NUMBER := 0;
776: l_msg_count NUMBER;
777: l_msg_data VARCHAR2(2000);
778: l_line_tbl OE_ORDER_PUB.line_tbl_type;
779: l_old_line_tbl OE_Order_PUB.line_tbl_type;
780: l_control_rec OE_GLOBALS.control_rec_type;
781: I NUMBER;
782: l_send_cancel_lines VARCHAR2(1); -- 2882255
783: --

Line 922: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

918: 'SCHEDULE''UNSCHEDULE''RESCHEDULE', will be processed
919: by calling call_mrp only.
920: -------------------------------------------------------------*/
921: PROCEDURE Schedule_ATO
922: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
923: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
924: IS
925: l_line_tbl OE_ORDER_PUB.line_tbl_type;
926: l_old_line_tbl OE_Order_PUB.line_tbl_type;

Line 925: l_line_tbl OE_ORDER_PUB.line_tbl_type;

921: PROCEDURE Schedule_ATO
922: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
923: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
924: IS
925: l_line_tbl OE_ORDER_PUB.line_tbl_type;
926: l_old_line_tbl OE_Order_PUB.line_tbl_type;
927: I NUMBER;
928: l_send_cancel_lines VARCHAR2(1); -- 2882255
929: l_request VARCHAR2(8) := 'ATO';

Line 926: l_old_line_tbl OE_Order_PUB.line_tbl_type;

922: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
923: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
924: IS
925: l_line_tbl OE_ORDER_PUB.line_tbl_type;
926: l_old_line_tbl OE_Order_PUB.line_tbl_type;
927: I NUMBER;
928: l_send_cancel_lines VARCHAR2(1); -- 2882255
929: l_request VARCHAR2(8) := 'ATO';
930: l_request_search_rslt BOOLEAN;

Line 1097: ( p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type

1093: Note: ATO witing nonSMC will be handled by the Schedule_ATO
1094: delayed request and should never come here.
1095: -------------------------------------------------------------*/
1096: PROCEDURE Schedule_NONSMC
1097: ( p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
1098: ,p_res_changes IN VARCHAR2 := 'N'
1099: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1100: IS
1101: l_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 1101: l_line_tbl OE_ORDER_PUB.line_tbl_type;

1097: ( p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
1098: ,p_res_changes IN VARCHAR2 := 'N'
1099: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1100: IS
1101: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1102: l_old_line_tbl OE_Order_PUB.line_tbl_type;
1103: l_inc_items_tbl OE_Order_PUB.line_tbl_type;
1104: J NUMBER := 0;
1105: L NUMBER := 0;

Line 1102: l_old_line_tbl OE_Order_PUB.line_tbl_type;

1098: ,p_res_changes IN VARCHAR2 := 'N'
1099: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1100: IS
1101: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1102: l_old_line_tbl OE_Order_PUB.line_tbl_type;
1103: l_inc_items_tbl OE_Order_PUB.line_tbl_type;
1104: J NUMBER := 0;
1105: L NUMBER := 0;
1106: I NUMBER;

Line 1103: l_inc_items_tbl OE_Order_PUB.line_tbl_type;

1099: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1100: IS
1101: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1102: l_old_line_tbl OE_Order_PUB.line_tbl_type;
1103: l_inc_items_tbl OE_Order_PUB.line_tbl_type;
1104: J NUMBER := 0;
1105: L NUMBER := 0;
1106: I NUMBER;
1107: l_sales_order_id NUMBER;

Line 1248: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type

1244: Bug 2463742: call to log_attribute_changes for INCLUDED item
1245: if it is rescheduled because of change on the parent.
1246: -----------------------------------------------------------*/
1247: PROCEDURE Get_Included_Items_To_Sch
1248: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
1249: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
1250: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
1251: ,p_in_index IN OUT NOCOPY /* file.sql.39 change */ NUMBER
1252: ,p_req_index IN NUMBER)

Line 1249: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type

1245: if it is rescheduled because of change on the parent.
1246: -----------------------------------------------------------*/
1247: PROCEDURE Get_Included_Items_To_Sch
1248: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
1249: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
1250: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
1251: ,p_in_index IN OUT NOCOPY /* file.sql.39 change */ NUMBER
1252: ,p_req_index IN NUMBER)
1253: IS

Line 1250: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type

1246: -----------------------------------------------------------*/
1247: PROCEDURE Get_Included_Items_To_Sch
1248: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
1249: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type
1250: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
1251: ,p_in_index IN OUT NOCOPY /* file.sql.39 change */ NUMBER
1252: ,p_req_index IN NUMBER)
1253: IS
1254: l_inc_items_tbl OE_Order_PUB.line_tbl_type;

Line 1254: l_inc_items_tbl OE_Order_PUB.line_tbl_type;

1250: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
1251: ,p_in_index IN OUT NOCOPY /* file.sql.39 change */ NUMBER
1252: ,p_req_index IN NUMBER)
1253: IS
1254: l_inc_items_tbl OE_Order_PUB.line_tbl_type;
1255: L NUMBER := 0;
1256: l_done BOOLEAN;
1257: l_unreserve_flag VARCHAR2(1);
1258: l_send_cancel_lines VARCHAR2(1); -- 2882255

Line 1402: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

1398: process_order call, because of the inv change,
1399: they need correct warehouse on the line.
1400: ---------------------------------------------------------*/
1401: PROCEDURE Process_Group
1402: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1403: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1404: ,p_sch_action IN VARCHAR2
1405: ,p_caller IN VARCHAR2 := 'X'
1406: ,p_handle_unreserve IN VARCHAR2 := 'N'

Line 1403: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

1399: they need correct warehouse on the line.
1400: ---------------------------------------------------------*/
1401: PROCEDURE Process_Group
1402: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1403: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1404: ,p_sch_action IN VARCHAR2
1405: ,p_caller IN VARCHAR2 := 'X'
1406: ,p_handle_unreserve IN VARCHAR2 := 'N'
1407: ,p_partial IN BOOLEAN := FALSE

Line 1595: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

1591: Procedure has been modified to fix the bipass calling MRP code
1592: for inactive demand project.1955004
1593: -----------------------------------------------------------------*/
1594: PROCEDURE Call_Mrp
1595: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1596: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1597: ,p_sch_action IN VARCHAR2
1598: ,p_partial IN BOOLEAN := FALSE
1599: ,p_partial_set IN BOOLEAN := FALSE

Line 1596: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type

1592: for inactive demand project.1955004
1593: -----------------------------------------------------------------*/
1594: PROCEDURE Call_Mrp
1595: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1596: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1597: ,p_sch_action IN VARCHAR2
1598: ,p_partial IN BOOLEAN := FALSE
1599: ,p_partial_set IN BOOLEAN := FALSE
1600: ,p_part_of_set IN VARCHAR2 DEFAULT 'N' --4405004

Line 1782: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

1778: does not afftect 1st caller and is used later in
1779: reserve_group.
1780: -----------------------------------------------------------------*/
1781: PROCEDURE Unreserve_group
1782: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1783: ,p_sch_action IN VARCHAR2 := 'X')
1784: IS
1785: l_return_status VARCHAR2(1);
1786: I NUMBER;

Line 1936: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

1932:
1933: p_sch_action is just a hint.
1934: -----------------------------------------------------------------*/
1935: PROCEDURE Reserve_Group
1936: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1937: ,p_sch_action IN VARCHAR2)
1938: IS
1939: l_return_status VARCHAR2(1);
1940: l_do_reserve BOOLEAN;

Line 2134: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

2130: 1) ship_from_org is changed on the line
2131: 2) manually reduced the reserved qty.
2132: ---------------------------------------------------------------*/
2133: PROCEDURE Get_Reservations
2134: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
2135: ,x_reservation_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
2136: ,x_reservation_qty2 OUT NOCOPY /* file.sql.39 change */ NUMBER -- INVCONV
2137: )
2138: IS

Line 2225: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2221:
2222: Unreserve_Group does not care about the ordered_quantity.
2223: -----------------------------------------------------------------*/
2224: PROCEDURE Handle_Unreserve
2225: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2226: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2227: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
2228: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2229: IS

Line 2226: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2222: Unreserve_Group does not care about the ordered_quantity.
2223: -----------------------------------------------------------------*/
2224: PROCEDURE Handle_Unreserve
2225: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2226: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2227: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
2228: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2229: IS
2230: l_qty NUMBER;

Line 2372: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

2368: cascade override flag from model/class and kits to its included
2369: items. Changes are also made to cascade override flag on ato model.
2370: ------------------------------------------------------------*/
2371: PROCEDURE Validate_And_Assign_Sch_Params
2372: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
2373: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
2374: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
2375: IS
2376: l_return_status VARCHAR2(1);

Line 2373: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

2369: items. Changes are also made to cascade override flag on ato model.
2370: ------------------------------------------------------------*/
2371: PROCEDURE Validate_And_Assign_Sch_Params
2372: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
2373: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
2374: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
2375: IS
2376: l_return_status VARCHAR2(1);
2377: --

Line 2374: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)

2370: ------------------------------------------------------------*/
2371: PROCEDURE Validate_And_Assign_Sch_Params
2372: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
2373: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
2374: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
2375: IS
2376: l_return_status VARCHAR2(1);
2377: --
2378: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2585: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2581: if we do not need, set the operation to NONE and do a direct
2582: update.
2583: -----------------------------------------------------------*/
2584: PROCEDURE Save_Sch_Attributes
2585: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2586: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2587: ,p_sch_action IN VARCHAR2
2588: ,p_caller IN VARCHAR2
2589: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 2586: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2582: update.
2583: -----------------------------------------------------------*/
2584: PROCEDURE Save_Sch_Attributes
2585: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2586: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2587: ,p_sch_action IN VARCHAR2
2588: ,p_caller IN VARCHAR2
2589: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2590: IS

Line 2598: l_orig_old_line_rec OE_Order_PUB.Line_Rec_Type; --3144917

2594: l_direct_update VARCHAR2(1) := 'N';
2595: l_process_requests BOOLEAN;
2596: l_redo_security_check VARCHAR2(1) := 'N';
2597: l_control_rec OE_GLOBALS.control_rec_type;
2598: l_orig_old_line_rec OE_Order_PUB.Line_Rec_Type; --3144917
2599:
2600: l_po_NeedByDate_Update VARCHAR2(10); -- Added for IR ISO CMS project
2601: l_return_status VARCHAR2(1); -- Added for IR ISO CMS project
2602:

Line 3117: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

3113: and to decide if we need to make a process_order call
3114: for the scheduling attributes or not.
3115: ------------------------------------------------------------*/
3116: PROCEDURE Call_Security_And_Defaulting
3117: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3118: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3119: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3120: IS
3121: l_sec_result NUMBER;

Line 3118: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

3114: for the scheduling attributes or not.
3115: ------------------------------------------------------------*/
3116: PROCEDURE Call_Security_And_Defaulting
3117: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3118: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3119: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3120: IS
3121: l_sec_result NUMBER;
3122: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 3229: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

3225: /*-------------------------------------------------------------------
3226: PROCEDURE Handle_Direct_Update
3227: --------------------------------------------------------------------*/
3228: PROCEDURE Handle_Direct_Update
3229: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3230: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3231: ,p_caller IN VARCHAR2)
3232: IS
3233: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;

Line 3230: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

3226: PROCEDURE Handle_Direct_Update
3227: --------------------------------------------------------------------*/
3228: PROCEDURE Handle_Direct_Update
3229: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3230: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3231: ,p_caller IN VARCHAR2)
3232: IS
3233: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
3234: l_return_status VARCHAR2(1);

Line 3398: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

3394: with new schedule ship date, after a call to RESCHEDULE.
3395: ---------------------------------------------------------------*/
3396:
3397: PROCEDURE Update_Reservation
3398: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
3399: ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
3400: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3401: IS
3402: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 3399: ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type

3395: ---------------------------------------------------------------*/
3396:
3397: PROCEDURE Update_Reservation
3398: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
3399: ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
3400: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3401: IS
3402: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3403: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 3573: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,

3569: p_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
3570: p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM,
3571: p_sch_action IN VARCHAR2,
3572: p_send_cancel_lines IN VARCHAR2 := 'N',
3573: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
3574: x_return_status OUT NOCOPY VARCHAR2)
3575: IS
3576: l_sales_order_id NUMBER;
3577: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3597: l_linetmp_tbl OE_Order_PUB.Line_Tbl_Type;

3593: --
3594: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3595: --
3596: --sol_ord_er #16014165
3597: l_linetmp_tbl OE_Order_PUB.Line_Tbl_Type;
3598: l_new_ctr NUMBER := 0;
3599: --sol_ord_er #16014165 end
3600: BEGIN
3601: Print_Time('Entering Query_Set_Lines '|| p_sch_action);

Line 3823: ,x_line_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Rec_Type)

3819: ------------------------------------------------------------*/
3820: PROCEDURE Query_Config_Attributes
3821: ( p_line_id IN NUMBER
3822: ,p_sch_attibs IN VARCHAR2 := 'N'
3823: ,x_line_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Rec_Type)
3824: IS
3825: --
3826: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3827: --

Line 3923: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

3919:
3920: ****Not used anymore.
3921: ---------------------------------------------------------------*/
3922: Procedure Validate_Group_Request
3923: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
3924: ,p_request_type IN VARCHAR2
3925: ,p_sch_action IN VARCHAR2
3926: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3927: IS

Line 4042: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

4038:
4039: ****not used
4040: -----------------------------------------------------------*/
4041: PROCEDURE Is_Group_Scheduled
4042: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
4043: ,p_caller IN VARCHAR2 := 'X'
4044: ,x_result OUT NOCOPY /* file.sql.39 change */ NUMBER)
4045: IS
4046: l_unscheduled_line VARCHAR2(1) := 'N';