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_OPEN_REMED_SUMM_PKG dependencies on FND_GLOBAL

Line 26: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

22: -- File scope variables
23:
24: g_global_start_date DATE;
25: g_rci_schema VARCHAR2(30);
26: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28:
29: PROCEDURE get_kpi(
30: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

Line 27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

23:
24: g_global_start_date DATE;
25: g_rci_schema VARCHAR2(30);
26: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28:
29: PROCEDURE get_kpi(
30: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
31: ,p_exp_source_sql out NOCOPY VARCHAR2

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

795: errbuf => errbuf
796: ,retcode => retcode);
797:
798: /***
799: l_user_id := NVL(fnd_global.USER_ID, -1);
800: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
801: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
802: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
803: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

796: ,retcode => retcode);
797:
798: /***
799: l_user_id := NVL(fnd_global.USER_ID, -1);
800: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
801: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
802: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
803: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
804: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

797:
798: /***
799: l_user_id := NVL(fnd_global.USER_ID, -1);
800: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
801: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
802: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
803: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
804: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
805: l_run_date := sysdate - 5/(24*60);

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

798: /***
799: l_user_id := NVL(fnd_global.USER_ID, -1);
800: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
801: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
802: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
803: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
804: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
805: l_run_date := sysdate - 5/(24*60);
806:

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

799: l_user_id := NVL(fnd_global.USER_ID, -1);
800: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
801: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
802: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
803: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
804: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
805: l_run_date := sysdate - 5/(24*60);
806:
807: INSERT INTO rci_dr_inc( fact_name

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

800: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
801: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
802: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
803: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
804: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
805: l_run_date := sysdate - 5/(24*60);
806:
807: INSERT INTO rci_dr_inc( fact_name
808: ,last_run_date

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

920: l_program_application_id NUMBER ;
921: l_request_id NUMBER ;
922:
923: BEGIN
924: l_user_id := NVL(fnd_global.USER_ID, -1);
925: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
926: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
927: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
928: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

921: l_request_id NUMBER ;
922:
923: BEGIN
924: l_user_id := NVL(fnd_global.USER_ID, -1);
925: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
926: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
927: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
928: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
929: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

922:
923: BEGIN
924: l_user_id := NVL(fnd_global.USER_ID, -1);
925: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
926: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
927: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
928: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
929: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
930:

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

923: BEGIN
924: l_user_id := NVL(fnd_global.USER_ID, -1);
925: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
926: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
927: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
928: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
929: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
930:
931: ----dbms_output.put_line( '1 **************' );

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

924: l_user_id := NVL(fnd_global.USER_ID, -1);
925: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
926: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
927: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
928: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
929: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
930:
931: ----dbms_output.put_line( '1 **************' );
932:

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

925: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
926: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
927: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
928: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
929: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
930:
931: ----dbms_output.put_line( '1 **************' );
932:
933: l_stmnt_id := 0;

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

1150: l_program_login_id NUMBER ;
1151: l_program_application_id NUMBER ;
1152: l_request_id NUMBER ;
1153: BEGIN
1154: l_user_id := NVL(fnd_global.USER_ID, -1);
1155: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1156: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1157: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1158: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);

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

1151: l_program_application_id NUMBER ;
1152: l_request_id NUMBER ;
1153: BEGIN
1154: l_user_id := NVL(fnd_global.USER_ID, -1);
1155: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1156: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1157: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1158: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1159: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);

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

1152: l_request_id NUMBER ;
1153: BEGIN
1154: l_user_id := NVL(fnd_global.USER_ID, -1);
1155: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1156: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1157: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1158: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1159: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1160:

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

1153: BEGIN
1154: l_user_id := NVL(fnd_global.USER_ID, -1);
1155: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1156: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1157: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1158: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1159: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1160:
1161: ----dbms_output.put_line( '1 **************' );

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

1154: l_user_id := NVL(fnd_global.USER_ID, -1);
1155: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1156: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1157: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1158: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1159: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1160:
1161: ----dbms_output.put_line( '1 **************' );
1162:

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

1155: l_login_id := NVL(fnd_global.LOGIN_ID, -1);
1156: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1157: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);
1158: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1159: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1160:
1161: ----dbms_output.put_line( '1 **************' );
1162:
1163: l_stmnt_id := 0;