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
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.
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