176: -- ----------------------------------------------------------------------------
177: --
178: PROCEDURE chk_approval_comp_dates
179: (p_approval_comp_id
180: IN hxc_approval_comps.approval_comp_id%TYPE
181: ,p_start_date
182: IN hxc_approval_comps.start_date%TYPE
183: ,p_end_date
184: IN hxc_approval_comps.end_date%TYPE
178: PROCEDURE chk_approval_comp_dates
179: (p_approval_comp_id
180: IN hxc_approval_comps.approval_comp_id%TYPE
181: ,p_start_date
182: IN hxc_approval_comps.start_date%TYPE
183: ,p_end_date
184: IN hxc_approval_comps.end_date%TYPE
185: );
186: --
180: IN hxc_approval_comps.approval_comp_id%TYPE
181: ,p_start_date
182: IN hxc_approval_comps.start_date%TYPE
183: ,p_end_date
184: IN hxc_approval_comps.end_date%TYPE
185: );
186: --
187: -- ----------------------------------------------------------------------------
188: -- |-< chk_invalid_dates_create >---------------------------------------------|
219: -- ----------------------------------------------------------------------------
220: --
221: PROCEDURE chk_invalid_dates_create
222: ( p_approval_style_id
223: IN hxc_approval_comps.approval_style_id%TYPE
224: ,p_time_recipient_id
225: IN hxc_approval_comps.time_recipient_id%TYPE
226: ,p_start_date
227: IN hxc_approval_comps.start_date%TYPE
221: PROCEDURE chk_invalid_dates_create
222: ( p_approval_style_id
223: IN hxc_approval_comps.approval_style_id%TYPE
224: ,p_time_recipient_id
225: IN hxc_approval_comps.time_recipient_id%TYPE
226: ,p_start_date
227: IN hxc_approval_comps.start_date%TYPE
228: ,p_end_date
229: IN hxc_approval_comps.end_date%TYPE
223: IN hxc_approval_comps.approval_style_id%TYPE
224: ,p_time_recipient_id
225: IN hxc_approval_comps.time_recipient_id%TYPE
226: ,p_start_date
227: IN hxc_approval_comps.start_date%TYPE
228: ,p_end_date
229: IN hxc_approval_comps.end_date%TYPE
230: );
231: --
225: IN hxc_approval_comps.time_recipient_id%TYPE
226: ,p_start_date
227: IN hxc_approval_comps.start_date%TYPE
228: ,p_end_date
229: IN hxc_approval_comps.end_date%TYPE
230: );
231: --
232: -- ----------------------------------------------------------------------------
233: -- |-< chk_invalid_dates_update >---------------------------------------------|
265: -- ----------------------------------------------------------------------------
266: --
267: PROCEDURE chk_invalid_dates_update
268: ( p_approval_comp_id
269: IN hxc_approval_comps.approval_comp_id%TYPE
270: ,p_approval_style_id
271: IN hxc_approval_comps.approval_style_id%TYPE
272: ,p_time_recipient_id
273: IN hxc_approval_comps.time_recipient_id%TYPE
267: PROCEDURE chk_invalid_dates_update
268: ( p_approval_comp_id
269: IN hxc_approval_comps.approval_comp_id%TYPE
270: ,p_approval_style_id
271: IN hxc_approval_comps.approval_style_id%TYPE
272: ,p_time_recipient_id
273: IN hxc_approval_comps.time_recipient_id%TYPE
274: ,p_start_date
275: IN hxc_approval_comps.start_date%TYPE
269: IN hxc_approval_comps.approval_comp_id%TYPE
270: ,p_approval_style_id
271: IN hxc_approval_comps.approval_style_id%TYPE
272: ,p_time_recipient_id
273: IN hxc_approval_comps.time_recipient_id%TYPE
274: ,p_start_date
275: IN hxc_approval_comps.start_date%TYPE
276: ,p_end_date
277: IN hxc_approval_comps.end_date%TYPE
271: IN hxc_approval_comps.approval_style_id%TYPE
272: ,p_time_recipient_id
273: IN hxc_approval_comps.time_recipient_id%TYPE
274: ,p_start_date
275: IN hxc_approval_comps.start_date%TYPE
276: ,p_end_date
277: IN hxc_approval_comps.end_date%TYPE
278: );
279:
273: IN hxc_approval_comps.time_recipient_id%TYPE
274: ,p_start_date
275: IN hxc_approval_comps.start_date%TYPE
276: ,p_end_date
277: IN hxc_approval_comps.end_date%TYPE
278: );
279:
280: --
281: -- ----------------------------------------------------------------------------
312: -- ----------------------------------------------------------------------------
313: --
314: PROCEDURE chk_overlapping_dates_create
315: (p_approval_style_id
316: IN hxc_approval_comps.approval_style_id%TYPE
317: ,p_time_recipient_id
318: IN hxc_approval_comps.time_recipient_id%TYPE
319: ,p_start_date
320: IN hxc_approval_comps.start_date%TYPE
314: PROCEDURE chk_overlapping_dates_create
315: (p_approval_style_id
316: IN hxc_approval_comps.approval_style_id%TYPE
317: ,p_time_recipient_id
318: IN hxc_approval_comps.time_recipient_id%TYPE
319: ,p_start_date
320: IN hxc_approval_comps.start_date%TYPE
321: ,p_end_date
322: IN hxc_approval_comps.end_date%TYPE
316: IN hxc_approval_comps.approval_style_id%TYPE
317: ,p_time_recipient_id
318: IN hxc_approval_comps.time_recipient_id%TYPE
319: ,p_start_date
320: IN hxc_approval_comps.start_date%TYPE
321: ,p_end_date
322: IN hxc_approval_comps.end_date%TYPE
323: );
324: --
318: IN hxc_approval_comps.time_recipient_id%TYPE
319: ,p_start_date
320: IN hxc_approval_comps.start_date%TYPE
321: ,p_end_date
322: IN hxc_approval_comps.end_date%TYPE
323: );
324: --
325: -- ----------------------------------------------------------------------------
326: -- |-< chk_overlapping_dates_create >-----------------------------------------|
360: -- ----------------------------------------------------------------------------
361: --
362: PROCEDURE chk_overlapping_dates_create
363: (p_approval_style_id
364: IN hxc_approval_comps.approval_style_id%TYPE
365: ,p_time_recipient_id
366: IN hxc_approval_comps.time_recipient_id%TYPE
367: ,p_start_date
368: IN hxc_approval_comps.start_date%TYPE
362: PROCEDURE chk_overlapping_dates_create
363: (p_approval_style_id
364: IN hxc_approval_comps.approval_style_id%TYPE
365: ,p_time_recipient_id
366: IN hxc_approval_comps.time_recipient_id%TYPE
367: ,p_start_date
368: IN hxc_approval_comps.start_date%TYPE
369: ,p_end_date
370: IN hxc_approval_comps.end_date%TYPE
364: IN hxc_approval_comps.approval_style_id%TYPE
365: ,p_time_recipient_id
366: IN hxc_approval_comps.time_recipient_id%TYPE
367: ,p_start_date
368: IN hxc_approval_comps.start_date%TYPE
369: ,p_end_date
370: IN hxc_approval_comps.end_date%TYPE
371: ,p_clashing_id
372: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
366: IN hxc_approval_comps.time_recipient_id%TYPE
367: ,p_start_date
368: IN hxc_approval_comps.start_date%TYPE
369: ,p_end_date
370: IN hxc_approval_comps.end_date%TYPE
371: ,p_clashing_id
372: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
373: ,p_clashing_ovn
374: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
368: IN hxc_approval_comps.start_date%TYPE
369: ,p_end_date
370: IN hxc_approval_comps.end_date%TYPE
371: ,p_clashing_id
372: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
373: ,p_clashing_ovn
374: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
375: ,p_clashing_start_date
376: OUT NOCOPY hxc_approval_comps.start_date%TYPE
370: IN hxc_approval_comps.end_date%TYPE
371: ,p_clashing_id
372: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
373: ,p_clashing_ovn
374: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
375: ,p_clashing_start_date
376: OUT NOCOPY hxc_approval_comps.start_date%TYPE
377: ,p_clashing_end_date
378: OUT NOCOPY hxc_approval_comps.end_date%TYPE
372: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
373: ,p_clashing_ovn
374: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
375: ,p_clashing_start_date
376: OUT NOCOPY hxc_approval_comps.start_date%TYPE
377: ,p_clashing_end_date
378: OUT NOCOPY hxc_approval_comps.end_date%TYPE
379: );
380: --
374: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
375: ,p_clashing_start_date
376: OUT NOCOPY hxc_approval_comps.start_date%TYPE
377: ,p_clashing_end_date
378: OUT NOCOPY hxc_approval_comps.end_date%TYPE
379: );
380: --
381: -- ----------------------------------------------------------------------------
382: -- |-< chk_overlapping_dates_update >-----------------------------------------|
413: -- ----------------------------------------------------------------------------
414: --
415: PROCEDURE chk_overlapping_dates_update
416: (p_approval_comp_id
417: IN hxc_approval_comps.approval_comp_id%TYPE
418: ,p_approval_style_id
419: IN hxc_approval_comps.approval_style_id%TYPE
420: ,p_time_recipient_id
421: IN hxc_approval_comps.time_recipient_id%TYPE
415: PROCEDURE chk_overlapping_dates_update
416: (p_approval_comp_id
417: IN hxc_approval_comps.approval_comp_id%TYPE
418: ,p_approval_style_id
419: IN hxc_approval_comps.approval_style_id%TYPE
420: ,p_time_recipient_id
421: IN hxc_approval_comps.time_recipient_id%TYPE
422: ,p_start_date
423: IN hxc_approval_comps.start_date%TYPE
417: IN hxc_approval_comps.approval_comp_id%TYPE
418: ,p_approval_style_id
419: IN hxc_approval_comps.approval_style_id%TYPE
420: ,p_time_recipient_id
421: IN hxc_approval_comps.time_recipient_id%TYPE
422: ,p_start_date
423: IN hxc_approval_comps.start_date%TYPE
424: ,p_end_date
425: IN hxc_approval_comps.end_date%TYPE
419: IN hxc_approval_comps.approval_style_id%TYPE
420: ,p_time_recipient_id
421: IN hxc_approval_comps.time_recipient_id%TYPE
422: ,p_start_date
423: IN hxc_approval_comps.start_date%TYPE
424: ,p_end_date
425: IN hxc_approval_comps.end_date%TYPE
426: );
427: --
421: IN hxc_approval_comps.time_recipient_id%TYPE
422: ,p_start_date
423: IN hxc_approval_comps.start_date%TYPE
424: ,p_end_date
425: IN hxc_approval_comps.end_date%TYPE
426: );
427: --
428: -- ----------------------------------------------------------------------------
429: -- |-< chk_overlapping_dates_update >-----------------------------------------|
464: -- ----------------------------------------------------------------------------
465: --
466: PROCEDURE chk_overlapping_dates_update
467: (p_approval_comp_id
468: IN hxc_approval_comps.approval_comp_id%TYPE
469: ,p_approval_style_id
470: IN hxc_approval_comps.approval_style_id%TYPE
471: ,p_time_recipient_id
472: IN hxc_approval_comps.time_recipient_id%TYPE
466: PROCEDURE chk_overlapping_dates_update
467: (p_approval_comp_id
468: IN hxc_approval_comps.approval_comp_id%TYPE
469: ,p_approval_style_id
470: IN hxc_approval_comps.approval_style_id%TYPE
471: ,p_time_recipient_id
472: IN hxc_approval_comps.time_recipient_id%TYPE
473: ,p_start_date
474: IN hxc_approval_comps.start_date%TYPE
468: IN hxc_approval_comps.approval_comp_id%TYPE
469: ,p_approval_style_id
470: IN hxc_approval_comps.approval_style_id%TYPE
471: ,p_time_recipient_id
472: IN hxc_approval_comps.time_recipient_id%TYPE
473: ,p_start_date
474: IN hxc_approval_comps.start_date%TYPE
475: ,p_end_date
476: IN hxc_approval_comps.end_date%TYPE
470: IN hxc_approval_comps.approval_style_id%TYPE
471: ,p_time_recipient_id
472: IN hxc_approval_comps.time_recipient_id%TYPE
473: ,p_start_date
474: IN hxc_approval_comps.start_date%TYPE
475: ,p_end_date
476: IN hxc_approval_comps.end_date%TYPE
477: ,p_clashing_id
478: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
472: IN hxc_approval_comps.time_recipient_id%TYPE
473: ,p_start_date
474: IN hxc_approval_comps.start_date%TYPE
475: ,p_end_date
476: IN hxc_approval_comps.end_date%TYPE
477: ,p_clashing_id
478: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
479: ,p_clashing_ovn
480: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
474: IN hxc_approval_comps.start_date%TYPE
475: ,p_end_date
476: IN hxc_approval_comps.end_date%TYPE
477: ,p_clashing_id
478: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
479: ,p_clashing_ovn
480: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
481: ,p_clashing_start_date
482: OUT NOCOPY hxc_approval_comps.start_date%TYPE
476: IN hxc_approval_comps.end_date%TYPE
477: ,p_clashing_id
478: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
479: ,p_clashing_ovn
480: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
481: ,p_clashing_start_date
482: OUT NOCOPY hxc_approval_comps.start_date%TYPE
483: ,p_clashing_end_date
484: OUT NOCOPY hxc_approval_comps.end_date%TYPE
478: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
479: ,p_clashing_ovn
480: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
481: ,p_clashing_start_date
482: OUT NOCOPY hxc_approval_comps.start_date%TYPE
483: ,p_clashing_end_date
484: OUT NOCOPY hxc_approval_comps.end_date%TYPE
485: );
486: --
480: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
481: ,p_clashing_start_date
482: OUT NOCOPY hxc_approval_comps.start_date%TYPE
483: ,p_clashing_end_date
484: OUT NOCOPY hxc_approval_comps.end_date%TYPE
485: );
486: --
487: -- ----------------------------------------------------------------------------
488: -- |-< chk_master_detail_rel >-----------------------------------------|
517: -- ----------------------------------------------------------------------------
518: --
519: PROCEDURE chk_master_detail_rel
520: (
521: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
522: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
523: );
524: --
525: -- ----------------------------------------------------------------------------
518: --
519: PROCEDURE chk_master_detail_rel
520: (
521: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
522: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
523: );
524: --
525: -- ----------------------------------------------------------------------------
526: -- |-< chk_parent_fields >-----------------------------------------|
555: -- ----------------------------------------------------------------------------
556: --
557: PROCEDURE chk_parent_fields
558: (
559: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
560: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE);
561:
562:
563: --
556: --
557: PROCEDURE chk_parent_fields
558: (
559: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
560: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE);
561:
562:
563: --
564: -- ----------------------------------------------------------------------------
597: -- {End Of Comments}
598: -- ----------------------------------------------------------------------------
599: --
600: PROCEDURE chk_tim_cat
601: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
602: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
603: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE );
604:
605:
598: -- ----------------------------------------------------------------------------
599: --
600: PROCEDURE chk_tim_cat
601: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
602: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
603: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE );
604:
605:
606: -- ----------------------------------------------------------------------------
599: --
600: PROCEDURE chk_tim_cat
601: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
602: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
603: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE );
604:
605:
606: -- ----------------------------------------------------------------------------
607: -- |-< chk_def_ela_rec_exists >-----------------------------------------|
637: -- ----------------------------------------------------------------------------
638: --
639: PROCEDURE chk_def_ela_rec_exists
640: (
641: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
642: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
643: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
644: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE );
645:
638: --
639: PROCEDURE chk_def_ela_rec_exists
640: (
641: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
642: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
643: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
644: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE );
645:
646: --
639: PROCEDURE chk_def_ela_rec_exists
640: (
641: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
642: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
643: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
644: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE );
645:
646: --
647: -- ----------------------------------------------------------------------------
640: (
641: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
642: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
643: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
644: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE );
645:
646: --
647: -- ----------------------------------------------------------------------------
648: -- |-< chk_tim_rcp >-----------------------------------------|
680: -- {End Of Comments}
681: -- ----------------------------------------------------------------------------
682: --
683: PROCEDURE chk_tim_rcp
684: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
685: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
686: ,p_time_recipient_id IN hxc_approval_comps.time_recipient_id%TYPE );
687:
688: --
681: -- ----------------------------------------------------------------------------
682: --
683: PROCEDURE chk_tim_rcp
684: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
685: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
686: ,p_time_recipient_id IN hxc_approval_comps.time_recipient_id%TYPE );
687:
688: --
689: -- ----------------------------------------------------------------------------
682: --
683: PROCEDURE chk_tim_rcp
684: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
685: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
686: ,p_time_recipient_id IN hxc_approval_comps.time_recipient_id%TYPE );
687:
688: --
689: -- ----------------------------------------------------------------------------
690: -- |-< chk_tim_cat_dup >-----------------------------------------|
726: -- ----------------------------------------------------------------------------
727: --
728: PROCEDURE chk_tim_cat_dup
729: (
730: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
731: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
732: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
727: --
728: PROCEDURE chk_tim_cat_dup
729: (
730: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
731: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
732: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
728: PROCEDURE chk_tim_cat_dup
729: (
730: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
731: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
732: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
736: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
729: (
730: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
731: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
732: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
736: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
737: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
730: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
731: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
732: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
736: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
737: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
738: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE);
731: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
732: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
736: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
737: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
738: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE);
739:
732: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
736: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
737: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
738: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE);
739:
740: --
733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
736: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
737: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
738: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE);
739:
740: --
741: --
734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
736: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
737: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
738: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE);
739:
740: --
741: --
742: -- ----------------------------------------------------------------------------
775: -- ----------------------------------------------------------------------------
776: --
777: PROCEDURE chk_app_mech_for_child
778: (
779: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
780: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
781: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
782: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
783: );
776: --
777: PROCEDURE chk_app_mech_for_child
778: (
779: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
780: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
781: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
782: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
783: );
784:
777: PROCEDURE chk_app_mech_for_child
778: (
779: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
780: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
781: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
782: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
783: );
784:
785: --
778: (
779: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
780: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
781: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
782: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
783: );
784:
785: --
786: -- ----------------------------------------------------------------------------
815: --
816:
817: Procedure chk_allowable_extensions
818: (
819: p_run_recipient_extensions in hxc_approval_comps.run_recipient_extensions%type
820: ,p_approval_style_id in hxc_approval_comps.approval_style_id%type
821: );
822:
823: --
816:
817: Procedure chk_allowable_extensions
818: (
819: p_run_recipient_extensions in hxc_approval_comps.run_recipient_extensions%type
820: ,p_approval_style_id in hxc_approval_comps.approval_style_id%type
821: );
822:
823: --
824: -- ----------------------------------------------------------------------------