APPS.PJI_CURR_REP_PERIODS_UTIL dependencies on PJI_ORG_EXTR_INFO

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

29: IF g_debug_mode = 'Y' THEN
30: Pji_Utils.WRITE2LOG( 'update_curr_rep_periods: begining', TRUE , g_proc);
31: END IF;
32:
33: -- check if pji_org_extr_info table has a record for p_org_id
34: -- Count funtion is introduced
35: SELECT COUNT(info.org_id)
36: INTO l_org_id_count
37: FROM pji_org_extr_info info

Line 37: FROM pji_org_extr_info info

33: -- check if pji_org_extr_info table has a record for p_org_id
34: -- Count funtion is introduced
35: SELECT COUNT(info.org_id)
36: INTO l_org_id_count
37: FROM pji_org_extr_info info
38: WHERE 1=1
39: AND info.org_id = p_org_id;
40:
41:

Line 48: INTO pji_org_extr_info

44:
45: -- insert p_org_id, pa_curr_rep_period and gl_curr_rep_period (everything else is null)
46:
47: INSERT
48: INTO pji_org_extr_info
49: (
50: org_id,
51: pa_curr_rep_period,
52: gl_curr_rep_period

Line 65: UPDATE pji_org_extr_info

61: ELSE
62:
63: -- update pa_curr_rep_period and gl_curr_rep_period
64:
65: UPDATE pji_org_extr_info
66: SET pa_curr_rep_period = p_pa_curr_rep_period,
67: gl_curr_rep_period = p_gl_curr_rep_period
68: --WHERE org_id = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99);
69: WHERE org_id = p_org_id;