APPS.PJI_REP_UTIL dependencies on PJI_ORG_EXTR_INFO

Line 1182: pji_org_extr_info org

1178: SELECT org.gl_calendar_id,org.pa_calendar_id
1179: INTO l_gl_calendar_id, l_pa_calendar_id
1180: FROM
1181: pa_projects_all projects,
1182: pji_org_extr_info org
1183: /* WHERE NVL(projects.org_id,-99) = NVL(org.org_id,-99) -- Added NVL for bug 3989132 */
1184: WHERE projects.org_id = org.org_id -- Removed NVL for Bug5376591
1185: AND projects.project_id = p_project_id;
1186:

Line 1840: , pji_org_extr_info info

1836: , g_prg_flag
1837: , g_gl_calendar_id
1838: , g_pa_calendar_id
1839: FROM pa_projects_all prj
1840: , pji_org_extr_info info
1841: WHERE project_id = p_project_id
1842: /* AND NVL(info.org_id,-99) = NVL(prj.org_id,-99); -- Added NVL for bug 3989132 */
1843: AND info.org_id = prj.org_id; -- Removed NVL for Bug5376591
1844:

Line 2742: FROM pji_org_extr_info info, pa_projects_all proj

2738: x_calendar_id := -1;
2739: ELSE
2740: SELECT info.gl_calendar_id, info.pa_calendar_id
2741: INTO l_gl_calendar_id, l_pa_calendar_id
2742: FROM pji_org_extr_info info, pa_projects_all proj
2743: WHERE info.org_id = proj.org_id
2744: AND proj.project_id = p_project_id;
2745:
2746: IF p_calendar_type = 'G' THEN

Line 2801: FROM pji_org_extr_info info,

2797: info.pa_curr_rep_period,
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

Line 3084: -- check if pji_org_extr_info table has a record for p_org_id

3080: IF g_debug_mode = 'Y' THEN
3081: Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: begining', TRUE , g_proc);
3082: END IF;
3083:
3084: -- check if pji_org_extr_info table has a record for p_org_id
3085: -- Count funtion is introduced
3086: SELECT COUNT(info.org_id)
3087: INTO l_org_id_count
3088: FROM pji_org_extr_info info

Line 3088: FROM pji_org_extr_info info

3084: -- check if pji_org_extr_info table has a record for p_org_id
3085: -- Count funtion is introduced
3086: SELECT COUNT(info.org_id)
3087: INTO l_org_id_count
3088: FROM pji_org_extr_info info
3089: WHERE 1=1
3090: AND info.org_id = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99);
3091:
3092:

Line 3099: INTO pji_org_extr_info

3095:
3096: -- insert p_org_id, pa_curr_rep_period and gl_curr_rep_period (everything else is null)
3097:
3098: INSERT
3099: INTO pji_org_extr_info
3100: (
3101: org_id,
3102: pa_curr_rep_period,
3103: gl_curr_rep_period

Line 3115: UPDATE pji_org_extr_info

3111: ELSE
3112:
3113: -- update pa_curr_rep_period and gl_curr_rep_period
3114:
3115: UPDATE pji_org_extr_info
3116: SET pa_curr_rep_period = p_pa_curr_rep_period,
3117: gl_curr_rep_period = p_gl_curr_rep_period
3118: WHERE org_id = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99);
3119: END IF;

Line 5194: , pji_org_extr_info info

5190: FROM
5191: pji_xbs_denorm denorm
5192: , pa_proj_elements elem
5193: , pa_projects_all proj
5194: , pji_org_extr_info info
5195: WHERE 1=1
5196: AND denorm.sup_project_id = p_project_id -- project_id
5197: AND denorm.sup_id = p_wbs_version_id -- wbs_version_id
5198: AND denorm.struct_type = 'PRG'

Line 5977: FROM pji_org_extr_info info, pa_projects_all proj

5973: END IF;
5974:
5975: SELECT info.gl_calendar_id, info.pa_calendar_id
5976: INTO l_gl_calendar_id, l_pa_calendar_id
5977: FROM pji_org_extr_info info, pa_projects_all proj
5978: WHERE info.org_id = proj.org_id
5979: AND proj.project_id = p_project_id;
5980:
5981: IF x_calendar_type IS NULL THEN