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: /* Commented and added as a part of Bug#10239077 Starts
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: /* Commented and added as a part of Bug#10239077 Starts
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: if p_date_start is not null then
677: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_DATE',

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

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: if p_date_start is not null then
677: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_DATE',
678: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start), calendar_aware => FND_DATE.calendar_aware_alt));
679: end if;
680:
681: if p_date_end is not null then

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

678: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_Start), calendar_aware => FND_DATE.calendar_aware_alt));
679: end if;
680:
681: if p_date_end is not null then
682: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_DATE',
683: FND_DATE.date_to_displaydate(fnd_date.chardt_to_date(p_Date_End), calendar_aware => FND_DATE.calendar_aware_alt));
684: end if;
685: /* Commented and added as a part of Bug#10239077 Ends */
686:

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

684: end if;
685: /* Commented and added as a part of Bug#10239077 Ends */
686:
687: if p_Time_Start is not null then
688: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_TIME', p_Time_Start);
689: end if;
690:
691: if p_Time_End is not null then
692: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_TIME', p_Time_End);

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

688: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_START_TIME', p_Time_Start);
689: end if;
690:
691: if p_Time_End is not null then
692: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_TIME', p_Time_End);
693: end if;
694:
695: if p_location is not null then
696: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_LOCATION', p_location);

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

692: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_END_TIME', p_Time_End);
693: end if;
694:
695: if p_location is not null then
696: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_LOCATION', p_location);
697: end if;
698:
699: if p_Comments is not null then
700: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_COMMENTS', p_Comments);

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

696: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_LOCATION', p_location);
697: end if;
698:
699: if p_Comments is not null then
700: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_COMMENTS', p_Comments);
701: end if;
702:
703: WF_NOTIFICATION.setAttrText(p_ntf_id,'#FROM_ROLE',fnd_global.user_name);
704:

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

699: if p_Comments is not null then
700: WF_NOTIFICATION.setAttrText(p_ntf_id, 'PQH_COMMENTS', p_Comments);
701: end if;
702:
703: WF_NOTIFICATION.setAttrText(p_ntf_id,'#FROM_ROLE',fnd_global.user_name);
704:
705: --Bug 3014549: Adding Commit as it is needed to display attribute values, just set, for the notification
706: COMMIT;
707:

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

790:
791: -- Send notification to the person if notify flag is turned on
792: if l_userName is not null then
793: if ( l_notify_flag = 'Y') then
794: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_MSG',NULL,NULL,NULL,NULL,NULl);
795: --
796: set_notification_attributes (
797: p_ntf_id => l_id,
798: p_employee_name => l_employee_name,

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

927: --
928: IF ( l_userName IS NOT NULL AND l_status in ('D','N') ) THEN
929: --
930: If l_status = 'D' Then
931: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_REMOVED_MSG',NULL,NULL,NULL,NULL,NULl);
932: elsif l_status = 'N' Then
933: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_ADDED_MSG',NULL,NULL,NULL,NULL,NULl);
934: end if;
935: --

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

929: --
930: If l_status = 'D' Then
931: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_REMOVED_MSG',NULL,NULL,NULL,NULL,NULl);
932: elsif l_status = 'N' Then
933: l_id := WF_NOTIFICATION.send (l_userName,'HRSSA','PQH_EMP_REV_ADDED_MSG',NULL,NULL,NULL,NULL,NULl);
934: end if;
935: --
936: set_notification_attributes (
937: p_ntf_id => l_id,