APPS.PJI_EXTRACTION_UTIL dependencies on PJI_ORG_EXTR_INFO

Line 147: UPDATE_ORG_EXTR_INFO; -- PJI_ORG_EXTR_INFO always maintained incrementally

143: procedure POPULATE_ORG_EXTR_INFO is
144:
145: begin
146:
147: UPDATE_ORG_EXTR_INFO; -- PJI_ORG_EXTR_INFO always maintained incrementally
148:
149: end POPULATE_ORG_EXTR_INFO;
150:
151:

Line 179: insert into PJI_ORG_EXTR_INFO

175: exception when no_data_found then null;
176:
177: end;
178:
179: insert into PJI_ORG_EXTR_INFO
180: (
181: ORG_ID,
182: PF_CURRENCY_CODE,
183: EN_CALENDAR_MIN_DATE,

Line 210: from PJI_ORG_EXTR_INFO)

206: not exists (select ORG_ID
207: from PA_IMPLEMENTATIONS_ALL
208: where ORG_ID is null) and
209: -1 not in (select ORG_ID
210: from PJI_ORG_EXTR_INFO)
211: union all
212: select
213: nvl(imp.ORG_ID,-1) ORG_ID,
214: to_char(null),

Line 227: from PJI_ORG_EXTR_INFO);

223: from
224: PA_IMPLEMENTATIONS_ALL imp
225: where
226: imp.ORG_ID not in (select ORG_ID
227: from PJI_ORG_EXTR_INFO);
228:
229: update PJI_ORG_EXTR_INFO info
230: set (PF_CURRENCY_CODE,
231: EN_CALENDAR_MIN_DATE,

Line 229: update PJI_ORG_EXTR_INFO info

225: where
226: imp.ORG_ID not in (select ORG_ID
227: from PJI_ORG_EXTR_INFO);
228:
229: update PJI_ORG_EXTR_INFO info
230: set (PF_CURRENCY_CODE,
231: EN_CALENDAR_MIN_DATE,
232: EN_CALENDAR_MAX_DATE,
233: GL_CALENDAR_ID,

Line 364: update PJI_ORG_EXTR_INFO

360: where
361: gl.ORG_ID = pa.ORG_ID and
362: gl.ORG_ID = info.ORG_ID);
363:
364: update PJI_ORG_EXTR_INFO
365: set PF_CURRENCY_CODE = 'PJI$NULL'
366: where ORG_ID = -1 and
367: nvl(PF_CURRENCY_CODE, 'x') <> 'PJI$NULL';
368:

Line 369: update PJI_ORG_EXTR_INFO

365: set PF_CURRENCY_CODE = 'PJI$NULL'
366: where ORG_ID = -1 and
367: nvl(PF_CURRENCY_CODE, 'x') <> 'PJI$NULL';
368:
369: update PJI_ORG_EXTR_INFO
370: set EN_CALENDAR_MIN_DATE = l_ent_cal_min_date,
371: EN_CALENDAR_MAX_DATE = l_ent_cal_max_date
372: where ORG_ID <> -1 and
373: (nvl(EN_CALENDAR_MIN_DATE, 1) <> l_ent_cal_min_date or