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.HXC_NOTIFICATION_HELPER dependencies on HXC_APP_COMP_NOTIFICATIONS

Line 49: hxc_app_comp_notifications hacn,

45:
46: CURSOR csr_timeout_notifs
47: IS select count(1) FROM hxc_approval_styles has,
48: hxc_approval_comps hac,
49: hxc_app_comp_notifications hacn,
50: hxc_app_comp_notif_usages hacnu
51: WHERE has.approval_style_id = p_approval_style_id
52: AND has.approval_style_id = hac.approval_style_id
53: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 57: hxc_app_comp_notifications_api.

53: AND hac.approval_comp_id = hacnu.approval_comp_id
54: AND hac.object_version_number = hacnu.approval_comp_ovn
55: AND hacnu.comp_notification_id = hacn.comp_notification_id
56: AND hacn.notification_action_code =
57: hxc_app_comp_notifications_api.
58: c_action_request_appr_resend
59: AND hacnu.enabled_flag = 'Y';
60: BEGIN
61: OPEN csr_timeout_notifs;

Line 82: l_retries hxc_app_comp_notifications.notification_number_retries%TYPE;

78:
79: FUNCTION number_timeout_retries_any (p_approval_style_id IN NUMBER)
80: RETURN NUMBER
81: IS
82: l_retries hxc_app_comp_notifications.notification_number_retries%TYPE;
83:
84: CURSOR csr_timeout_retries
85: IS
86: SELECT notification_number_retries

Line 89: hxc_app_comp_notifications hacn,

85: IS
86: SELECT notification_number_retries
87: FROM hxc_approval_styles has,
88: hxc_approval_comps hac,
89: hxc_app_comp_notifications hacn,
90: hxc_app_comp_notif_usages hacnu
91: WHERE has.approval_style_id = p_approval_style_id
92: AND has.approval_style_id = hac.approval_style_id
93: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 98: hxc_app_comp_notifications_api.c_action_request_appr_resend

94: AND hac.object_version_number = hacnu.approval_comp_ovn
95: AND hacnu.comp_notification_id = hacn.comp_notification_id
96: AND hacnu.comp_notification_ovn = hacn.object_version_number
97: AND hacn.notification_action_code =
98: hxc_app_comp_notifications_api.c_action_request_appr_resend
99: AND hacnu.enabled_flag = 'Y';
100: BEGIN
101: OPEN csr_timeout_retries;
102: FETCH csr_timeout_retries INTO l_retries;

Line 115: l_appr_timeout_value hxc_app_comp_notifications.notification_timeout_value%TYPE;

111:
112: FUNCTION approver_timeout_value (p_approval_style_id IN NUMBER)
113: RETURN NUMBER
114: IS
115: l_appr_timeout_value hxc_app_comp_notifications.notification_timeout_value%TYPE;
116:
117: CURSOR csr_timeout_value
118: IS
119: SELECT notification_timeout_value

Line 122: hxc_app_comp_notifications hacn,

118: IS
119: SELECT notification_timeout_value
120: FROM hxc_approval_styles has,
121: hxc_approval_comps hac,
122: hxc_app_comp_notifications hacn,
123: hxc_app_comp_notif_usages hacnu
124: WHERE has.approval_style_id = p_approval_style_id
125: AND has.approval_style_id = hac.approval_style_id
126: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 149: l_preparer_timeout_value hxc_app_comp_notifications.notification_timeout_value%TYPE;

145:
146: FUNCTION preparer_timeout_value (p_approval_style_id IN NUMBER)
147: RETURN NUMBER
148: IS
149: l_preparer_timeout_value hxc_app_comp_notifications.notification_timeout_value%TYPE;
150:
151: CURSOR csr_timeout_value
152: IS
153: SELECT hacn.notification_timeout_value

Line 156: hxc_app_comp_notifications hacn,

152: IS
153: SELECT hacn.notification_timeout_value
154: FROM hxc_approval_styles has,
155: hxc_approval_comps hac,
156: hxc_app_comp_notifications hacn,
157: hxc_app_comp_notif_usages hacnu
158: WHERE has.approval_style_id = p_approval_style_id
159: AND has.approval_style_id = hac.approval_style_id
160: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 183: l_admin_timeout_value hxc_app_comp_notifications.notification_timeout_value%TYPE;

179:
180: FUNCTION admin_timeout_value (p_approval_style_id IN NUMBER)
181: RETURN NUMBER
182: IS
183: l_admin_timeout_value hxc_app_comp_notifications.notification_timeout_value%TYPE;
184:
185: CURSOR csr_timeout_value
186: IS
187: SELECT hacn.notification_timeout_value

Line 190: hxc_app_comp_notifications hacn,

186: IS
187: SELECT hacn.notification_timeout_value
188: FROM hxc_approval_styles has,
189: hxc_approval_comps hac,
190: hxc_app_comp_notifications hacn,
191: hxc_app_comp_notif_usages hacnu
192: WHERE has.approval_style_id = p_approval_style_id
193: AND has.approval_style_id = hac.approval_style_id
194: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 224: hxc_app_comp_notifications hacn,

220: IS
221: SELECT COUNT (1)
222: FROM hxc_approval_styles has,
223: hxc_approval_comps hac,
224: hxc_app_comp_notifications hacn,
225: hxc_app_comp_notif_usages hacnu
226: WHERE has.approval_style_id = p_approval_style_id
227: AND has.approval_style_id = hac.approval_style_id
228: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 265: hxc_app_comp_notifications hacn,

261: IS
262: SELECT COUNT (1)
263: FROM hxc_approval_styles has,
264: hxc_approval_comps hac,
265: hxc_app_comp_notifications hacn,
266: hxc_app_comp_notif_usages hacnu
267: WHERE has.approval_style_id = p_approval_style_id
268: AND has.approval_style_id = hac.approval_style_id
269: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 308: hxc_app_comp_notifications hacn,

304: IS
305: SELECT COUNT (1)
306: FROM hxc_approval_styles has,
307: hxc_approval_comps hac,
308: hxc_app_comp_notifications hacn,
309: hxc_app_comp_notif_usages hacnu
310: WHERE has.approval_style_id = p_approval_style_id
311: AND has.approval_style_id = hac.approval_style_id
312: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 351: hxc_app_comp_notifications hacn,

347: IS
348: SELECT COUNT (1)
349: FROM hxc_approval_styles has,
350: hxc_approval_comps hac,
351: hxc_app_comp_notifications hacn,
352: hxc_app_comp_notif_usages hacnu
353: WHERE has.approval_style_id = p_approval_style_id
354: AND has.approval_style_id = hac.approval_style_id
355: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 394: hxc_app_comp_notifications hacn,

390: IS
391: SELECT COUNT (1)
392: FROM hxc_approval_styles has,
393: hxc_approval_comps hac,
394: hxc_app_comp_notifications hacn,
395: hxc_app_comp_notif_usages hacnu
396: WHERE has.approval_style_id = p_approval_style_id
397: AND has.approval_style_id = hac.approval_style_id
398: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 436: hxc_app_comp_notifications hacn,

432: IS
433: SELECT COUNT (1)
434: FROM hxc_approval_styles has,
435: hxc_approval_comps hac,
436: hxc_app_comp_notifications hacn,
437: hxc_app_comp_notif_usages hacnu
438: WHERE has.approval_style_id = p_approval_style_id
439: AND has.approval_style_id = hac.approval_style_id
440: AND hac.approval_comp_id = hacnu.approval_comp_id

Line 482: l_comp_notification_id hxc_app_comp_notifications_api.id_type;

478: ,p_notify_preparer_approved in varchar2
479: ,p_notify_preparer_rejected in varchar2
480: ,p_notify_preparer_transfer in varchar2
481: ) is
482: l_comp_notification_id hxc_app_comp_notifications_api.id_type;
483: l_object_version_number hxc_app_comp_notifications_api.ovn_type;
484: begin
485:
486:

Line 483: l_object_version_number hxc_app_comp_notifications_api.ovn_type;

479: ,p_notify_preparer_rejected in varchar2
480: ,p_notify_preparer_transfer in varchar2
481: ) is
482: l_comp_notification_id hxc_app_comp_notifications_api.id_type;
483: l_object_version_number hxc_app_comp_notifications_api.ovn_type;
484: begin
485:
486:
487:

