DBA Data[Home] [Help]

APPS.PA_INTEGRATION dependencies on PA_PERIOD_PROCESS_PKG

Line 707: AND PERIOD.application_id = Pa_Period_Process_Pkg.Application_Id

703: SELECT PERIOD.period_name, PERIOD.start_date, PERIOD.end_date
704: INTO l_gl_period_name, l_gl_start_date, l_gl_end_date
705: FROM GL_PERIOD_STATUSES PERIOD
706: WHERE PERIOD.set_of_books_id = p_set_of_books_id
707: AND PERIOD.application_id = Pa_Period_Process_Pkg.Application_Id
708: AND PERIOD.adjustment_period_flag = 'N'
709: AND p_gl_date BETWEEN PERIOD.start_date AND PERIOD.end_date
710: ;
711:

Line 795: l_use_same_pa_gl_period_prvdr := NVL(PA_PERIOD_PROCESS_PKG.Use_Same_PA_GL_Period(p_prvdr_org_id), 'N');

791: * Populating setup related variables.
792: */
793: /* Changed from value_specific to value for bug 5472333 */
794: l_prof_new_gldate_derivation := NVL(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'), 'N') ;
795: l_use_same_pa_gl_period_prvdr := NVL(PA_PERIOD_PROCESS_PKG.Use_Same_PA_GL_Period(p_prvdr_org_id), 'N');
796: l_use_same_pa_gl_period_recvr := NVL(PA_PERIOD_PROCESS_PKG.Use_Same_PA_GL_Period(p_recvr_org_id), 'N');
797:
798: IF ( l_prof_new_gldate_derivation = 'Y' )
799: THEN

Line 796: l_use_same_pa_gl_period_recvr := NVL(PA_PERIOD_PROCESS_PKG.Use_Same_PA_GL_Period(p_recvr_org_id), 'N');

792: */
793: /* Changed from value_specific to value for bug 5472333 */
794: l_prof_new_gldate_derivation := NVL(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'), 'N') ;
795: l_use_same_pa_gl_period_prvdr := NVL(PA_PERIOD_PROCESS_PKG.Use_Same_PA_GL_Period(p_prvdr_org_id), 'N');
796: l_use_same_pa_gl_period_recvr := NVL(PA_PERIOD_PROCESS_PKG.Use_Same_PA_GL_Period(p_recvr_org_id), 'N');
797:
798: IF ( l_prof_new_gldate_derivation = 'Y' )
799: THEN
800: l_stage := 200;