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.PQH_PROCESS_EMP_REVIEW dependencies on WF_NOTIFICATION

Line 660: WF_NOTIFICATION.setAttrText(p_ntf_id,'PQH_EMP_NAME',p_employee_name);

656: p_location IN VARCHAR2,
657: p_comments IN VARCHAR2 ) IS
658: BEGIN
659: if p_employee_name is not null then
660: WF_NOTIFICATION.setAttrText(p_ntf_id,'PQH_EMP_NAME',p_employee_name);
661: end if;
662:
663: if p_review_type is not null THEN
664: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_REVIEW_TYPE', p_review_type);

Line 664: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_REVIEW_TYPE', p_review_type);

660: WF_NOTIFICATION.setAttrText(p_ntf_id,'PQH_EMP_NAME',p_employee_name);
661: end if;
662:
663: if p_review_type is not null THEN
664: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_REVIEW_TYPE', p_review_type);
665: end if;
666:
667: if p_date_start is not null then
668: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_DATE',

Line 668: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_DATE',

664: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_REVIEW_TYPE', p_review_type);
665: end if;
666:
667: if p_date_start is not null then
668: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_DATE',
669: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start)));
670: end if;
671:
672: if p_date_end is not null then

Line 673: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_DATE',

669: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start)));
670: end if;
671:
672: if p_date_end is not null then
673: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_DATE',
674: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_End)));
675: end if;
676:
677: if p_Time_Start is not null then

Line 678: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_TIME', p_Time_Start);

674: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_End)));
675: end if;
676:
677: if p_Time_Start is not null then
678: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_TIME', p_Time_Start);
679: end if;
680:
681: if p_Time_End is not null then
682: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_TIME', p_Time_End);

Line 682: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_TIME', p_Time_End);

678: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_TIME', p_Time_Start);
679: end if;
680:
681: if p_Time_End is not null then
682: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_TIME', p_Time_End);
683: end if;
684:
685: if p_location is not null then
686: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_LOCATION', p_location);

Line 686: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_LOCATION', p_location);

682: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_TIME', p_Time_End);
683: end if;
684:
685: if p_location is not null then
686: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_LOCATION', p_location);
687: end if;
688:
689: if p_Comments is not null then
690: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_COMMENTS', p_Comments);

Line 690: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_COMMENTS', p_Comments);

686: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_LOCATION', p_location);
687: end if;
688:
689: if p_Comments is not null then
690: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_COMMENTS', p_Comments);
691: end if;
692:
693: WF_NOTIFICATION.setAttrText(p_ntf_id,'#FROM_ROLE',fnd_global.user_name);
694:

Line 693: WF_NOTIFICATION.setAttrText(p_ntf_id,'#FROM_ROLE',fnd_global.user_name);

689: if p_Comments is not null then
690: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_COMMENTS', p_Comments);
691: end if;
692:
693: WF_NOTIFICATION.setAttrText(p_ntf_id,'#FROM_ROLE',fnd_global.user_name);
694:
695: --Bug 3014549: Adding Commit as it is needed to display attribute values, just set, for the notification
696: COMMIT;
697:

Line 779: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_MSG',NULL,NULL,NULL,NULL,NULl);

775:
776: -- Send notification to the person if notify flag is turned on
777: if l_userName is not null then
778: if ( l_notify_flag = 'Y') then
779: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_MSG',NULL,NULL,NULL,NULL,NULl);
780: --
781: set_notification_attributes (
782: p_ntf_id => l_id,
783: p_employee_name => l_employee_name,

Line 916: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_REMOVED_MSG',NULL,NULL,NULL,NULL,NULl);

912: --
913: IF ( l_userName IS NOT NULL AND l_status in ('D','N') ) THEN
914: --
915: If l_status = 'D' Then
916: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_REMOVED_MSG',NULL,NULL,NULL,NULL,NULl);
917: elsif l_status = 'N' Then
918: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_ADDED_MSG',NULL,NULL,NULL,NULL,NULl);
919: end if;
920: --

Line 918: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_ADDED_MSG',NULL,NULL,NULL,NULL,NULl);

914: --
915: If l_status = 'D' Then
916: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_REMOVED_MSG',NULL,NULL,NULL,NULL,NULl);
917: elsif l_status = 'N' Then
918: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_ADDED_MSG',NULL,NULL,NULL,NULL,NULl);
919: end if;
920: --
921: set_notification_attributes (
922: p_ntf_id => l_id,