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_VERIFY_PAYMENT_PUB dependencies on OE_HOLDS_PVT

Line 60: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

56: -- bug 4339864
57: PRAGMA AUTONOMOUS_TRANSACTION;
58:
59: l_hold_id NUMBER;
60: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
61: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
62: l_hold_result VARCHAR2(30);
63: l_line_ind VARCHAR2(240);
64: l_line_number NUMBER;

Line 61: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

57: PRAGMA AUTONOMOUS_TRANSACTION;
58:
59: l_hold_id NUMBER;
60: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
61: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
62: l_hold_result VARCHAR2(30);
63: l_line_ind VARCHAR2(240);
64: l_line_number NUMBER;
65: l_shipment_number NUMBER;

Line 332: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

328: l_msg_count NUMBER := 0;
329: l_msg_data VARCHAR2(2000);
330: l_return_status VARCHAR2(30);
331: l_release_reason VARCHAR2(30);
332: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
333: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
334: l_hold_result VARCHAR2(30);
335:
336: CURSOR c_billto_lines IS

Line 333: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

329: l_msg_data VARCHAR2(2000);
330: l_return_status VARCHAR2(30);
331: l_release_reason VARCHAR2(30);
332: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
333: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
334: l_hold_result VARCHAR2(30);
335:
336: CURSOR c_billto_lines IS
337: SELECT line_id

Line 470: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;

466: l_return_status VARCHAR2(30);
467: l_hold_result VARCHAR2(30);
468: l_attribute VARCHAR2(30);
469: l_line_number NUMBER;
470: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
471:
472: l_apply_hold VARCHAR2(1) := 'N';
473:
474: CURSOR c_billto_lines IS

Line 2140: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

2136: l_msg_count NUMBER := 0;
2137: l_msg_data VARCHAR2(2000);
2138: l_return_status VARCHAR2(30);
2139: l_release_reason VARCHAR2(30);
2140: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2141: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2142: --
2143: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2144: --

Line 2141: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

2137: l_msg_data VARCHAR2(2000);
2138: l_return_status VARCHAR2(30);
2139: l_release_reason VARCHAR2(30);
2140: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2141: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2142: --
2143: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2144: --
2145: BEGIN

Line 2403: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;

2399: l_msg_count NUMBER := 0;
2400: l_msg_data VARCHAR2(2000);
2401: l_return_status VARCHAR2(30);
2402:
2403: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
2404: --
2405: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2406: --
2407: BEGIN

Line 2535: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;

2531: l_msg_count NUMBER := 0;
2532: l_msg_data VARCHAR2(2000);
2533: l_return_status VARCHAR2(30);
2534:
2535: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
2536: --
2537: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2538: --
2539: BEGIN

Line 7707: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

7703: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7704: ) IS
7705:
7706: l_hold_id NUMBER;
7707: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7708: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7709: l_hold_result VARCHAR2(30);
7710: l_msg_count NUMBER := 0;
7711: l_msg_data VARCHAR2(2000);

Line 7708: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

7704: ) IS
7705:
7706: l_hold_id NUMBER;
7707: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7708: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7709: l_hold_result VARCHAR2(30);
7710: l_msg_count NUMBER := 0;
7711: l_msg_data VARCHAR2(2000);
7712: l_return_status VARCHAR2(30);

Line 7941: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

7937: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7938: ) IS
7939:
7940: l_hold_id NUMBER;
7941: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7942: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7943: l_hold_result VARCHAR2(30);
7944: l_line_ind VARCHAR2(240);
7945: l_line_number NUMBER;

Line 7942: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

7938: ) IS
7939:
7940: l_hold_id NUMBER;
7941: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7942: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
7943: l_hold_result VARCHAR2(30);
7944: l_line_ind VARCHAR2(240);
7945: l_line_number NUMBER;
7946: l_shipment_number NUMBER;