APPS.PA_UTILS2 dependencies on GL_PERIODS

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

1445: Populated during Distributing the cost */
1446:
1447: /****************** Bug 3668005 : GL Derivation Changes for M .************************
1448: Now in interface process the GL date will be derived for those CDLs
1449: whose GL dates fall in closed GL periods.
1450: (1)If these CDLs have not been summarized the CDLs would be updated.
1451: (2)If these CDLs have been summarized then the CDL would be reversed and a new line
1452: created with the rederived GL date while all other attribute would remain same
1453: including the PA Dates.

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

2559:
2560: IF ( l_prof_new_gldate_derivation ='Y' )
2561: THEN
2562: /*
2563: * Get Gl periods based on ei date.
2564: */
2565: IF (p_system_linkage_function = 'ER' AND p_expenditure_id = g_prev_expenditure_id
2566: AND g_prev_expenditure_id IS NOT NULL AND p_calling_module = 'CDL')
2567: THEN

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

2751: * Profile Option is NOT SET.
2752: */
2753: /*
2754: * Get Pa periods based on ei date.
2755: * Get Gl periods based on above derived Pa date.
2756: */
2757: IF (p_line_type <> 'R' AND p_system_linkage_function = 'VI')
2758: THEN
2759: -- this area has to be revisited.

Line 3120: FROM gl_periods glp

3116: ,glp.end_date
3117: INTO l_gl_period_name
3118: ,l_gl_period_start_date
3119: ,l_gl_period_end_date
3120: FROM gl_periods glp
3121: ,gl_sets_of_books glsob
3122: ,pa_implementations_all imp
3123: WHERE glsob.period_set_name = glp.period_set_name
3124: AND glp.period_type = glsob.accounted_period_type

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

3298:
3299: IF ( l_org_gl_period_name <> p_gl_period )
3300: THEN
3301: /* Bug#2476554
3302: * If PA Period derived above overlaps GL periods, PA date will be the end_date
3303: * of the last period in the earlier GL period. (In this case pa_date will
3304: * will usually end-up lesser than ei_date. This is OK.) The end_date will be
3305: * used for both EPP and non-EPP.
3306: */

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

3304: * will usually end-up lesser than ei_date. This is OK.) The end_date will be
3305: * used for both EPP and non-EPP.
3306: */
3307: IF ( l_debug_mode = 'Y' ) THEN
3308: pa_debug.g_err_stage := 'DEBUG: gl periods are different ' || l_org_gl_period_name || p_gl_period;
3309: pa_debug.write_file(pa_debug.g_err_stage);
3310: END IF;
3311:
3312: l_pa_overlaps_gl := 'Y';

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

3929: raise;
3930: END;
3931: ----------------------------------------------------------------------------------------------------------------
3932: -- API : get_accrual_period_information
3933: -- Description : This is main procedure to derive the accrual dates, gl dates, GL Periods, PA Dates
3934: -- and the Corresponding PA Periods.If any of them are null/not in a O/F period, then
3935: -- an appropriate error code is returned to the calling program.
3936: -- Parameters :
3937: -- IN :p_expenditure_item_date - EI Date of the Trx.