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

Line 1893: l_header_rec oe_order_pub.header_rec_type;

1889: l_chk_hold VARCHAR2(1) := 'N';
1890:
1891: -- Bug 8463870
1892: l_header_id number;
1893: l_header_rec oe_order_pub.header_rec_type;
1894:
1895: l_line_id number;
1896: l_line_rec oe_order_pub.line_rec_type;
1897:

Line 1896: l_line_rec oe_order_pub.line_rec_type;

1892: l_header_id number;
1893: l_header_rec oe_order_pub.header_rec_type;
1894:
1895: l_line_id number;
1896: l_line_rec oe_order_pub.line_rec_type;
1897:
1898: cursor header_line_id_cur(p_ord_hld_id in number) is
1899: select ohld.header_id,
1900: ohld.line_id

Line 3339: l_header_rec OE_Order_PUB.Header_Rec_Type;

3335: WHERE ohd.activity_name IS NULL
3336: AND ohd.hold_id = ohs.hold_id
3337: AND ohs.hold_source_id = p_hld_src_id);
3338:
3339: l_header_rec OE_Order_PUB.Header_Rec_Type;
3340: l_line_rec OE_Order_PUB.Line_Rec_Type;*/
3341: -- GENESIS --
3342: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3343: BEGIN

Line 3340: l_line_rec OE_Order_PUB.Line_Rec_Type;*/

3336: AND ohd.hold_id = ohs.hold_id
3337: AND ohs.hold_source_id = p_hld_src_id);
3338:
3339: l_header_rec OE_Order_PUB.Header_Rec_Type;
3340: l_line_rec OE_Order_PUB.Line_Rec_Type;*/
3341: -- GENESIS --
3342: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3343: BEGIN
3344: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5255: l_line_rec oe_order_pub.line_rec_type;

5251: l_chk_hld VARCHAR2(1) := 'N';
5252:
5253: -- Bug 8463870
5254: l_line_id number;
5255: l_line_rec oe_order_pub.line_rec_type;
5256:
5257: l_header_id number;
5258: l_header_rec oe_order_pub.header_rec_type;
5259:

Line 5258: l_header_rec oe_order_pub.header_rec_type;

5254: l_line_id number;
5255: l_line_rec oe_order_pub.line_rec_type;
5256:
5257: l_header_id number;
5258: l_header_rec oe_order_pub.header_rec_type;
5259:
5260: cursor header_line_id_cur(p_ord_hld_id in number) is
5261: select ohld.header_id,
5262: ohld.line_id

Line 6696: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

6692: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6693: )
6694: IS
6695:
6696: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6697: l_line_rec OE_ORDER_PUB.line_rec_type;
6698: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_lines';
6699: l_line_id NUMBER;
6700: l_return_status VARCHAR2(30);

Line 6697: l_line_rec OE_ORDER_PUB.line_rec_type;

6693: )
6694: IS
6695:
6696: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6697: l_line_rec OE_ORDER_PUB.line_rec_type;
6698: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_lines';
6699: l_line_id NUMBER;
6700: l_return_status VARCHAR2(30);
6701: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 6949: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;

6945: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
6946: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6947: )
6948: IS
6949: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6950: l_line_rec OE_ORDER_PUB.line_rec_type;
6951: --l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
6952: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_orders';
6953: l_header_id NUMBER;

Line 6950: l_line_rec OE_ORDER_PUB.line_rec_type;

6946: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6947: )
6948: IS
6949: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6950: l_line_rec OE_ORDER_PUB.line_rec_type;
6951: --l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
6952: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_orders';
6953: l_header_id NUMBER;
6954: l_return_status VARCHAR2(30);

Line 6951: --l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

6947: )
6948: IS
6949: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
6950: l_line_rec OE_ORDER_PUB.line_rec_type;
6951: --l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
6952: l_api_name CONSTANT VARCHAR2(30) := 'process_apply_holds_orders';
6953: l_header_id NUMBER;
6954: l_return_status VARCHAR2(30);
6955: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 7191: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;

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

Line 7192: l_line_rec OE_ORDER_PUB.line_rec_type;

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

Line 7367: l_line_rec OE_ORDER_PUB.line_rec_type;

7363: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
7364: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7365: )
7366: IS
7367: l_line_rec OE_ORDER_PUB.line_rec_type;
7368: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_orders';
7369: l_header_id NUMBER;
7370: l_return_status VARCHAR2(30);
7371: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 7974: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;

7970: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7971: )
7972: IS
7973:
7974: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
7975: l_line_rec OE_ORDER_PUB.line_rec_type;
7976: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_lines';
7977: l_line_id NUMBER;
7978: l_return_status VARCHAR2(30);

Line 7975: l_line_rec OE_ORDER_PUB.line_rec_type;

7971: )
7972: IS
7973:
7974: --l_header_rec OE_ORDER_PUB.Header_Rec_Type;
7975: l_line_rec OE_ORDER_PUB.line_rec_type;
7976: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_lines';
7977: l_line_id NUMBER;
7978: l_return_status VARCHAR2(30);
7979: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 8183: l_line_rec OE_ORDER_PUB.line_rec_type;

8179: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
8180: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8181: )
8182: IS
8183: l_line_rec OE_ORDER_PUB.line_rec_type;
8184: l_api_name CONSTANT VARCHAR2(30) := 'process_release_holds_orders';
8185: l_header_id NUMBER;
8186: l_return_status VARCHAR2(30);
8187: l_order_tbl OE_HOLDS_PVT.order_tbl_type;

Line 9013: l_header_rec OE_Order_PUB.Header_Rec_Type;

9009: AND ohs.org_id = p_org_id
9010: AND ohs.hold_source_id = p_hld_src_id);
9011: --ER#7479609 end
9012:
9013: l_header_rec OE_Order_PUB.Header_Rec_Type;
9014: l_line_rec OE_Order_PUB.Line_Rec_Type;
9015: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9016: -- GENESIS --
9017: -- 16053361

Line 9014: l_line_rec OE_Order_PUB.Line_Rec_Type;

9010: AND ohs.hold_source_id = p_hld_src_id);
9011: --ER#7479609 end
9012:
9013: l_header_rec OE_Order_PUB.Header_Rec_Type;
9014: l_line_rec OE_Order_PUB.Line_Rec_Type;
9015: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9016: -- GENESIS --
9017: -- 16053361
9018: l_nameVal_tbl OE_ORDER_UTIL.nameVal_Tbl_Type;