DBA Data[Home] [Help]

APPS.PA_INTEGRATION dependencies on PA_PERIOD_PROCESS_PKG

Line 709: AND PERIOD.application_id = Pa_Period_Process_Pkg.Application_Id

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

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

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

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

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