APPS.PJI_REP_UTIL dependencies on PJI_SYSTEM_PARAMETERS

Line 2802: pji_system_parameters params,

2798: info.gl_curr_rep_period,
2799: params.value
2800: INTO l_specific_pa_period, l_specific_gl_period, l_specific_ent_period
2801: FROM pji_org_extr_info info,
2802: pji_system_parameters params,
2803: pa_projects_all proj
2804: WHERE proj.project_id = p_project_id
2805: AND info.org_id = proj.org_id
2806: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';

Line 3125: FROM pji_system_parameters params

3121: -- ----------------------------------------------
3122: --Count funtion is introduced
3123: SELECT COUNT(params.name)
3124: INTO l_ent_period_count
3125: FROM pji_system_parameters params
3126: WHERE 1=1
3127: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
3128:
3129: IF l_ent_period_count = 0

Line 3133: INTO pji_system_parameters

3129: IF l_ent_period_count = 0
3130: THEN
3131:
3132: INSERT
3133: INTO pji_system_parameters
3134: (
3135: name,
3136: value
3137: )

Line 3145: UPDATE pji_system_parameters

3141: p_ent_curr_rep_period
3142: );
3143: ELSE
3144:
3145: UPDATE pji_system_parameters
3146: SET value = p_ent_curr_rep_period
3147: WHERE name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
3148:
3149: