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.PJI_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44


    select VALUE
    into   l_result
    from   PJI_SYSTEM_PARAMETERS
    where  NAME = p_name;

Line: 67


    update PJI_SYSTEM_PARAMETERS
    set    VALUE = p_value
    where  NAME  = p_name;

Line: 72


      insert
      into   PJI_SYSTEM_PARAMETERS (NAME, VALUE)
      values (p_name, p_value);

Line: 89


      select ORACLE_USERNAME
      into   g_apps_schema
      from   FND_ORACLE_USERID
      where  ORACLE_ID = 900;

Line: 268


        insert into PJI_SYSTEM_DEBUG_MSG
        (
          MESSAGE_ID,
          MESSAGE_LEVEL,
          MESSAGE_CONTEXT,
          MESSAGE_TEXT,
          MESSAGE_TYPE,
          MODULE,
          CREATED_BY,
          CREATION_DATE
        )
        values
        (
          PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,
          p_debug_level,
          nvl(g_debug_context, g_session_osuser || '$' || g_session_sid),
          p_msg || l_timestamp,
          'LOG',
          g_module,
          g_session_user_id,
          sysdate
        );

Line: 325


      insert into PJI_SYSTEM_DEBUG_MSG
      (
        MESSAGE_ID,
        MESSAGE_LEVEL,
        MESSAGE_CONTEXT,
        MESSAGE_TEXT,
        MESSAGE_TYPE,
        MODULE,
        CREATED_BY,
        CREATION_DATE
      )
      values
      (
        PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,
        6,
        nvl(g_debug_context, g_session_osuser || '$' || g_session_sid),
        p_msg,
        'OUT',
        g_module,
        g_session_user_id,
        sysdate
      );

Line: 409


      insert into PJI_SYSTEM_DEBUG_MSG
      (
        MESSAGE_ID
      , MESSAGE_LEVEL
      , MESSAGE_CONTEXT
      , MESSAGE_TEXT
      , MESSAGE_TYPE
      , MODULE
      , CREATED_BY
      , CREATION_DATE
      )
      values
      (
        PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL
      , p_debug_level
      , fnd_global.user_id || '$' || g_session_sid
      , p_msg
      , 'SSWA'
      , p_module
      , fnd_global.user_id
      , sysdate
      );

Line: 459


      select TABLESPACE_NAME
      into   g_pji_data_tspace
      from   ALL_TABLES
      where  OWNER      = l_pji_schema and
             TABLE_NAME = 'PJI_SYSTEM_PARAMETERS';

Line: 485


      select TABLESPACE_NAME
      into   g_pji_index_tspace
      from   ALL_INDEXES
      where  OWNER      = l_pji_schema and
             INDEX_NAME = 'PJI_SYSTEM_PARAMETERS_U1';

Line: 715


    select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
    into   l_mau
    from   FND_CURRENCIES curr
    where  curr.CURRENCY_CODE = l_warehouse_currency_code;

Line: 840


    select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
    into   l_mau
    from   FND_CURRENCIES curr
    where  curr.CURRENCY_CODE = l_warehouse_currency_code;

Line: 971


    select nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))
    into   l_mau
    from   FND_CURRENCIES
    where  CURRENCY_CODE = p_currency_code;

Line: 1017


      select value INTO l_parallel
      from v$pq_sysstat where trim(statistic) = 'Servers Idle';

Line: 1197


SELECT user_conversion_type
FROM gl_daily_conversion_types
WHERE conversion_type = p_rate_type;

Line: 1260


    select /*+ index(rel, PA_OBJECT_RELATIONSHIPS_N2) */
      count(*)
    into
      l_count
    from
      PA_OBJECT_RELATIONSHIPS rel,
      PA_RBS_PRJ_ASSIGNMENTS rbs
    where
      ROWNUM                  = 1                and
      rel.OBJECT_TYPE_TO      = 'PA_STRUCTURES'  and
      rel.OBJECT_ID_TO1       is not null        and
      rel.OBJECT_ID_TO2       = p_project_id     and
      rel.RELATIONSHIP_TYPE   in ('LW', 'LF')    and
      rbs.RBS_VERSION_ID      = p_rbs_version_id and
      rbs.PROG_REP_USAGE_FLAG = 'Y'              and
      rbs.PROJECT_ID          = rel.OBJECT_ID_FROM2;

