APPS.HXC_HAC_BUS dependencies on HXC_APPROVAL_COMPS

Line 180: IN hxc_approval_comps.approval_comp_id%TYPE

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

Line 182: IN hxc_approval_comps.start_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: --

Line 184: IN hxc_approval_comps.end_date%TYPE

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 >---------------------------------------------|

Line 223: IN hxc_approval_comps.approval_style_id%TYPE

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

Line 225: IN hxc_approval_comps.time_recipient_id%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

Line 227: IN hxc_approval_comps.start_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: --

Line 229: IN hxc_approval_comps.end_date%TYPE

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 >---------------------------------------------|

Line 269: IN hxc_approval_comps.approval_comp_id%TYPE

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

Line 271: IN hxc_approval_comps.approval_style_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

Line 273: IN hxc_approval_comps.time_recipient_id%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

Line 275: IN hxc_approval_comps.start_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:

Line 277: IN hxc_approval_comps.end_date%TYPE

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: -- ----------------------------------------------------------------------------

Line 316: IN hxc_approval_comps.approval_style_id%TYPE

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

Line 318: IN hxc_approval_comps.time_recipient_id%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

Line 320: IN hxc_approval_comps.start_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: --

Line 322: IN hxc_approval_comps.end_date%TYPE

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 >-----------------------------------------|

Line 364: IN hxc_approval_comps.approval_style_id%TYPE

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

Line 366: IN hxc_approval_comps.time_recipient_id%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

Line 368: IN hxc_approval_comps.start_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

Line 370: IN hxc_approval_comps.end_date%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

Line 372: OUT NOCOPY hxc_approval_comps.approval_style_id%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

Line 374: OUT NOCOPY hxc_approval_comps.object_version_number%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

Line 376: OUT NOCOPY hxc_approval_comps.start_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: --

Line 378: OUT NOCOPY hxc_approval_comps.end_date%TYPE

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 >-----------------------------------------|

Line 417: IN hxc_approval_comps.approval_comp_id%TYPE

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

Line 419: IN hxc_approval_comps.approval_style_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

Line 421: IN hxc_approval_comps.time_recipient_id%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

Line 423: IN hxc_approval_comps.start_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: --

Line 425: IN hxc_approval_comps.end_date%TYPE

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 >-----------------------------------------|

Line 468: IN hxc_approval_comps.approval_comp_id%TYPE

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

Line 470: IN hxc_approval_comps.approval_style_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

Line 472: IN hxc_approval_comps.time_recipient_id%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

Line 474: IN hxc_approval_comps.start_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

Line 476: IN hxc_approval_comps.end_date%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

Line 478: OUT NOCOPY hxc_approval_comps.approval_style_id%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

Line 480: OUT NOCOPY hxc_approval_comps.object_version_number%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

Line 482: OUT NOCOPY hxc_approval_comps.start_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: --

Line 484: OUT NOCOPY hxc_approval_comps.end_date%TYPE

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 >-----------------------------------------|

Line 521: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 522: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

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 >-----------------------------------------|

Line 559: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

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: --

Line 560: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE);

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: -- ----------------------------------------------------------------------------

Line 601: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

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:

Line 602: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

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: -- ----------------------------------------------------------------------------

Line 603: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE );

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 >-----------------------------------------|

Line 641: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE

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:

Line 642: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE

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: --

Line 643: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 644: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE );

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 >-----------------------------------------|

Line 684: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

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: --

Line 685: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

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: -- ----------------------------------------------------------------------------

Line 686: ,p_time_recipient_id IN hxc_approval_comps.time_recipient_id%TYPE );

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 >-----------------------------------------|

Line 730: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE

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

Line 731: ,p_time_category_id IN hxc_approval_comps.time_category_id%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

Line 732: ,p_approval_order IN hxc_approval_comps.approval_order%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

Line 733: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_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

Line 734: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%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);

Line 735: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%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:

Line 736: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_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:
740: --

Line 737: ,p_wf_name IN hxc_approval_comps.wf_name%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: --
741: --

Line 738: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%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: --
742: -- ----------------------------------------------------------------------------

Line 779: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE

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: );

Line 780: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE

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:

Line 781: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

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: --

Line 782: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

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: -- ----------------------------------------------------------------------------

Line 819: p_run_recipient_extensions in hxc_approval_comps.run_recipient_extensions%type

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: --

Line 820: ,p_approval_style_id in hxc_approval_comps.approval_style_id%type

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: -- ----------------------------------------------------------------------------