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

Line 823: WHERE o.responsibility_id = fnd_global.resp_id

819: l_sec_where_clause :=
820: ' AND (EXISTS
821: (SELECT 1
822: FROM org_access o
823: WHERE o.responsibility_id = fnd_global.resp_id
824: AND o.resp_application_id = fnd_global.resp_appl_id
825: AND o.organization_id = fact.organization_id)
826: OR EXISTS
827: (SELECT 1

Line 824: AND o.resp_application_id = fnd_global.resp_appl_id

820: ' AND (EXISTS
821: (SELECT 1
822: FROM org_access o
823: WHERE o.responsibility_id = fnd_global.resp_id
824: AND o.resp_application_id = fnd_global.resp_appl_id
825: AND o.organization_id = fact.organization_id)
826: OR EXISTS
827: (SELECT 1
828: FROM mtl_parameters org

Line 3815: l_user_id := nvl(fnd_global.user_id, -1);

3811: BEGIN
3812: --{
3813: l_stmt_id := 0;
3814: --Initialization of variables
3815: l_user_id := nvl(fnd_global.user_id, -1);
3816: l_login_id := nvl(fnd_global.login_id, -1);
3817: l_program_id := nvl (fnd_global.conc_program_id, -1);
3818: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
3819: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);

Line 3816: l_login_id := nvl(fnd_global.login_id, -1);

3812: --{
3813: l_stmt_id := 0;
3814: --Initialization of variables
3815: l_user_id := nvl(fnd_global.user_id, -1);
3816: l_login_id := nvl(fnd_global.login_id, -1);
3817: l_program_id := nvl (fnd_global.conc_program_id, -1);
3818: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
3819: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
3820: l_request_id := nvl (fnd_global.conc_request_id, -1);

Line 3817: l_program_id := nvl (fnd_global.conc_program_id, -1);

3813: l_stmt_id := 0;
3814: --Initialization of variables
3815: l_user_id := nvl(fnd_global.user_id, -1);
3816: l_login_id := nvl(fnd_global.login_id, -1);
3817: l_program_id := nvl (fnd_global.conc_program_id, -1);
3818: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
3819: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
3820: l_request_id := nvl (fnd_global.conc_request_id, -1);
3821:

Line 3818: l_program_login_id := nvl (fnd_global.conc_login_id, -1);

3814: --Initialization of variables
3815: l_user_id := nvl(fnd_global.user_id, -1);
3816: l_login_id := nvl(fnd_global.login_id, -1);
3817: l_program_id := nvl (fnd_global.conc_program_id, -1);
3818: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
3819: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
3820: l_request_id := nvl (fnd_global.conc_request_id, -1);
3821:
3822: l_stmt_id := 10;

Line 3819: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);

3815: l_user_id := nvl(fnd_global.user_id, -1);
3816: l_login_id := nvl(fnd_global.login_id, -1);
3817: l_program_id := nvl (fnd_global.conc_program_id, -1);
3818: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
3819: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
3820: l_request_id := nvl (fnd_global.conc_request_id, -1);
3821:
3822: l_stmt_id := 10;
3823: MERGE INTO OPI_DBI_CONC_PROG_RUN_LOG log

Line 3820: l_request_id := nvl (fnd_global.conc_request_id, -1);

3816: l_login_id := nvl(fnd_global.login_id, -1);
3817: l_program_id := nvl (fnd_global.conc_program_id, -1);
3818: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
3819: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
3820: l_request_id := nvl (fnd_global.conc_request_id, -1);
3821:
3822: l_stmt_id := 10;
3823: MERGE INTO OPI_DBI_CONC_PROG_RUN_LOG log
3824: USING (