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 61: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

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

Line 62: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

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

Line 398: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

394: l_msg_count NUMBER := 0;
395: l_msg_data VARCHAR2(2000);
396: l_return_status VARCHAR2(30);
397: l_release_reason VARCHAR2(30);
398: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
399: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
400: l_hold_result VARCHAR2(30);
401:
402: CURSOR c_billto_lines IS

Line 399: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

395: l_msg_data VARCHAR2(2000);
396: l_return_status VARCHAR2(30);
397: l_release_reason VARCHAR2(30);
398: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
399: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
400: l_hold_result VARCHAR2(30);
401:
402: CURSOR c_billto_lines IS
403: SELECT line_id

Line 536: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;

532: l_return_status VARCHAR2(30);
533: l_hold_result VARCHAR2(30);
534: l_attribute VARCHAR2(30);
535: l_line_number NUMBER;
536: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
537:
538: l_apply_hold VARCHAR2(1) := 'N';
539:
540: CURSOR c_billto_lines IS

Line 2213: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

2209: l_msg_count NUMBER := 0;
2210: l_msg_data VARCHAR2(2000);
2211: l_return_status VARCHAR2(30);
2212: l_release_reason VARCHAR2(30);
2213: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2214: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2215: --
2216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2217: --

Line 2214: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

2210: l_msg_data VARCHAR2(2000);
2211: l_return_status VARCHAR2(30);
2212: l_release_reason VARCHAR2(30);
2213: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2214: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2215: --
2216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2217: --
2218: BEGIN

Line 2476: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;

2472: l_msg_count NUMBER := 0;
2473: l_msg_data VARCHAR2(2000);
2474: l_return_status VARCHAR2(30);
2475:
2476: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
2477: --
2478: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2479: --
2480: BEGIN

Line 2608: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;

2604: l_msg_count NUMBER := 0;
2605: l_msg_data VARCHAR2(2000);
2606: l_return_status VARCHAR2(30);
2607:
2608: l_hold_source_rec OE_Holds_PVT.Hold_Source_REC_type;
2609: --
2610: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2611: --
2612: BEGIN

Line 8351: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

8347: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8348: ) IS
8349:
8350: l_hold_id NUMBER;
8351: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8352: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
8353: l_hold_result VARCHAR2(30);
8354: l_msg_count NUMBER := 0;
8355: l_msg_data VARCHAR2(2000);

Line 8352: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

8348: ) IS
8349:
8350: l_hold_id NUMBER;
8351: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8352: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
8353: l_hold_result VARCHAR2(30);
8354: l_msg_count NUMBER := 0;
8355: l_msg_data VARCHAR2(2000);
8356: l_return_status VARCHAR2(30);

Line 8585: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

8581: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8582: ) IS
8583:
8584: l_hold_id NUMBER;
8585: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8586: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
8587: l_hold_result VARCHAR2(30);
8588: l_line_ind VARCHAR2(240);
8589: l_line_number NUMBER;

Line 8586: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;

8582: ) IS
8583:
8584: l_hold_id NUMBER;
8585: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8586: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
8587: l_hold_result VARCHAR2(30);
8588: l_line_ind VARCHAR2(240);
8589: l_line_number NUMBER;
8590: l_shipment_number NUMBER;