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 117: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

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

Line 139: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

135:
136:
137: Procedure Release_Holds (
138: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
139: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
140: DEFAULT NULL,
141: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
142: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE DEFAULT NULL,
143: x_return_status OUT NOCOPY VARCHAR2,

Line 199: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

195:
196: procedure process_apply_holds_lines (
197: p_num_of_records IN NUMBER
198: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
199: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
200: ,p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
201: ,p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
202: ,x_return_status OUT NOCOPY VARCHAR2
203:

Line 213: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

209:
210: procedure process_apply_holds_orders (
211: p_num_of_records IN NUMBER
212: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
213: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
214: ,p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
215: ,p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
216: ,x_return_status OUT NOCOPY VARCHAR2
217:

Line 227: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

223:
224: procedure process_release_holds_lines (
225: p_num_of_records IN NUMBER
226: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
227: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
228: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
229: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
230: ,x_return_status OUT NOCOPY VARCHAR2
231:

Line 241: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

237:
238: procedure process_release_holds_orders (
239: p_num_of_records IN NUMBER
240: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
241: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
242: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
243: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
244: ,x_return_status OUT NOCOPY VARCHAR2
245:

Line 275: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

271: ,x_msg_data OUT NOCOPY VARCHAR2
272:
273: );
274: function check_authorization (
275: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
276: p_authorized_action_code IN OE_HOLD_AUTHORIZATIONS.AUTHORIZED_ACTION_CODE%TYPE,
277: p_responsibility_id IN OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE,
278: p_application_id IN OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE,
279: x_return_status OUT NOCOPY VARCHAR2,

Line 341: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

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

Line 353: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

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