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

Line 8: g_requesting_entities OE_Order_PUB.Requesting_Entity_Tbl_Type;

4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Delayed_Requests_PVT';
7:
8: g_requesting_entities OE_Order_PUB.Requesting_Entity_Tbl_Type;
9: G_MAX_REQUESTS NUMBER := 10000;
10:
11: /* Local Procedures */
12: /* Local procedure to check if a request exists for a given entity, request

Line 35: ,p_request_rec IN OE_Order_PUB.request_rec_type

31: */
32:
33: PROCEDURE Process_Scheduling_Request
34: ( p_request_ind IN NUMBER
35: ,p_request_rec IN OE_Order_PUB.request_rec_type
36: ,x_return_status OUT NOCOPY VARCHAR2);
37:
38: PROCEDURE Check_Pricing_Request
39: ( p_request_ind IN NUMBER

Line 40: ,p_request_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.request_rec_type

36: ,x_return_status OUT NOCOPY VARCHAR2);
37:
38: PROCEDURE Check_Pricing_Request
39: ( p_request_ind IN NUMBER
40: ,p_request_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.request_rec_type
41: ,x_log_request OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: );
43:
44: Procedure Check_for_Request( p_entity_code in Varchar2

Line 171: l_request_rec OE_Order_PUB.request_rec_type;

167: from oe_order_lines_all
168: where header_id = p_header_id
169: and item_type_code = 'INCLUDED';
170:
171: l_request_rec OE_Order_PUB.request_rec_type;
172: l_request_type VARCHAR2(30);
173: l_return_status VARCHAR2(1);
174: l_entity_id NUMBER;
175: l_entity_code Varchar2(30);

Line 178: l_set_request OE_Order_PUB.request_tbl_type;

174: l_entity_id NUMBER;
175: l_entity_code Varchar2(30);
176: l_req_entity_ind number;
177: l_set_index NUMBER;
178: l_set_request OE_Order_PUB.request_tbl_type;
179: l_sch_set_tbl OE_Order_PUB.request_tbl_type;
180: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
181: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
182: l_index NUMBER;

Line 179: l_sch_set_tbl OE_Order_PUB.request_tbl_type;

175: l_entity_code Varchar2(30);
176: l_req_entity_ind number;
177: l_set_index NUMBER;
178: l_set_request OE_Order_PUB.request_tbl_type;
179: l_sch_set_tbl OE_Order_PUB.request_tbl_type;
180: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
181: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
182: l_index NUMBER;
183: l_d_index NUMBER;

Line 180: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;

176: l_req_entity_ind number;
177: l_set_index NUMBER;
178: l_set_request OE_Order_PUB.request_tbl_type;
179: l_sch_set_tbl OE_Order_PUB.request_tbl_type;
180: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
181: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
182: l_index NUMBER;
183: l_d_index NUMBER;
184: l_u_index NUMBER;

Line 181: l_updated_options_tbl OE_Order_PUB.request_tbl_type;

177: l_set_index NUMBER;
178: l_set_request OE_Order_PUB.request_tbl_type;
179: l_sch_set_tbl OE_Order_PUB.request_tbl_type;
180: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
181: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
182: l_index NUMBER;
183: l_d_index NUMBER;
184: l_u_index NUMBER;
185: l_set VARCHAR2(2000);

Line 187: l_cto_request_rec OE_Order_PUB.request_rec_type;

183: l_d_index NUMBER;
184: l_u_index NUMBER;
185: l_set VARCHAR2(2000);
186: K NUMBER;
187: l_cto_request_rec OE_Order_PUB.request_rec_type;
188: l_cto_request_tbl OE_Order_PUB.request_tbl_type;
189: l_cto_split_tbl OE_Order_PUB.request_tbl_type;
190: l_cto_decimal_tbl OE_Order_PUB.request_tbl_type;
191: l_line_Tbl OE_ORDER_PUB.line_Tbl_type;

Line 188: l_cto_request_tbl OE_Order_PUB.request_tbl_type;

184: l_u_index NUMBER;
185: l_set VARCHAR2(2000);
186: K NUMBER;
187: l_cto_request_rec OE_Order_PUB.request_rec_type;
188: l_cto_request_tbl OE_Order_PUB.request_tbl_type;
189: l_cto_split_tbl OE_Order_PUB.request_tbl_type;
190: l_cto_decimal_tbl OE_Order_PUB.request_tbl_type;
191: l_line_Tbl OE_ORDER_PUB.line_Tbl_type;
192: l_prc_adj_request OE_ORDER_PUB.request_tbl_type;

Line 189: l_cto_split_tbl OE_Order_PUB.request_tbl_type;

185: l_set VARCHAR2(2000);
186: K NUMBER;
187: l_cto_request_rec OE_Order_PUB.request_rec_type;
188: l_cto_request_tbl OE_Order_PUB.request_tbl_type;
189: l_cto_split_tbl OE_Order_PUB.request_tbl_type;
190: l_cto_decimal_tbl OE_Order_PUB.request_tbl_type;
191: l_line_Tbl OE_ORDER_PUB.line_Tbl_type;
192: l_prc_adj_request OE_ORDER_PUB.request_tbl_type;
193: l_prc_adj_index NUMBER := 1;

Line 190: l_cto_decimal_tbl OE_Order_PUB.request_tbl_type;

186: K NUMBER;
187: l_cto_request_rec OE_Order_PUB.request_rec_type;
188: l_cto_request_tbl OE_Order_PUB.request_tbl_type;
189: l_cto_split_tbl OE_Order_PUB.request_tbl_type;
190: l_cto_decimal_tbl OE_Order_PUB.request_tbl_type;
191: l_line_Tbl OE_ORDER_PUB.line_Tbl_type;
192: l_prc_adj_request OE_ORDER_PUB.request_tbl_type;
193: l_prc_adj_index NUMBER := 1;
194: I NUMBER := 1;

Line 191: l_line_Tbl OE_ORDER_PUB.line_Tbl_type;

187: l_cto_request_rec OE_Order_PUB.request_rec_type;
188: l_cto_request_tbl OE_Order_PUB.request_tbl_type;
189: l_cto_split_tbl OE_Order_PUB.request_tbl_type;
190: l_cto_decimal_tbl OE_Order_PUB.request_tbl_type;
191: l_line_Tbl OE_ORDER_PUB.line_Tbl_type;
192: l_prc_adj_request OE_ORDER_PUB.request_tbl_type;
193: l_prc_adj_index NUMBER := 1;
194: I NUMBER := 1;
195: l_price_control_rec QP_PREQ_GRP.control_record_type;

Line 192: l_prc_adj_request OE_ORDER_PUB.request_tbl_type;

188: l_cto_request_tbl OE_Order_PUB.request_tbl_type;
189: l_cto_split_tbl OE_Order_PUB.request_tbl_type;
190: l_cto_decimal_tbl OE_Order_PUB.request_tbl_type;
191: l_line_Tbl OE_ORDER_PUB.line_Tbl_type;
192: l_prc_adj_request OE_ORDER_PUB.request_tbl_type;
193: l_prc_adj_index NUMBER := 1;
194: I NUMBER := 1;
195: l_price_control_rec QP_PREQ_GRP.control_record_type;
196: l_msg_count NUMBER;

Line 1941: l_request OE_Order_PUB.REQUEST_REC_TYPE;

1937: l_request_search_rslt VARCHAR2(1);
1938: l_return_status VARCHAR2(1);
1939: l_request_ind NUMBER;
1940: l_req_entity_ind NUMBER;
1941: l_request OE_Order_PUB.REQUEST_REC_TYPE;
1942: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
1943: l_log_request VARCHAR2(1);
1944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1945: BEGIN

Line 1942: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;

1938: l_return_status VARCHAR2(1);
1939: l_request_ind NUMBER;
1940: l_req_entity_ind NUMBER;
1941: l_request OE_Order_PUB.REQUEST_REC_TYPE;
1942: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
1943: l_log_request VARCHAR2(1);
1944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1945: BEGIN
1946:

Line 3592: p_x_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type,

3588: **/
3589:
3590: PROCEDURE Process_Order_Actions
3591: (p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3592: p_x_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type,
3593: p_process_WF_requests IN boolean DEFAULT TRUE
3594: )
3595: IS
3596: l_request_rec OE_Order_PUB.request_rec_type;

Line 3596: l_request_rec OE_Order_PUB.request_rec_type;

3592: p_x_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type,
3593: p_process_WF_requests IN boolean DEFAULT TRUE
3594: )
3595: IS
3596: l_request_rec OE_Order_PUB.request_rec_type;
3597: l_return_status VARCHAR2(1);
3598: --
3599: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3600: --

