APPS.PA_UTILS2 dependencies on GL_PERIODS

Line 1465: whose GL dates fall in closed GL periods.

1461: Populated during Distributing the cost */
1462:
1463: /****************** Bug 3668005 : GL Derivation Changes for M .************************
1464: Now in interface process the GL date will be derived for those CDLs
1465: whose GL dates fall in closed GL periods.
1466: (1)If these CDLs have not been summarized the CDLs would be updated.
1467: (2)If these CDLs have been summarized then the CDL would be reversed and a new line
1468: created with the rederived GL date while all other attribute would remain same
1469: including the PA Dates.

Line 2592: * Get Gl periods based on ei date.

2588:
2589: IF ( l_prof_new_gldate_derivation ='Y' )
2590: THEN
2591: /*
2592: * Get Gl periods based on ei date.
2593: */
2594: IF (p_system_linkage_function = 'ER' AND p_expenditure_id = g_prev_expenditure_id
2595: AND g_prev_expenditure_id IS NOT NULL AND p_calling_module = 'CDL')
2596: THEN

Line 2791: * Get Gl periods based on above derived Pa date.

2787: * Profile Option is NOT SET.
2788: */
2789: /*
2790: * Get Pa periods based on ei date.
2791: * Get Gl periods based on above derived Pa date.
2792: */
2793: IF (p_line_type <> 'R' AND p_system_linkage_function = 'VI')
2794: THEN
2795: -- this area has to be revisited.

Line 3158: FROM gl_periods glp

3154: ,glp.end_date
3155: INTO l_gl_period_name
3156: ,l_gl_period_start_date
3157: ,l_gl_period_end_date
3158: FROM gl_periods glp
3159: ,gl_sets_of_books glsob
3160: ,pa_implementations_all imp
3161: WHERE glsob.period_set_name = glp.period_set_name
3162: AND glp.period_type = glsob.accounted_period_type

Line 3340: * If PA Period derived above overlaps GL periods, PA date will be the end_date

3336:
3337: IF ( l_org_gl_period_name <> p_gl_period )
3338: THEN
3339: /* Bug#2476554
3340: * If PA Period derived above overlaps GL periods, PA date will be the end_date
3341: * of the last period in the earlier GL period. (In this case pa_date will
3342: * will usually end-up lesser than ei_date. This is OK.) The end_date will be
3343: * used for both EPP and non-EPP.
3344: */

Line 3346: pa_debug.g_err_stage := 'DEBUG: gl periods are different ' || l_org_gl_period_name || p_gl_period;

3342: * will usually end-up lesser than ei_date. This is OK.) The end_date will be
3343: * used for both EPP and non-EPP.
3344: */
3345: IF ( l_debug_mode = 'Y' ) THEN
3346: pa_debug.g_err_stage := 'DEBUG: gl periods are different ' || l_org_gl_period_name || p_gl_period;
3347: pa_debug.write_file(pa_debug.g_err_stage);
3348: END IF;
3349:
3350: l_pa_overlaps_gl := 'Y';

Line 3971: -- Description : This is main procedure to derive the accrual dates, gl dates, GL Periods, PA Dates

3967: raise;
3968: END;
3969: ----------------------------------------------------------------------------------------------------------------
3970: -- API : get_accrual_period_information
3971: -- Description : This is main procedure to derive the accrual dates, gl dates, GL Periods, PA Dates
3972: -- and the Corresponding PA Periods.If any of them are null/not in a O/F period, then
3973: -- an appropriate error code is returned to the calling program.
3974: -- Parameters :
3975: -- IN :p_expenditure_item_date - EI Date of the Trx.