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.

[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on OE_ORDER_PUB

Line 2884: l_header_rec OE_Order_PUB.Header_Rec_Type;

2880: WHERE ohd.activity_name IS NULL
2881: AND ohd.hold_id = ohs.hold_id
2882: AND ohs.hold_source_id = p_hld_src_id);
2883:
2884: l_header_rec OE_Order_PUB.Header_Rec_Type;
2885: l_line_rec OE_Order_PUB.Line_Rec_Type;*/
2886: -- GENESIS --
2887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2888: BEGIN

Line 2885: l_line_rec OE_Order_PUB.Line_Rec_Type;*/

2881: AND ohd.hold_id = ohs.hold_id
2882: AND ohs.hold_source_id = p_hld_src_id);
2883:
2884: l_header_rec OE_Order_PUB.Header_Rec_Type;
2885: l_line_rec OE_Order_PUB.Line_Rec_Type;*/
2886: -- GENESIS --
2887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2888: BEGIN
2889: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5940: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

5936: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5937: )
5938: IS
5939:
5940: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
5941: l_line_rec OE_ORDER_PUB.line_rec_type;
5942: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_lines';
5943: l_line_id NUMBER;
5944: l_return_status VARCHAR2(30);

Line 5941: l_line_rec OE_ORDER_PUB.line_rec_type;

5937: )
5938: IS
5939:
5940: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
5941: l_line_rec OE_ORDER_PUB.line_rec_type;
5942: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_lines';
5943: l_line_id NUMBER;
5944: l_return_status VARCHAR2(30);
5945: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 6192: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;

6188: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
6189: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6190: )
6191: IS
6192: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6193: l_line_rec OE_ORDER_PUB.line_rec_type;
6194: --l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
6195: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_orders';
6196: l_header_id NUMBER;

Line 6193: l_line_rec OE_ORDER_PUB.line_rec_type;

6189: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6190: )
6191: IS
6192: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6193: l_line_rec OE_ORDER_PUB.line_rec_type;
6194: --l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
6195: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_orders';
6196: l_header_id NUMBER;
6197: l_return_status VARCHAR2(30);

Line 6194: --l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

6190: )
6191: IS
6192: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6193: l_line_rec OE_ORDER_PUB.line_rec_type;
6194: --l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
6195: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_orders';
6196: l_header_id NUMBER;
6197: l_return_status VARCHAR2(30);
6198: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 6433: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;

6429: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6430: )
6431: IS
6432:
6433: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6434: l_line_rec OE_ORDER_PUB.line_rec_type;
6435: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_lines';
6436: l_line_id NUMBER;
6437: l_return_status VARCHAR2(30);

Line 6434: l_line_rec OE_ORDER_PUB.line_rec_type;

6430: )
6431: IS
6432:
6433: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6434: l_line_rec OE_ORDER_PUB.line_rec_type;
6435: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_lines';
6436: l_line_id NUMBER;
6437: l_return_status VARCHAR2(30);
6438: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 6608: l_line_rec OE_ORDER_PUB.line_rec_type;

6604: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
6605: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6606: )
6607: IS
6608: l_line_rec OE_ORDER_PUB.line_rec_type;
6609: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_orders';
6610: l_header_id NUMBER;
6611: l_return_status VARCHAR2(30);
6612: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 7190: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;

7186: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7187: )
7188: IS
7189:
7190: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
7191: l_line_rec OE_ORDER_PUB.line_rec_type;
7192: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_lines';
7193: l_line_id NUMBER;
7194: l_return_status VARCHAR2(30);

Line 7191: l_line_rec OE_ORDER_PUB.line_rec_type;

7187: )
7188: IS
7189:
7190: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
7191: l_line_rec OE_ORDER_PUB.line_rec_type;
7192: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_lines';
7193: l_line_id NUMBER;
7194: l_return_status VARCHAR2(30);
7195: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 7398: l_line_rec OE_ORDER_PUB.line_rec_type;

7394: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
7395: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7396: )
7397: IS
7398: l_line_rec OE_ORDER_PUB.line_rec_type;
7399: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_orders';
7400: l_header_id NUMBER;
7401: l_return_status VARCHAR2(30);
7402: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 8157: l_header_rec OE_Order_PUB.Header_Rec_Type;

8153: AND ohs.org_id = p_org_id
8154: AND ohs.hold_source_id = p_hld_src_id);
8155: --ER#7479609 end
8156:
8157: l_header_rec OE_Order_PUB.Header_Rec_Type;
8158: l_line_rec OE_Order_PUB.Line_Rec_Type;
8159: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8160: -- GENESIS --
8161: BEGIN

Line 8158: l_line_rec OE_Order_PUB.Line_Rec_Type;

8154: AND ohs.hold_source_id = p_hld_src_id);
8155: --ER#7479609 end
8156:
8157: l_header_rec OE_Order_PUB.Header_Rec_Type;
8158: l_line_rec OE_Order_PUB.Line_Rec_Type;
8159: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8160: -- GENESIS --
8161: BEGIN
8162: x_return_status := FND_API.G_RET_STS_SUCCESS;