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 9: g_requesting_entities OE_Order_PUB.Requesting_Entity_Tbl_Type;

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Delayed_Requests_PVT';
7: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8233604
8:
9: g_requesting_entities OE_Order_PUB.Requesting_Entity_Tbl_Type;
10: G_MAX_REQUESTS NUMBER := 10000;
11:
12: /* Local Procedures */
13: /* Local procedure to check if a request exists for a given entity, request

Line 36: ,p_request_rec IN OE_Order_PUB.request_rec_type

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

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

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

Line 172: l_request_rec OE_Order_PUB.request_rec_type;

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

Line 180: l_set_request OE_Order_PUB.request_tbl_type;

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

Line 181: l_sch_set_tbl OE_Order_PUB.request_tbl_type;

177: l_req_entity_ind number;
178: l_req_ind NUMBER; --TaxER
179: l_set_index NUMBER;
180: l_set_request OE_Order_PUB.request_tbl_type;
181: l_sch_set_tbl OE_Order_PUB.request_tbl_type;
182: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
183: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
184: l_index NUMBER;
185: l_d_index NUMBER;

Line 182: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;

178: l_req_ind NUMBER; --TaxER
179: l_set_index NUMBER;
180: l_set_request OE_Order_PUB.request_tbl_type;
181: l_sch_set_tbl OE_Order_PUB.request_tbl_type;
182: l_deleted_options_tbl OE_Order_PUB.request_tbl_type;
183: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
184: l_index NUMBER;
185: l_d_index NUMBER;
186: l_u_index NUMBER;

Line 183: l_updated_options_tbl OE_Order_PUB.request_tbl_type;

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

Line 189: l_cto_request_rec OE_Order_PUB.request_rec_type;

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

Line 190: l_cto_request_tbl OE_Order_PUB.request_tbl_type;

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

Line 191: l_cto_split_tbl OE_Order_PUB.request_tbl_type;

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

Line 192: l_cto_decimal_tbl OE_Order_PUB.request_tbl_type;

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

Line 193: l_line_Tbl OE_ORDER_PUB.line_Tbl_type;

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

Line 194: l_prc_adj_request OE_ORDER_PUB.request_tbl_type;

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

Line 221: l_header_rec OE_Order_PUB.Header_Rec_Type;

217: l_otm_volume NUMBER; --BUG#10052614
218: l_dynamic_call varchar2(1000); -- Bug#10052614
219: l_org_id NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id;
220: --TaxER Start
221: l_header_rec OE_Order_PUB.Header_Rec_Type;
222: l_current_event number := 0;
223: l_tax_calculation_event_code number := 0;
224: --TaxER End
225:

Line 2265: l_request OE_Order_PUB.REQUEST_REC_TYPE;

2261: l_request_search_rslt VARCHAR2(1);
2262: l_return_status VARCHAR2(1);
2263: l_request_ind NUMBER;
2264: l_req_entity_ind NUMBER;
2265: l_request OE_Order_PUB.REQUEST_REC_TYPE;
2266: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
2267: l_log_request VARCHAR2(1);
2268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2269: BEGIN

Line 2266: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;

2262: l_return_status VARCHAR2(1);
2263: l_request_ind NUMBER;
2264: l_req_entity_ind NUMBER;
2265: l_request OE_Order_PUB.REQUEST_REC_TYPE;
2266: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
2267: l_log_request VARCHAR2(1);
2268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2269: BEGIN
2270:

Line 4023: p_x_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type,

4019: **/
4020:
4021: PROCEDURE Process_Order_Actions
4022: (p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4023: p_x_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type,
4024: p_process_WF_requests IN boolean DEFAULT TRUE
4025: )
4026: IS
4027: l_request_rec OE_Order_PUB.request_rec_type;

Line 4027: l_request_rec OE_Order_PUB.request_rec_type;

4023: p_x_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type,
4024: p_process_WF_requests IN boolean DEFAULT TRUE
4025: )
4026: IS
4027: l_request_rec OE_Order_PUB.request_rec_type;
4028: l_return_status VARCHAR2(1);
4029: --
4030: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4031: --

Line 4048: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

4044: --comm rej l_reject_on_risk_failure VARCHAR2(1);
4045: l_msg_count NUMBER;
4046: l_msg_data VARCHAR2(4000);
4047: l_result_out VARCHAR2(30);
4048: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
4049: --R12 CVV2
4050:
4051: -- ER 7243028
4052: l_lines_count NUMBER;

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

4053: l_lines_list VARCHAR2(4000);
4054:
4055: BEGIN
4056: IF l_debug_level > 0 THEN
4057: oe_debug_pub.ADD('Entering OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);
4058: END IF;
4059:
4060: IF NOT oe_globals.g_call_process_req THEN --9354229
4061: IF l_debug_level > 0 THEN

Line 4062: oe_debug_pub.add( 'EXIT OE_ORDER_PUB.PROCESS_ORDER_ACTIONS' , 1 ) ;

4058: END IF;
4059:
4060: IF NOT oe_globals.g_call_process_req THEN --9354229
4061: IF l_debug_level > 0 THEN
4062: oe_debug_pub.add( 'EXIT OE_ORDER_PUB.PROCESS_ORDER_ACTIONS' , 1 ) ;
4063: END IF;
4064: RETURN;
4065: END IF;
4066:

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

4727: oe_order_pvt.set_recursion_mode(p_Entity_Code => 10,
4728: p_In_out => 0);
4729: END IF;
4730: IF l_debug_level > 0 THEN
4731: oe_debug_pub.ADD('Exiting OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);
4732: END IF;
4733: OE_MSG_PUB.reset_msg_context(l_request_rec.entity_code);
4734:
4735: EXCEPTION

Line 4959: ,p_request_rec IN OE_Order_PUB.request_rec_type

4955: will be used for configurations scheduling requests.
4956: ----------------------------------------------------------------*/
4957: PROCEDURE Process_Scheduling_Request
4958: ( p_request_ind IN NUMBER
4959: ,p_request_rec IN OE_Order_PUB.request_rec_type
4960: ,x_return_status OUT NOCOPY VARCHAR2)
4961:
4962: IS
4963: I NUMBER;

Line 4967: l_request_tbl OE_Order_PUB.request_tbl_type;

4963: I NUMBER;
4964: K NUMBER;
4965: l_ato_line_id NUMBER;
4966: l_res_changes VARCHAR2(1);
4967: l_request_tbl OE_Order_PUB.request_tbl_type;
4968: --
4969: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4970: --
4971: BEGIN

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

5101:
5102: ----------------------------------------------------------------*/
5103: PROCEDURE Check_Pricing_Request
5104: ( p_request_ind IN NUMBER
5105: ,p_request_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.request_rec_type
5106: ,x_log_request OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5107: )
5108:
5109: IS

Line 5117: l_request OE_Order_PUB.REQUEST_REC_TYPE;

5113: l_request_search_rslt4 VARCHAR2(1);
5114: l_return_status VARCHAR2(1);
5115: l_request_ind NUMBER;
5116: l_req_entity_ind NUMBER;
5117: l_request OE_Order_PUB.REQUEST_REC_TYPE;
5118: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
5119: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5120:
5121: BEGIN

Line 5118: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;

5114: l_return_status VARCHAR2(1);
5115: l_request_ind NUMBER;
5116: l_req_entity_ind NUMBER;
5117: l_request OE_Order_PUB.REQUEST_REC_TYPE;
5118: l_req_entity OE_Order_PUB.Requesting_Entity_Rec_Type;
5119: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5120:
5121: BEGIN
5122: