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_API

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