Line 3617: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

3613: --comm rej l_reject_on_risk_failure VARCHAR2(1);
3614: l_msg_count NUMBER;
3615: l_msg_data VARCHAR2(4000);
3616: l_result_out VARCHAR2(30);
3617: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
3618: --R12 CVV2
3619:
3620: -- ER 7243028
3621: l_lines_count NUMBER;

Line 3626: oe_debug_pub.ADD('Entering OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);

3622: l_lines_list VARCHAR2(4000);
3623:
3624: BEGIN
3625: IF l_debug_level > 0 THEN
3626: oe_debug_pub.ADD('Entering OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);
3627: END IF;
3628:
3629: -- added for notification framework
3630: -- check code release leve first, notificaiont framework is at pack H

Line 4293: oe_debug_pub.ADD('Exiting OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);

4289: oe_order_pvt.set_recursion_mode(p_Entity_Code => 10,
4290: p_In_out => 0);
4291: END IF;
4292: IF l_debug_level > 0 THEN
4293: oe_debug_pub.ADD('Exiting OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);
4294: END IF;
4295: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4296:
4297: EXCEPTION

Line 4507: ,p_request_rec IN OE_Order_PUB.request_rec_type

4503: will be used for configurations scheduling requests.
4504: ----------------------------------------------------------------*/
4505: PROCEDURE Process_Scheduling_Request
4506: ( p_request_ind IN NUMBER
4507: ,p_request_rec IN OE_Order_PUB.request_rec_type
4508: ,x_return_status OUT NOCOPY VARCHAR2)
4509:
4510: IS
4511: I NUMBER;

Line 4515: l_request_tbl OE_Order_PUB.request_tbl_type;

4511: I NUMBER;
4512: K NUMBER;
4513: l_ato_line_id NUMBER;
4514: l_res_changes VARCHAR2(1);
4515: l_request_tbl OE_Order_PUB.request_tbl_type;
4516: --
4517: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4518: --
4519: BEGIN

Line 4653: ,p_request_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.request_rec_type

4649:
4650: ----------------------------------------------------------------*/
4651: PROCEDURE Check_Pricing_Request
4652: ( p_request_ind IN NUMBER
4653: ,p_request_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.request_rec_type
4654: ,x_log_request OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4655: )
4656:
4657: IS

Line 4665: l_request OE_Order_PUB.REQUEST_REC_TYPE;

4661: l_request_search_rslt4 VARCHAR2(1);
4662: l_return_status VARCHAR2(1);
4663: l_request_ind NUMBER;
4664: l_req_entity_ind NUMBER;
4665: l_request OE_Order_PUB.REQUEST_REC_TYPE;
4666: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
4667: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4668:
4669: BEGIN

Line 4666: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;

4662: l_return_status VARCHAR2(1);
4663: l_request_ind NUMBER;
4664: l_req_entity_ind NUMBER;
4665: l_request OE_Order_PUB.REQUEST_REC_TYPE;
4666: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
4667: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4668:
4669: BEGIN
4670: