DBA Data[Home] [Help]

APPS.PA_PURGE dependencies on PA_UTILS2

Line 373: PA_UTILS2.ARPUR_Commit_Size := p_commit_size;

369:
370: -- Count MRC reporting set of books
371: -- and set ARPUR_MRC_COMMIT_SIZE.
372:
373: PA_UTILS2.ARPUR_Commit_Size := p_commit_size;
374: PA_UTILS2.ARPUR_MRC_Commit_Size := p_commit_size;
375:
376: SELECT count(*)
377: INTO COUNT_MRC_SET_OF_BOOKS

Line 374: PA_UTILS2.ARPUR_MRC_Commit_Size := p_commit_size;

370: -- Count MRC reporting set of books
371: -- and set ARPUR_MRC_COMMIT_SIZE.
372:
373: PA_UTILS2.ARPUR_Commit_Size := p_commit_size;
374: PA_UTILS2.ARPUR_MRC_Commit_Size := p_commit_size;
375:
376: SELECT count(*)
377: INTO COUNT_MRC_SET_OF_BOOKS
378: FROM pa_implementations pi, gl_alc_ledger_rships_v gal --gl_mc_reporting_options glm. Bug 4468366.

Line 382: PA_UTILS2.ARPUR_MRC_Commit_Size := PA_UTILS2.ARPUR_Commit_size/(1+COUNT_MRC_SET_OF_BOOKS);

378: FROM pa_implementations pi, gl_alc_ledger_rships_v gal --gl_mc_reporting_options glm. Bug 4468366.
379: WHERE (gal.org_id = -99 OR pi.org_id = gal.org_id) --pi.org_id = glm.org_id. Bug 4468366.
380: AND gal.relationship_enabled_flag = 'Y' --glm.enabled_flag = 'Y'. Bug 4468366.
381: AND gal.application_id = 275; --glm.application_Id = 275; Bug 4468366.
382: PA_UTILS2.ARPUR_MRC_Commit_Size := PA_UTILS2.ARPUR_Commit_size/(1+COUNT_MRC_SET_OF_BOOKS);
383: pa_debug.debug('Calculate ARPUR_Commit_Size and ARPUR_MRC_Commit_Size');
384:
385:
386: -- Set working status for the batch