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 536: (p_line_rec IN OE_Order_PUB.Line_Rec_Type

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

Line 537: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

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

Line 770: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

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

Line 776: l_line_tbl OE_ORDER_PUB.line_tbl_type;

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

Line 777: l_old_line_tbl OE_Order_PUB.line_tbl_type;

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

Line 920: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

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

Line 923: l_line_tbl OE_ORDER_PUB.line_tbl_type;

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

Line 924: l_old_line_tbl OE_Order_PUB.line_tbl_type;

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

Line 1095: ( p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type

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

Line 1099: l_line_tbl OE_ORDER_PUB.line_tbl_type;

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

Line 1100: l_old_line_tbl OE_Order_PUB.line_tbl_type;

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

Line 1101: l_inc_items_tbl OE_Order_PUB.line_tbl_type;

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

Line 1246: ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type

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

Line 1247: ,p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.line_tbl_type

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

Line 1248: ,p_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type

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

Line 1252: l_inc_items_tbl OE_Order_PUB.line_tbl_type;

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

Line 1400: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

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

Line 1401: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

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

Line 1593: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

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

Line 1594: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type

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

Line 1776: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

1772: does not afftect 1st caller and is used later in
1773: reserve_group.
1774: -----------------------------------------------------------------*/
1775: PROCEDURE Unreserve_group
1776: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
1777: ,p_sch_action IN VARCHAR2 := 'X')
1778: IS
1779: l_return_status VARCHAR2(1);
1780: I NUMBER;

Line 1919: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

1915:
1916: p_sch_action is just a hint.
1917: -----------------------------------------------------------------*/
1918: PROCEDURE Reserve_Group
1919: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
1920: ,p_sch_action IN VARCHAR2)
1921: IS
1922: l_return_status VARCHAR2(1);
1923: l_do_reserve BOOLEAN;

Line 2104: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

2100: 1) ship_from_org is changed on the line
2101: 2) manually reduced the reserved qty.
2102: ---------------------------------------------------------------*/
2103: PROCEDURE Get_Reservations
2104: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
2105: ,x_reservation_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
2106: ,x_reservation_qty2 OUT NOCOPY /* file.sql.39 change */ NUMBER -- INVCONV
2107: )
2108: IS

Line 2189: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2185:
2186: Unreserve_Group does not care about the ordered_quantity.
2187: -----------------------------------------------------------------*/
2188: PROCEDURE Handle_Unreserve
2189: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2190: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2191: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
2192: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2193: IS

Line 2190: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2186: Unreserve_Group does not care about the ordered_quantity.
2187: -----------------------------------------------------------------*/
2188: PROCEDURE Handle_Unreserve
2189: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2190: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2191: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
2192: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2193: IS
2194: l_qty NUMBER;

Line 2321: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type

2317: cascade override flag from model/class and kits to its included
2318: items. Changes are also made to cascade override flag on ato model.
2319: ------------------------------------------------------------*/
2320: PROCEDURE Validate_And_Assign_Sch_Params
2321: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
2322: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
2323: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
2324: IS
2325: l_return_status VARCHAR2(1);

Line 2322: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

2318: items. Changes are also made to cascade override flag on ato model.
2319: ------------------------------------------------------------*/
2320: PROCEDURE Validate_And_Assign_Sch_Params
2321: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
2322: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
2323: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
2324: IS
2325: l_return_status VARCHAR2(1);
2326: --

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

2319: ------------------------------------------------------------*/
2320: PROCEDURE Validate_And_Assign_Sch_Params
2321: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type
2322: ,p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
2323: ,p_x_old_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type)
2324: IS
2325: l_return_status VARCHAR2(1);
2326: --
2327: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2525: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2521: if we do not need, set the operation to NONE and do a direct
2522: update.
2523: -----------------------------------------------------------*/
2524: PROCEDURE Save_Sch_Attributes
2525: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2526: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2527: ,p_sch_action IN VARCHAR2
2528: ,p_caller IN VARCHAR2
2529: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 2526: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

2522: update.
2523: -----------------------------------------------------------*/
2524: PROCEDURE Save_Sch_Attributes
2525: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2526: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2527: ,p_sch_action IN VARCHAR2
2528: ,p_caller IN VARCHAR2
2529: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2530: IS

Line 2538: l_orig_old_line_rec OE_Order_PUB.Line_Rec_Type; --3144917

2534: l_direct_update VARCHAR2(1) := 'N';
2535: l_process_requests BOOLEAN;
2536: l_redo_security_check VARCHAR2(1) := 'N';
2537: l_control_rec OE_GLOBALS.control_rec_type;
2538: l_orig_old_line_rec OE_Order_PUB.Line_Rec_Type; --3144917
2539:
2540: l_po_NeedByDate_Update VARCHAR2(10); -- Added for IR ISO CMS project
2541: l_return_status VARCHAR2(1); -- Added for IR ISO CMS project
2542:

Line 3030: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

3026: and to decide if we need to make a process_order call
3027: for the scheduling attributes or not.
3028: ------------------------------------------------------------*/
3029: PROCEDURE Call_Security_And_Defaulting
3030: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3031: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3032: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3033: IS
3034: l_sec_result NUMBER;

Line 3031: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

3027: for the scheduling attributes or not.
3028: ------------------------------------------------------------*/
3029: PROCEDURE Call_Security_And_Defaulting
3030: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3031: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3032: ,x_direct_update OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3033: IS
3034: l_sec_result NUMBER;
3035: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

Line 3139: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type

3135: /*-------------------------------------------------------------------
3136: PROCEDURE Handle_Direct_Update
3137: --------------------------------------------------------------------*/
3138: PROCEDURE Handle_Direct_Update
3139: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3140: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3141: ,p_caller IN VARCHAR2)
3142: IS
3143: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;

Line 3140: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type

3136: PROCEDURE Handle_Direct_Update
3137: --------------------------------------------------------------------*/
3138: PROCEDURE Handle_Direct_Update
3139: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
3140: ,p_old_line_rec IN OE_ORDER_PUB.line_rec_type
3141: ,p_caller IN VARCHAR2)
3142: IS
3143: l_order_type_id NUMBER := OE_Order_Cache.g_header_rec.order_type_id;
3144: l_return_status VARCHAR2(1);

Line 3308: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type

3304: with new schedule ship date, after a call to RESCHEDULE.
3305: ---------------------------------------------------------------*/
3306:
3307: PROCEDURE Update_Reservation
3308: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
3309: ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
3310: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3311: IS
3312: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 3309: ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type

3305: ---------------------------------------------------------------*/
3306:
3307: PROCEDURE Update_Reservation
3308: ( p_line_rec IN OE_Order_Pub.Line_Rec_Type
3309: ,p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
3310: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3311: IS
3312: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3313: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 3483: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,

3479: p_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
3480: p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM,
3481: p_sch_action IN VARCHAR2,
3482: p_send_cancel_lines IN VARCHAR2 := 'N',
3483: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
3484: x_return_status OUT NOCOPY VARCHAR2)
3485: IS
3486: l_sales_order_id NUMBER;
3487: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

3698: ------------------------------------------------------------*/
3699: PROCEDURE Query_Config_Attributes
3700: ( p_line_id IN NUMBER
3701: ,p_sch_attibs IN VARCHAR2 := 'N'
3702: ,x_line_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Rec_Type)
3703: IS
3704: --
3705: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3706: --

Line 3802: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

3798:
3799: ****Not used anymore.
3800: ---------------------------------------------------------------*/
3801: Procedure Validate_Group_Request
3802: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
3803: ,p_request_type IN VARCHAR2
3804: ,p_sch_action IN VARCHAR2
3805: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3806: IS

Line 3921: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

3917:
3918: ****not used
3919: -----------------------------------------------------------*/
3920: PROCEDURE Is_Group_Scheduled
3921: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
3922: ,p_caller IN VARCHAR2 := 'X'
3923: ,x_result OUT NOCOPY /* file.sql.39 change */ NUMBER)
3924: IS
3925: l_unscheduled_line VARCHAR2(1) := 'N';