Line: 1313


		    SELECT
	    		info.pa_curr_rep_period,
				info.gl_curr_rep_period,
				params.value
			INTO l_specific_pa_period, l_specific_gl_period, l_specific_ent_period
			FROM pji_org_extr_info info,
			     pji_system_parameters params
			WHERE info.org_id = p_org_id
			AND params.name  = 'PJI_PJP_ENT_CURR_REP_PERIOD';

Line: 1329


		   SELECT start_date
		   INTO l_report_date
		   FROM pji_time_ent_period_v
		   WHERE TRUNC(SYSDATE) BETWEEN start_date AND end_date;

Line: 1336


			  SELECT MAX(start_date)
			  INTO l_report_date
			  FROM pji_time_ent_period_v
			  WHERE end_date


Line: 1344

	     	SELECT name
			INTO l_period_name
			FROM pji_time_ent_period_v
			WHERE l_report_date BETWEEN start_date AND end_date;

Line: 1351

	   SELECT info.gl_calendar_id, info.pa_calendar_id
	   INTO l_gl_calendar_id, l_pa_calendar_id
	   FROM pji_org_extr_info info
	   WHERE info.org_id = p_org_id;

Line: 1367

			SELECT MIN(TIM.start_date) first_open
			INTO l_report_date
			FROM
			pji_time_cal_period_v TIM
			, gl_period_statuses glps
			, pa_implementations_all paimp
			WHERE 1=1
			AND TIM.calendar_id = l_calendar_id
			AND paimp.set_of_books_id = glps.set_of_books_id
                        AND paimp.org_id = p_org_id
			AND glps.application_id = l_application_id
			AND glps.period_name = TIM.NAME
			AND closing_status = 'O';

Line: 1381

			SELECT MAX(TIM.start_date) last_open
			INTO l_report_date
			FROM
			pji_time_cal_period_v TIM
			, gl_period_statuses glps
			, pa_implementations_all paimp
			WHERE 1=1
			AND TIM.calendar_id = l_calendar_id
			AND paimp.set_of_books_id = glps.set_of_books_id
                        AND paimp.org_id = p_org_id
			AND glps.application_id = 275
			AND glps.period_name = TIM.NAME
			AND closing_status = 'O';

Line: 1395

			SELECT MAX(TIM.start_date) last_closed
			INTO  l_report_date
			FROM
			pji_time_cal_period_v TIM
			, gl_period_statuses glps
			, pa_implementations_all paimp
			WHERE 1=1
			AND TIM.calendar_id = l_calendar_id
			AND paimp.set_of_books_id = glps.set_of_books_id
                        AND paimp.org_id = p_org_id
			AND glps.application_id = l_application_id
			AND glps.period_name = TIM.NAME
			AND closing_status = 'C';

Line: 1409

			SELECT start_date
			INTO l_report_date
			FROM pji_time_cal_period_v
			WHERE TRUNC(SYSDATE) BETWEEN start_date
			AND end_date
			AND calendar_id = l_calendar_id;

Line: 1418

			SELECT MAX(start_date)
			INTO l_report_date
			FROM pji_time_cal_period_v
			WHERE end_date < l_report_date
			AND calendar_id = l_calendar_id;

Line: 1428

			SELECT name
			INTO l_period_name
			FROM pji_time_cal_period_v
			WHERE l_report_date BETWEEN start_date AND end_date
			AND calendar_id = l_calendar_id;

Line: 1522

