APPS.PJI_UTILS dependencies on PJI_SYSTEM_PARAMETERS

Line 46: from PJI_SYSTEM_PARAMETERS

42: begin
43:
44: select VALUE
45: into l_result
46: from PJI_SYSTEM_PARAMETERS
47: where NAME = p_name;
48:
49: return l_result;
50:

Line 67: update PJI_SYSTEM_PARAMETERS

63: procedure SET_PARAMETER(p_name varchar2, p_value varchar2) is
64:
65: begin
66:
67: update PJI_SYSTEM_PARAMETERS
68: set VALUE = p_value
69: where NAME = p_name;
70:
71: if (sql%rowcount = 0) then

Line 73: into PJI_SYSTEM_PARAMETERS (NAME, VALUE)

69: where NAME = p_name;
70:
71: if (sql%rowcount = 0) then
72: insert
73: into PJI_SYSTEM_PARAMETERS (NAME, VALUE)
74: values (p_name, p_value);
75: end if;
76:
77: end SET_PARAMETER;

Line 463: TABLE_NAME = 'PJI_SYSTEM_PARAMETERS';

459: select TABLESPACE_NAME
460: into g_pji_data_tspace
461: from ALL_TABLES
462: where OWNER = l_pji_schema and
463: TABLE_NAME = 'PJI_SYSTEM_PARAMETERS';
464:
465: end if;
466:
467: return g_pji_data_tspace;

Line 489: INDEX_NAME = 'PJI_SYSTEM_PARAMETERS_U1';

485: select TABLESPACE_NAME
486: into g_pji_index_tspace
487: from ALL_INDEXES
488: where OWNER = l_pji_schema and
489: INDEX_NAME = 'PJI_SYSTEM_PARAMETERS_U1';
490:
491: end if;
492:
493: return g_pji_index_tspace;

Line 1319: pji_system_parameters params

1315: info.gl_curr_rep_period,
1316: params.value
1317: INTO l_specific_pa_period, l_specific_gl_period, l_specific_ent_period
1318: FROM pji_org_extr_info info,
1319: pji_system_parameters params
1320: WHERE info.org_id = p_org_id
1321: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
1322: EXCEPTION WHEN NO_DATA_FOUND THEN
1323: NULL;

Line 1707: PJI_SYSTEM_PARAMETERS PARAMS

1703: l_sp_curr_rep_pa_period,
1704: l_sp_curr_rep_gl_period,
1705: l_sp_curr_rep_ent_period
1706: FROM PJI_ORG_EXTR_INFO INFO,
1707: PJI_SYSTEM_PARAMETERS PARAMS
1708: WHERE 1=1
1709: AND ORG_ID = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
1710: ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)
1711: AND PARAMS.NAME = 'PJI_PJP_ENT_CURR_REP_PERIOD'; */