Line 490: hxc_app_comp_notifications_api.create_app_comp_notification

486:
487:
488: If p_timeouts_enabled ='Y'
489: then
490: hxc_app_comp_notifications_api.create_app_comp_notification
491: (
492: p_notification_number_retries => p_number_retries
493: ,p_notification_timeout_value => p_approver_timeout
494: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 503: hxc_app_comp_notifications_api.create_app_comp_notification

499: ,p_comp_notification_id => l_comp_notification_id
500: ,p_object_version_number => l_object_version_number
501: );
502:
503: hxc_app_comp_notifications_api.create_app_comp_notification
504: (
505: p_notification_number_retries => p_number_retries
506: ,p_notification_timeout_value => p_preparer_timeout
507: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 517: hxc_app_comp_notifications_api.create_app_comp_notification

513: ,p_object_version_number => l_object_version_number
514: ) ;
515:
516:
517: hxc_app_comp_notifications_api.create_app_comp_notification
518: (
519: p_notification_number_retries => p_number_retries
520: ,p_notification_timeout_value => p_admin_timeout
521: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 534: hxc_app_comp_notifications_api.create_app_comp_notification

530: end if;
531:
532: If p_notify_supervisor = 'Y'
533: then
534: hxc_app_comp_notifications_api.create_app_comp_notification
535: (
536: p_notification_number_retries => 0
537: ,p_notification_timeout_value => 0
538: ,p_notification_action_code => 'REQUEST-APPROVAL'

Line 550: hxc_app_comp_notifications_api.create_app_comp_notification

546: end if;
547:
548: If p_notify_worker_on_submit = 'Y'
549: then
550: hxc_app_comp_notifications_api.create_app_comp_notification
551: (
552: p_notification_number_retries => 0
553: ,p_notification_timeout_value => 0
554: ,p_notification_action_code => 'SUBMISSION'

Line 566: hxc_app_comp_notifications_api.create_app_comp_notification

562: end if;
563:
564: If p_notify_worker_on_aa = 'Y'
565: then
566: hxc_app_comp_notifications_api.create_app_comp_notification
567: (
568: p_notification_number_retries => 0
569: ,p_notification_timeout_value => 0
570: ,p_notification_action_code => 'AUTO-APPROVE'

Line 582: hxc_app_comp_notifications_api.create_app_comp_notification

578: end if;
579:
580: If p_notify_preparer_approved = 'Y'
581: then
582: hxc_app_comp_notifications_api.create_app_comp_notification
583: (
584: p_notification_number_retries => 0
585: ,p_notification_timeout_value => 0
586: ,p_notification_action_code => 'APPROVED'

Line 598: hxc_app_comp_notifications_api.create_app_comp_notification

594: end if;
595:
596: If p_notify_preparer_rejected = 'Y'
597: then
598: hxc_app_comp_notifications_api.create_app_comp_notification
599: (
600: p_notification_number_retries => 0
601: ,p_notification_timeout_value => 0
602: ,p_notification_action_code => 'REJECTED'

Line 614: hxc_app_comp_notifications_api.create_app_comp_notification

610: end if;
611:
612: If p_notify_preparer_transfer = 'Y' then
613:
614: hxc_app_comp_notifications_api.create_app_comp_notification
615: (
616: p_notification_number_retries => 0
617: ,p_notification_timeout_value => 0
618: ,p_notification_action_code => 'TRANSFER'

Line 652: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%type;

648: ,p_notify_preparer_approved in varchar2
649: ,p_notify_preparer_rejected in varchar2
650: ,p_notify_preparer_transfer in varchar2
651: ) is
652: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%type;
653: l_object_version_number hxc_app_comp_notifications.object_version_number%type;
654: l_comp_notification_id_table hxc_app_comp_notifications_api.id_type;
655: l_object_version_number_table hxc_app_comp_notifications_api.ovn_type;
656: l_count number(9) :=0;

Line 653: l_object_version_number hxc_app_comp_notifications.object_version_number%type;

649: ,p_notify_preparer_rejected in varchar2
650: ,p_notify_preparer_transfer in varchar2
651: ) is
652: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%type;
653: l_object_version_number hxc_app_comp_notifications.object_version_number%type;
654: l_comp_notification_id_table hxc_app_comp_notifications_api.id_type;
655: l_object_version_number_table hxc_app_comp_notifications_api.ovn_type;
656: l_count number(9) :=0;
657: l_comp_notif_id_exist hxc_app_comp_notifications.comp_notification_id%type;

Line 654: l_comp_notification_id_table hxc_app_comp_notifications_api.id_type;

650: ,p_notify_preparer_transfer in varchar2
651: ) is
652: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%type;
653: l_object_version_number hxc_app_comp_notifications.object_version_number%type;
654: l_comp_notification_id_table hxc_app_comp_notifications_api.id_type;
655: l_object_version_number_table hxc_app_comp_notifications_api.ovn_type;
656: l_count number(9) :=0;
657: l_comp_notif_id_exist hxc_app_comp_notifications.comp_notification_id%type;
658: l_ovn_exist hxc_app_comp_notifications.object_version_number%type;

Line 655: l_object_version_number_table hxc_app_comp_notifications_api.ovn_type;

651: ) is
652: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%type;
653: l_object_version_number hxc_app_comp_notifications.object_version_number%type;
654: l_comp_notification_id_table hxc_app_comp_notifications_api.id_type;
655: l_object_version_number_table hxc_app_comp_notifications_api.ovn_type;
656: l_count number(9) :=0;
657: l_comp_notif_id_exist hxc_app_comp_notifications.comp_notification_id%type;
658: l_ovn_exist hxc_app_comp_notifications.object_version_number%type;
659: l_approval_comp_id hxc_approval_comps.approval_comp_id%type;

Line 657: l_comp_notif_id_exist hxc_app_comp_notifications.comp_notification_id%type;

653: l_object_version_number hxc_app_comp_notifications.object_version_number%type;
654: l_comp_notification_id_table hxc_app_comp_notifications_api.id_type;
655: l_object_version_number_table hxc_app_comp_notifications_api.ovn_type;
656: l_count number(9) :=0;
657: l_comp_notif_id_exist hxc_app_comp_notifications.comp_notification_id%type;
658: l_ovn_exist hxc_app_comp_notifications.object_version_number%type;
659: l_approval_comp_id hxc_approval_comps.approval_comp_id%type;
660: l_approval_comp_ovn hxc_approval_comps.object_version_number%type;
661: l_old_notif_rec hxc_notification_helper.g_rec_notif;

Line 658: l_ovn_exist hxc_app_comp_notifications.object_version_number%type;

654: l_comp_notification_id_table hxc_app_comp_notifications_api.id_type;
655: l_object_version_number_table hxc_app_comp_notifications_api.ovn_type;
656: l_count number(9) :=0;
657: l_comp_notif_id_exist hxc_app_comp_notifications.comp_notification_id%type;
658: l_ovn_exist hxc_app_comp_notifications.object_version_number%type;
659: l_approval_comp_id hxc_approval_comps.approval_comp_id%type;
660: l_approval_comp_ovn hxc_approval_comps.object_version_number%type;
661: l_old_notif_rec hxc_notification_helper.g_rec_notif;
662: l_comp_notification_ovn number(9);

Line 698: hxc_app_comp_notifications hacn,

694: select hacn.comp_notification_id,hacn.object_version_number
695: from
696: hxc_approval_styles has,
697: hxc_approval_comps hac,
698: hxc_app_comp_notifications hacn,
699: hxc_app_comp_notif_usages hacnu
700: where
701: has.approval_style_id = p_approval_style_id and
702: has.approval_style_id = hac.approval_style_id and

Line 719: from hxc_app_comp_notifications hacn where

715:
716: cursor csr_notif_already_exists
717: (p_notification_number_retries in number, p_notification_timeout_value in number, p_notification_recipient_code in varchar2) is
718: select hacn.comp_notification_id, hacn.object_version_number
719: from hxc_app_comp_notifications hacn where
720: notification_number_retries=p_notification_number_retries and
721: notification_timeout_value=p_notification_timeout_value and
722: notification_action_code='REQUEST-APPROVAL-RESEND' and
723: notification_recipient_code=p_notification_recipient_code and

Line 725: from hxc_app_comp_notifications

721: notification_timeout_value=p_notification_timeout_value and
722: notification_action_code='REQUEST-APPROVAL-RESEND' and
723: notification_recipient_code=p_notification_recipient_code and
724: object_version_number=(select max(object_version_number)
725: from hxc_app_comp_notifications
726: where comp_notification_id=hacn.comp_notification_id);
727:
728: --
729: -- Cursor to check if the notification record being updated is being used by other

Line 743: hxc_app_comp_notifications hacn,

739: ,p_object_version_number in number)
740: is
741: select count(1) from
742: hxc_approval_comps hac,
743: hxc_app_comp_notifications hacn,
744: hxc_app_comp_notif_usages hacnu
745: where
746: hac.approval_comp_id not in (select hac.approval_comp_id
747: from hxc_approval_comps hac

Line 775: hxc_app_comp_notifications hacn

771: hacnu.comp_notification_id,hacnu.comp_notification_ovn from
772: hxc_app_comp_notif_usages hacnu,
773: hxc_approval_styles has,
774: hxc_approval_comps hac,
775: hxc_app_comp_notifications hacn
776: where
777: has.approval_style_id=p_approval_style_id and
778: has.approval_style_id=hac.approval_style_id and
779: hac.approval_comp_id=hacnu.approval_comp_id and

Line 794: hxc_app_comp_notifications_api.disable_timeout_notifications

790:
791:
792: if p_timeouts_enabled ='N' and l_old_notif_rec.timeouts_enabled='Y'
793: then
794: hxc_app_comp_notifications_api.disable_timeout_notifications
795: (
796: p_approval_style_name => p_approval_style_name
797: ) ;
798:

Line 817: hxc_app_comp_notifications_api.create_app_comp_notification

813: comp_notification_ovn=l_comp_notification_ovn;
814: end loop;
815: close csr_del_disabled_usages;
816:
817: hxc_app_comp_notifications_api.create_app_comp_notification
818: (
819: p_notification_number_retries => p_number_retries
820: ,p_notification_timeout_value => p_approver_timeout
821: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 829: hxc_app_comp_notifications_api.create_app_comp_notification

825: ,p_approval_component_id => null
826: ,p_comp_notification_id => l_comp_notification_id_table
827: ,p_object_version_number => l_object_version_number_table
828: );
829: hxc_app_comp_notifications_api.create_app_comp_notification
830: (
831: p_notification_number_retries => p_number_retries
832: ,p_notification_timeout_value => p_preparer_timeout
833: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 843: hxc_app_comp_notifications_api.create_app_comp_notification

839: ,p_object_version_number => l_object_version_number_table
840: ) ;
841:
842:
843: hxc_app_comp_notifications_api.create_app_comp_notification
844: (
845: p_notification_number_retries => p_number_retries
846: ,p_notification_timeout_value => p_admin_timeout
847: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 899: hxc_app_comp_notifications_api.update_app_comp_notification

895:
896: else
897: if(l_count=0) --- enters if not used
898: then
899: hxc_app_comp_notifications_api.update_app_comp_notification
900: (
901: p_comp_notification_id => l_comp_notification_id
902: ,p_object_version_number => l_object_version_number
903: ,p_notification_number_retries => p_number_retries

Line 908: hxc_app_comp_notifications_api.create_app_comp_notification

904: ,p_notification_timeout_value => p_approver_timeout
905: );
906:
907: else
908: hxc_app_comp_notifications_api.create_app_comp_notification
909: (
910: p_notification_number_retries => p_number_retries
911: ,p_notification_timeout_value => p_approver_timeout
912: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 976: hxc_app_comp_notifications_api.update_app_comp_notification

972: if(l_count=0) --- enters if not used
973: then
974:
975:
976: hxc_app_comp_notifications_api.update_app_comp_notification
977: (
978: p_comp_notification_id => l_comp_notification_id
979: ,p_object_version_number => l_object_version_number
980: ,p_notification_number_retries => p_number_retries

Line 987: hxc_app_comp_notifications_api.create_app_comp_notification

983:
984:
985: else
986:
987: hxc_app_comp_notifications_api.create_app_comp_notification
988: (
989: p_notification_number_retries => p_number_retries
990: ,p_notification_timeout_value => p_preparer_timeout
991: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 1055: hxc_app_comp_notifications_api.update_app_comp_notification

1051: if(l_count=0) --- enters if not used
1052: then
1053:
1054:
1055: hxc_app_comp_notifications_api.update_app_comp_notification
1056: (
1057: p_comp_notification_id => l_comp_notification_id
1058: ,p_object_version_number => l_object_version_number
1059: ,p_notification_number_retries => p_number_retries

Line 1066: hxc_app_comp_notifications_api.create_app_comp_notification

1062:
1063:
1064: else
1065:
1066: hxc_app_comp_notifications_api.create_app_comp_notification
1067: (
1068: p_notification_number_retries => p_number_retries
1069: ,p_notification_timeout_value => p_admin_timeout
1070: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 1136: hxc_app_comp_notifications_api.update_app_comp_notification

1132: if(l_count=0) --- enters if not used
1133: then
1134:
1135:
1136: hxc_app_comp_notifications_api.update_app_comp_notification
1137: (
1138: p_comp_notification_id => l_comp_notification_id
1139: ,p_object_version_number => l_object_version_number
1140: ,p_notification_timeout_value => p_approver_timeout

Line 1146: hxc_app_comp_notifications_api.create_app_comp_notification

1142:
1143:
1144: else
1145:
1146: hxc_app_comp_notifications_api.create_app_comp_notification
1147: (
1148: p_notification_number_retries => p_number_retries
1149: ,p_notification_timeout_value => p_approver_timeout
1150: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 1216: hxc_app_comp_notifications_api.update_app_comp_notification

1212: if(l_count=0) --- enters if not used
1213: then
1214:
1215:
1216: hxc_app_comp_notifications_api.update_app_comp_notification
1217: (
1218: p_comp_notification_id => l_comp_notification_id
1219: ,p_object_version_number => l_object_version_number
1220: ,p_notification_timeout_value => p_preparer_timeout

Line 1226: hxc_app_comp_notifications_api.create_app_comp_notification

1222:
1223:
1224: else
1225:
1226: hxc_app_comp_notifications_api.create_app_comp_notification
1227: (
1228: p_notification_number_retries => p_number_retries
1229: ,p_notification_timeout_value => p_preparer_timeout
1230: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 1296: hxc_app_comp_notifications_api.update_app_comp_notification

1292: if(l_count=0) --- enters if not used
1293: then
1294:
1295:
1296: hxc_app_comp_notifications_api.update_app_comp_notification
1297: (
1298: p_comp_notification_id => l_comp_notification_id
1299: ,p_object_version_number => l_object_version_number
1300: ,p_notification_timeout_value => p_admin_timeout

Line 1306: hxc_app_comp_notifications_api.create_app_comp_notification

1302:
1303:
1304: else
1305:
1306: hxc_app_comp_notifications_api.create_app_comp_notification
1307: (
1308: p_notification_number_retries => p_number_retries
1309: ,p_notification_timeout_value => p_admin_timeout
1310: ,p_notification_action_code => 'REQUEST-APPROVAL-RESEND'

Line 1344: hxc_app_comp_notifications_api.create_app_comp_notification

1340:
1341: If (p_notify_supervisor = 'Y' and l_old_notif_rec.notify_supervisor = 'N')
1342: then
1343:
1344: hxc_app_comp_notifications_api.create_app_comp_notification
1345: (
1346: p_notification_number_retries => 0
1347: ,p_notification_timeout_value => 0
1348: ,p_notification_action_code => 'REQUEST-APPROVAL'

Line 1377: hxc_app_comp_notifications_api.create_app_comp_notification

1373:
1374: -- Checking SUBMISSION/WORKER notification
1375: If (p_notify_worker_on_submit = 'Y' and l_old_notif_rec.notify_worker_on_submit = 'N')
1376: then
1377: hxc_app_comp_notifications_api.create_app_comp_notification
1378: (
1379: p_notification_number_retries => 0
1380: ,p_notification_timeout_value => 0
1381: ,p_notification_action_code => 'SUBMISSION'

Line 1406: hxc_app_comp_notifications_api.create_app_comp_notification

1402:
1403: -- Checking AUTO-APPROVE/WORKER notification
1404: If (p_notify_worker_on_aa = 'Y' and l_old_notif_rec.notify_worker_on_aa = 'N')
1405: then
1406: hxc_app_comp_notifications_api.create_app_comp_notification
1407: (
1408: p_notification_number_retries => 0
1409: ,p_notification_timeout_value => 0
1410: ,p_notification_action_code => 'AUTO-APPROVE'

Line 1437: hxc_app_comp_notifications_api.create_app_comp_notification

1433:
1434: -- Checking APPROVED/PREPARER notification
1435: If (p_notify_preparer_approved = 'Y' and l_old_notif_rec.notify_preparer_approved = 'N')
1436: then
1437: hxc_app_comp_notifications_api.create_app_comp_notification
1438: (
1439: p_notification_number_retries => 0
1440: ,p_notification_timeout_value => 0
1441: ,p_notification_action_code => 'APPROVED'

Line 1468: hxc_app_comp_notifications_api.create_app_comp_notification

1464:
1465: -- Checking REJECTED/PREPARER notification
1466: If (p_notify_preparer_rejected = 'Y' and l_old_notif_rec.notify_preparer_rejected = 'N')
1467: then
1468: hxc_app_comp_notifications_api.create_app_comp_notification
1469: (
1470: p_notification_number_retries => 0
1471: ,p_notification_timeout_value => 0
1472: ,p_notification_action_code => 'REJECTED'

Line 1498: hxc_app_comp_notifications_api.create_app_comp_notification

1494:
1495: -- Checking TRANSFER/PREPARER notification
1496: If (p_notify_preparer_transfer = 'Y' and l_old_notif_rec.notify_preparer_transfer = 'N')
1497: then
1498: hxc_app_comp_notifications_api.create_app_comp_notification
1499: (
1500: p_notification_number_retries => 0
1501: ,p_notification_timeout_value => 0
1502: ,p_notification_action_code => 'TRANSFER'

Line 1548: hxc_app_comp_notifications hacn,

1544: select distinct hacn.comp_notification_id,hacn.object_version_number
1545: from
1546: hxc_approval_styles has,
1547: hxc_approval_comps hac,
1548: hxc_app_comp_notifications hacn,
1549: hxc_app_comp_notif_usages hacnu
1550: where
1551: has.approval_style_id = p_approval_style_id and
1552: has.approval_style_id = hac.approval_style_id and

Line 1565: hxc_app_comp_notifications hacn,

1561: ,p_object_version_number in number)
1562: is
1563: select count(1) from
1564: hxc_approval_comps hac,
1565: hxc_app_comp_notifications hacn,
1566: hxc_app_comp_notif_usages hacnu
1567: where
1568: hac.approval_comp_id not in (select hac.approval_comp_id from hxc_approval_comps hac
1569: where approval_style_id = p_approval_style_id) and

Line 1577: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%type;

1573: hacnu.comp_notification_id=p_comp_notification_id and
1574: hacnu.comp_notification_ovn=p_object_version_number;
1575:
1576: l_count number(9) :=0;
1577: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%type;
1578: l_object_version_number hxc_app_comp_notifications.object_version_number%type;
1579:
1580: begin
1581:

Line 1578: l_object_version_number hxc_app_comp_notifications.object_version_number%type;

1574: hacnu.comp_notification_ovn=p_object_version_number;
1575:
1576: l_count number(9) :=0;
1577: l_comp_notification_id hxc_app_comp_notifications.comp_notification_id%type;
1578: l_object_version_number hxc_app_comp_notifications.object_version_number%type;
1579:
1580: begin
1581:
1582:

Line 1596: hxc_app_comp_notifications_api.delete_app_comp_notification

1592:
1593: if(l_count =0)
1594: then
1595:
1596: hxc_app_comp_notifications_api.delete_app_comp_notification
1597: (
1598: p_comp_notification_id => l_comp_notification_id
1599: ,p_object_version_number => l_object_version_number
1600: );

Line 1602: hxc_app_comp_notifications_api.purge_comp_notification

1598: p_comp_notification_id => l_comp_notification_id
1599: ,p_object_version_number => l_object_version_number
1600: );
1601:
1602: hxc_app_comp_notifications_api.purge_comp_notification
1603: (
1604: p_comp_notification_id => l_comp_notification_id
1605: ,p_object_version_number => l_object_version_number
1606: );