DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_GL_PERIODS_IT

Line 2271: PA_GL_PERIODS_IT

2267: END LOOP; -- FOR periods_r IN sel_periods
2268:
2269: FOR periods_gl IN gl_periods LOOP
2270: UPDATE
2271: PA_GL_PERIODS_IT
2272: SET
2273: START_DATE = PERIODS_GL.GL_PERIOD_START_DATE,
2274: END_DATE = PERIODS_GL.GL_PERIOD_END_DATE,
2275: TIMESPAN = PERIODS_GL.TIMESPAN,

Line 2292: INSERT INTO PA_GL_PERIODS_IT

2288: GL_PERIOD = PERIODS_GL.GL_PERIOD;
2289:
2290: IF (SQL%ROWCOUNT = 0) THEN
2291: -- No row was updated, So Insert a new row into the interface table
2292: INSERT INTO PA_GL_PERIODS_IT
2293: (
2294: GL_PERIOD,
2295: START_DATE,
2296: END_DATE,