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.BIS_PMV_PMF_PVT dependencies on DUAL

Line 902: --select 'Notice_'||bis_notification_id_s.nextval into vSessionId from dual;

898: --Create an entry in FND_LOBs and get the corresponding file id
899: vFileId := BIS_SAVE_REPORT.createEntry('BIS Notification', 'text/html', null, null);
900:
901: --jprabhud - 5/26/2004 - BugFix 3649405 for SONAR
902: --select 'Notice_'||bis_notification_id_s.nextval into vSessionId from dual;
903: select bis_notification_id_s.nextval into vNotifId from dual;
904: vSessionId := 'Notice_'|| vNotifId;
905:
906: --BugFix 2833251 Added p_resp_id

Line 903: select bis_notification_id_s.nextval into vNotifId from dual;

899: vFileId := BIS_SAVE_REPORT.createEntry('BIS Notification', 'text/html', null, null);
900:
901: --jprabhud - 5/26/2004 - BugFix 3649405 for SONAR
902: --select 'Notice_'||bis_notification_id_s.nextval into vSessionId from dual;
903: select bis_notification_id_s.nextval into vNotifId from dual;
904: vSessionId := 'Notice_'|| vNotifId;
905:
906: --BugFix 2833251 Added p_resp_id
907: if (p_resp_id is not null) then

Line 1574: --select 'Notice_'||bis_notification_id_s.nextval into vSessionId from dual;

1570: --Create an entry in FND_LOBs and get the corresponding file id
1571: vFileId := BIS_SAVE_REPORT.createEntry('BIS Notification', 'text/html', null, null);
1572:
1573: --jprabhud - 5/26/2004 - BugFix 3649405 for SONAR
1574: --select 'Notice_'||bis_notification_id_s.nextval into vSessionId from dual;
1575: select bis_notification_id_s.nextval into vNotifId from dual;
1576: vSessionId := 'Notice_'|| vNotifId;
1577:
1578: --BugFix 2833251 Added p_resp_id

Line 1575: select bis_notification_id_s.nextval into vNotifId from dual;

1571: vFileId := BIS_SAVE_REPORT.createEntry('BIS Notification', 'text/html', null, null);
1572:
1573: --jprabhud - 5/26/2004 - BugFix 3649405 for SONAR
1574: --select 'Notice_'||bis_notification_id_s.nextval into vSessionId from dual;
1575: select bis_notification_id_s.nextval into vNotifId from dual;
1576: vSessionId := 'Notice_'|| vNotifId;
1577:
1578: --BugFix 2833251 Added p_resp_id
1579: if (p_resp_id is not null) then