SELECT OP.PROFILE_OPTION_NAME,VAL.PROFILE_OPTION_VALUE BULK COLLECT
INTO prof_opt_tbl,prof_val_tbl
FROM   FND_PROFILE_OPTIONS OP ,  FND_PROFILE_OPTION_VALUES VAL
WHERE OP.PROFILE_OPTION_NAME
IN ('BIS_PRIMARY_CURRENCY_CODE','BIS_PRIMARY_RATE_TYPE','BIS_SECONDARY_CURRENCY_CODE',
'BIS_SECONDARY_RATE_TYPE','BIS_ENTERPRISE_CALENDAR','BIS_PERIOD_TYPE','BIS_GLOBAL_START_DATE',
'PJI_GLOBAL_START_DATE_OVERRIDE')
AND VAL.PROFILE_OPTION_ID = OP.PROFILE_OPTION_ID
AND    VAL.APPLICATION_ID    = OP.APPLICATION_ID
AND    LEVEL_ID          = 10001
AND    LEVEL_VALUE       = 0;

Line: 1570

SELECT  lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
INTO prof_opt_tbl,prof_val_tbl
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_BIS_PARAMS'
	and lookup_code in ( 'BIS_PR_CURR',
'BIS_PR_RATE',
'BIS_SE_CURR',
'BIS_SE_RATE',
'BIS_ENT_CAL',
'BIS_GLO_ST_DT',
'BIS_PD_TYPE',
'PJI_GLO_ST_DT');

Line: 1633

SELECT FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_TEXT'),
FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD1'),
FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD2'),
FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD3'),
FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD4'),
FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_REPORT_HEAD5'),
FND_MESSAGE.GET_STRING('PJI','PJI_PJP_PERF_SETUP'),
FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_BIS_SETUP'),
FND_MESSAGE.GET_STRING('PJI','PJI_CHK_PJP_SETUP'),
FND_MESSAGE.GET_STRING('PJI','PJI_PJP_CUR_PERIOD'),
FND_MESSAGE.GET_STRING('PJI','PJI_CURR_REP_DEF')
INTO l_pji_report_msg,l_pji_head1,l_pji_head2,l_pji_head3,l_pji_head4,l_pji_head5,
l_pji_foot1,l_pji_foot2,l_pji_foot3,l_pji_foot4,l_p_curr_rep_not
FROM dual;

Line: 1648

select
RPAD(l_separator,Length(l_separator)+Length(l_pji_report_msg),'*'),
RPAD(l_pji_line2,length(l_pji_head2),'-'),
RPAD(l_pji_line3,length(l_pji_head3),'-'),
RPAD(l_pji_line4,length(l_pji_head4),'-'),
RPAD(l_pji_line5,length(l_pji_head5),'-')
into
l_separator,l_pji_line2,l_pji_line3,l_pji_line4,l_pji_line5
from dual;

Line: 1676

SELECT
GLOBAL_CURR2_FLAG GLB_CURR_FLAG,       -- Secondary global Currency (Optional)
TXN_CURR_FLAG TXN_CURR_FLAG,      -- Transaction Currency (Optional)
PLANAMT_CONV_DATE PLANAMT_CONV_DATE,       -- Planned amount conversion (Mandatory)
PLANAMT_ALLOC_METHOD PLANAMT_ALLOC_METHOD, -- Planning amount allocation (Mandatory)
CURR_REP_PA_PERIOD  CURR_REP_PA_PERIOD,    -- GL periods (Mandatory)-
CURR_REP_GL_PERIOD CURR_REP_GL_PERIOD,     -- PA periods (Mandatory)-
CURR_REP_ENT_PERIOD CURR_REP_ENT_PERIOD    -- Enterprise (global) periods (Mandatory)
INTO
l_glb_curr_flag,
l_txn_curr_flag,
l_planamt_conv_date,
l_planamt_alloc_method,
l_curr_rep_pa_period,
l_curr_rep_gl_period,
l_curr_rep_ent_period
FROM PJI_SYSTEM_SETTINGS;

Line: 1699

