194: return varchar2;
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
208: );
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
222: );
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
236: );
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
336:
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
348: );
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