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_HOLD_DEFINITIONS

Line 118: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

114:
115:
116: Procedure Apply_Holds (
117: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
118: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
119: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
120: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
121: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
122: x_return_status OUT NOCOPY VARCHAR2,

Line 142: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

138:
139:
140: Procedure Release_Holds (
141: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
142: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
143: DEFAULT NULL,
144: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
145: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE DEFAULT NULL,
146: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694

Line 203: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

199:
200: procedure process_apply_holds_lines (
201: p_num_of_records IN NUMBER
202: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
203: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
204: ,p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
205: ,p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
206: ,x_return_status OUT NOCOPY VARCHAR2
207:

Line 217: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

213:
214: procedure process_apply_holds_orders (
215: p_num_of_records IN NUMBER
216: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
217: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
218: ,p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
219: ,p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
220: ,x_return_status OUT NOCOPY VARCHAR2
221:

Line 231: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

227:
228: procedure process_release_holds_lines (
229: p_num_of_records IN NUMBER
230: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
231: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
232: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
233: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
234: ,x_return_status OUT NOCOPY VARCHAR2
235:

Line 245: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

241:
242: procedure process_release_holds_orders (
243: p_num_of_records IN NUMBER
244: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
245: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
246: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
247: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
248: ,x_return_status OUT NOCOPY VARCHAR2
249:

Line 279: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

275: ,x_msg_data OUT NOCOPY VARCHAR2
276:
277: );
278: function check_authorization (
279: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
280: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
281: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
282: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
283: x_return_status OUT NOCOPY VARCHAR2,

Line 346: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

342: /*Added new overloaded procedure Process_release_holds_lines for ER 1373910 - Progress WF on hold release */
343: procedure process_release_holds_lines (
344: p_num_of_records IN NUMBER
345: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
346: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
347: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
348: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
349: ,p_wf_release_action IN VARCHAR2
350: ,x_return_status OUT NOCOPY VARCHAR2

Line 358: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

354: /*Added new overloaded procedure Process_release_holds_orders for ER 1373910 - Progress WF on hold release */
355: procedure process_release_holds_orders (
356: p_num_of_records IN NUMBER
357: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
358: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
359: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
360: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
361: ,p_wf_release_action IN VARCHAR2
362: ,x_return_status OUT NOCOPY VARCHAR2