/*SELECT INFO.PA_CURR_REP_PERIOD PROJECT_PERIOD_NAME,  -- PA periods (Mandatory)-
	   INFO.GL_CURR_REP_PERIOD FISCAL_PERIOD_NAME,     -- GL periods (Mandatory)-
	   PARAMS.VALUE GLOBAL_PERIOD_NAME 		      -- Enterprise (global) periods (Mandatory)
INTO
l_sp_curr_rep_pa_period,
l_sp_curr_rep_gl_period,
l_sp_curr_rep_ent_period
FROM   PJI_ORG_EXTR_INFO INFO,
       PJI_SYSTEM_PARAMETERS PARAMS
WHERE 1=1
       AND ORG_ID = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
      '    ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)
       AND PARAMS.NAME = 'PJI_PJP_ENT_CURR_REP_PERIOD';   */

Line: 1712

SELECT ORG.name,
       DECODE(l_curr_rep_pa_period,'SPECIFIC',INFO.PA_CURR_REP_PERIOD, Derive_curr_rep_Info(ORG_ID,'P',l_curr_rep_pa_period)) PROJECT_PERIOD_NAME,  -- PA periods (Mandatory)-
       DECODE(l_curr_rep_gl_period,'SPECIFIC',INFO.GL_CURR_REP_PERIOD, Derive_curr_rep_Info(ORG_ID,'G',l_curr_rep_gl_period)) FISCAL_PERIOD_NAME,     -- GL periods (Mandatory)
       DECODE(l_curr_rep_ent_period,'SPECIFIC',pji_utils.get_parameter('PJI_PJP_ENT_CURR_REP_PERIOD'), Derive_curr_rep_Info(ORG_ID,'E',l_curr_rep_ent_period)) GLOBAL_PERIOD_NAME 		      -- Enterprise (global) periods (Mandatory)
BULK COLLECT INTO
l_sp_curr_rep_org_tbl,
l_sp_curr_rep_pa_period_tbl,
l_sp_curr_rep_gl_period_tbl,
l_sp_curr_rep_ent_period_tbl
FROM   PJI_ORG_EXTR_INFO INFO,
       HR_ALL_ORGANIZATION_UNITS_VL ORG
WHERE  ORGANIZATION_ID = ORG_ID
  ORDER BY ORG.NAME;

Line: 1740

SELECT  lookup_code , RPAD(MEANING,45,' ')||': ' BULK COLLECT
INTO prof_opt_tbl,prof_val_tbl
	FROM pji_lookups
	WHERE lookup_type = 'PJI_CHK_PJP_SET_PARAMS'
	and lookup_code in ( 'PJP_SE_GLO_CURR',
'PJP_TXN_CURR',
'PJP_PLN_AMT_ALC',
'PJP_PLN_AMT_CON',
'PJP_CURR_REP_PA_PD',
'PJP_CURR_REP_GL_PD',
'PJP_CURR_REP_EN_PD');

Line: 1935

 SELECT meaning into l_meaning
 FROM pji_lookups
 WHERE lookup_type = p_lookup_type
 and lookup_code = p_lookup_code;

Line: 1962

select 'Y'
into l_return
from dual
where  exists (SELECT 1
               FROM   pa_proj_element_versions pa
                     ,pa_proj_element_versions pap
                     ,pa_pji_proj_events_log log
               WHERE  pa.project_id=p_project_id
		 and  pa.prg_group=pap.prg_group
		 and pa.OBJECT_TYPE=pap.OBJECT_TYPE
		 and pa.OBJECT_TYPE='PA_STRUCTURES'
	         and log.event_object=to_char(pap.project_id)
		 and log.event_type='PLANTYPE_UPG'
                 );

Line: 1998

select PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') into l_status from dual;

Line: 2000

     select count(1) into l_count from PJI_SYSTEM_CONFIG_HIST
     where  PROCESS_NAME = 'STAGE3'
     and END_DATE is null and RUN_TYPE = 'CLEANALL';

Line: 2031

    select *
    into g_pji_settings
    from pji_system_settings;

Line: 2042

    select sid, osuser
    into g_session_sid, g_session_osuser
    from v$session
    where audsid = userenv('SESSIONID');