APPS.PJI_UTILS dependencies on PJI_SYSTEM_PARAMETERS

Line 50: from PJI_SYSTEM_PARAMETERS

46: begin
47:
48: select VALUE
49: into l_result
50: from PJI_SYSTEM_PARAMETERS
51: where NAME = p_name;
52: return l_result;
53:
54: exception

Line 64: from PJI_SYSTEM_PARAMETERS

60: /* Added for bug 13030627 */
61:
62: select VALUE
63: into l_result
64: from PJI_SYSTEM_PARAMETERS
65: where NAME = p_name;
66:
67: return l_result;
68:

Line 87: update PJI_SYSTEM_PARAMETERS

83: procedure SET_PARAMETER(p_name varchar2, p_value varchar2) is
84:
85: begin
86:
87: update PJI_SYSTEM_PARAMETERS
88: set VALUE = p_value
89: where NAME = p_name;
90:
91: if (sql%rowcount = 0) then

Line 93: into PJI_SYSTEM_PARAMETERS (NAME, VALUE)

89: where NAME = p_name;
90:
91: if (sql%rowcount = 0) then
92: insert
93: into PJI_SYSTEM_PARAMETERS (NAME, VALUE)
94: values (p_name, p_value);
95: end if;
96:
97: end SET_PARAMETER;

Line 483: TABLE_NAME = 'PJI_SYSTEM_PARAMETERS';

479: select TABLESPACE_NAME
480: into g_pji_data_tspace
481: from ALL_TABLES
482: where OWNER = l_pji_schema and
483: TABLE_NAME = 'PJI_SYSTEM_PARAMETERS';
484:
485: end if;
486:
487: return g_pji_data_tspace;

Line 509: INDEX_NAME = 'PJI_SYSTEM_PARAMETERS_U1';

505: select TABLESPACE_NAME
506: into g_pji_index_tspace
507: from ALL_INDEXES
508: where OWNER = l_pji_schema and
509: INDEX_NAME = 'PJI_SYSTEM_PARAMETERS_U1';
510:
511: end if;
512:
513: return g_pji_index_tspace;

Line 1436: pji_system_parameters params

1432: info.gl_curr_rep_period,
1433: params.value
1434: INTO l_specific_pa_period, l_specific_gl_period, l_specific_ent_period
1435: FROM pji_org_extr_info info,
1436: pji_system_parameters params
1437: WHERE info.org_id = p_org_id
1438: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
1439: EXCEPTION WHEN NO_DATA_FOUND THEN
1440: NULL;

Line 1876: PJI_SYSTEM_PARAMETERS PARAMS

1872: l_sp_curr_rep_pa_period,
1873: l_sp_curr_rep_gl_period,
1874: l_sp_curr_rep_ent_period
1875: FROM PJI_ORG_EXTR_INFO INFO,
1876: PJI_SYSTEM_PARAMETERS PARAMS
1877: WHERE 1=1
1878: AND ORG_ID = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
1879: ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)
1880: AND PARAMS.NAME = 'PJI_PJP_ENT_CURR_REP_PERIOD'; */