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.RCI_PROC_CERT_SUMM_PKG dependencies on FND_GLOBAL

Line 16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14: --- the get_proc_certification_result procedure is called by Process Certification Summary report.
15:
16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
18:
19: function get_default_year return varchar2 is
20: begin

Line 17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

13: -- Enter procedure, function bodies as shown below
14: --- the get_proc_certification_result procedure is called by Process Certification Summary report.
15:
16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
18:
19: function get_default_year return varchar2 is
20: begin
21: return to_char(sysdate,'YYYY');

Line 697: l_user_id := NVL(fnd_global.USER_ID, -1);

693: time_rec.report_date_julian := r_proc.report_date_julian;
694: update_proc_cert_table(r_proc.process_id, r_proc.organization_id, cert_rec, time_rec);
695: END LOOP;
696: */
697: l_user_id := NVL(fnd_global.USER_ID, -1);
698: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
699: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
700: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
701: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

Line 698: l_login_id := NVL(fnd_global.LOGIN_ID, -1);

694: update_proc_cert_table(r_proc.process_id, r_proc.organization_id, cert_rec, time_rec);
695: END LOOP;
696: */
697: l_user_id := NVL(fnd_global.USER_ID, -1);
698: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
699: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
700: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
701: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
702: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

Line 699: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

695: END LOOP;
696: */
697: l_user_id := NVL(fnd_global.USER_ID, -1);
698: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
699: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
700: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
701: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
702: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
703: l_run_date := sysdate - 5/(24*60);

Line 700: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

696: */
697: l_user_id := NVL(fnd_global.USER_ID, -1);
698: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
699: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
700: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
701: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
702: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
703: l_run_date := sysdate - 5/(24*60);
704:

Line 701: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

697: l_user_id := NVL(fnd_global.USER_ID, -1);
698: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
699: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
700: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
701: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
702: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
703: l_run_date := sysdate - 5/(24*60);
704:
705: DELETE FROM rci_dr_inc WHERE fact_name='RCI_PROC_CERT_SUM_F';

Line 702: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

698: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
699: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
700: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
701: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
702: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
703: l_run_date := sysdate - 5/(24*60);
704:
705: DELETE FROM rci_dr_inc WHERE fact_name='RCI_PROC_CERT_SUM_F';
706: