eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_UTILS2 dependencies on PA_PERIODS

Line 570: FROM pa_periods_all pap1

566: ,pap1.period_name
567: INTO l_earliest_start_date
568: ,l_earliest_end_date
569: ,l_earliest_period_name
570: FROM pa_periods_all pap1
571: WHERE pap1.status in ('O','F')
572: AND pap1.org_id = p_org_id /* Bug#9048873 */
573: AND pap1.start_date = ( SELECT MIN (pap.start_date)
574: FROM pa_periods_all pap

Line 574: FROM pa_periods_all pap

570: FROM pa_periods_all pap1
571: WHERE pap1.status in ('O','F')
572: AND pap1.org_id = p_org_id /* Bug#9048873 */
573: AND pap1.start_date = ( SELECT MIN (pap.start_date)
574: FROM pa_periods_all pap
575: WHERE pap.status in ('O','F')
576: AND pap.org_id = p_org_id /* Bug#9048873 */
577: );
578: l_stage := 25;

Line 614: FROM pa_periods_all pap

610: INTO l_pa_date
611: ,l_start_date
612: ,l_end_date
613: ,l_period_name
614: FROM pa_periods_all pap
615: WHERE pap.status in ('O','F')
616: AND trunc(p_ei_date) between pap.start_date and pap.end_date
617: AND pap.org_id = p_org_id ; --removed nvl for the bug#6343739
618: EXCEPTION

Line 633: FROM pa_periods_all pap1

629: INTO l_pa_date
630: ,l_start_date
631: ,l_end_date
632: ,l_period_name
633: FROM pa_periods_all pap1
634: WHERE pap1.status in ('O','F')
635: AND nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
636: AND pap1.start_date = ( SELECT MIN (pap.start_date)
637: FROM pa_periods_all pap

Line 637: FROM pa_periods_all pap

633: FROM pa_periods_all pap1
634: WHERE pap1.status in ('O','F')
635: AND nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
636: AND pap1.start_date = ( SELECT MIN (pap.start_date)
637: FROM pa_periods_all pap
638: WHERE pap.status in ('O','F')
639: AND pap.org_id = p_org_id --removed nvl for the bug#6343739
640: AND trunc(p_ei_date) <= pap.start_date
641: );

Line 705: FROM pa_periods_all pap

701: INTO l_pa_date
702: ,l_start_date
703: ,l_end_date
704: ,l_period_name
705: FROM pa_periods_all pap
706: WHERE pap.status in ('O','F')
707: AND trunc(p_ei_date) between pap.start_date and pap.end_date
708: AND pap.org_id = p_org_id; /*removed nvl for bug 9284457 */
709: l_stage := 28;

Line 725: FROM pa_periods_all pap1

721: INTO l_pa_date
722: ,l_start_date
723: ,l_end_date
724: ,l_period_name
725: FROM pa_periods_all pap1
726: WHERE pap1.status in ('O','F')
727: AND pap1.org_id = p_org_id /* Bug#9048873 */
728: AND pap1.start_date = ( SELECT MIN (pap.start_date)
729: FROM pa_periods_all pap

Line 729: FROM pa_periods_all pap

725: FROM pa_periods_all pap1
726: WHERE pap1.status in ('O','F')
727: AND pap1.org_id = p_org_id /* Bug#9048873 */
728: AND pap1.start_date = ( SELECT MIN (pap.start_date)
729: FROM pa_periods_all pap
730: WHERE pap.status in ('O','F')
731: AND pap.org_id = p_org_id /* Bug#9048873 */
732: AND trunc(p_ei_date) <= pap.start_date
733: );

Line 2679: * Deriving PA periods for Provider.

2675: l_recvr_gl_period_name := g_recvr_gl_period_name;
2676: END IF;
2677: END IF; -- expense report check
2678: /*
2679: * Deriving PA periods for Provider.
2680: */
2681: IF ( l_use_same_pa_gl_period_prvdr = 'Y' AND
2682: ( p_calling_module <> 'AR_INSTALLED_INVOICE' OR p_calling_module <> 'AR_NOT_INSTALLED_INVOICE')
2683: )

Line 2692: * Copy Provider Gl period information to Provider Pa periods.

2688: pa_debug.g_err_stage := TO_CHAR(l_stage) || ': Copying Provider GL info to Provider PA';
2689: pa_debug.write_file(pa_debug.g_err_stage);
2690: END IF; -- debug
2691: /*
2692: * Copy Provider Gl period information to Provider Pa periods.
2693: */
2694: /*l_prvdr_pa_date := l_prvdr_gl_date;
2695: l_prvdr_pa_period_name := l_prvdr_gl_period_name;*/
2696: /*Commented the above code and added the below code for bug 7638790*/

Line 2705: * Get Provider Pa periods based on ei date.

2701: l_prvdr_pa_period_name := g_prvdr_gl_period_name;
2702:
2703: ELSE
2704: /*
2705: * Get Provider Pa periods based on ei date.
2706: */
2707: l_stage := 500;
2708: IF ( l_debug_mode = 'Y' )
2709: THEN

Line 2735: * Deriving PA periods for Receiver.

2731: END IF;
2732: END IF; -- burden VI cdl check.
2733: END IF; -- implementations option
2734: /*
2735: * Deriving PA periods for Receiver.
2736: * Receiver information need not be derived if calling module is CCDL.
2737: */
2738: IF ( p_calling_module <> 'CCDL' )
2739: THEN

Line 2743: * Copy Receiver Gl period information to Receiver Pa periods.

2739: THEN
2740: IF ( l_use_same_pa_gl_period_recvr = 'Y' AND p_calling_module <> 'AR_INSTALLED_INVOICE' )
2741: THEN
2742: /*
2743: * Copy Receiver Gl period information to Receiver Pa periods.
2744: */
2745: l_stage := 600;
2746: IF ( l_debug_mode = 'Y' )
2747: THEN

Line 2755: * Get Receiver Pa periods based on ei date.

2751: l_recvr_pa_date := l_recvr_gl_date;
2752: l_recvr_pa_period_name := l_recvr_gl_period_name;
2753: ELSE
2754: /*
2755: * Get Receiver Pa periods based on ei date.
2756: */
2757: l_stage := 700;
2758: IF ( l_debug_mode = 'Y' )
2759: THEN

Line 2790: * Get Pa periods based on ei date.

2786: /*
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

Line 3205: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)

3201: ---------------------------------------------------------------
3202: /*
3203: * This function returns the end_date of the PA period in which the input date falls.
3204: */
3205: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3206: RETURN pa_periods_all.end_date%TYPE
3207: IS
3208: l_end_date pa_periods_all.end_date%TYPE ;
3209: BEGIN

Line 3206: RETURN pa_periods_all.end_date%TYPE

3202: /*
3203: * This function returns the end_date of the PA period in which the input date falls.
3204: */
3205: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3206: RETURN pa_periods_all.end_date%TYPE
3207: IS
3208: l_end_date pa_periods_all.end_date%TYPE ;
3209: BEGIN
3210:

Line 3208: l_end_date pa_periods_all.end_date%TYPE ;

3204: */
3205: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3206: RETURN pa_periods_all.end_date%TYPE
3207: IS
3208: l_end_date pa_periods_all.end_date%TYPE ;
3209: BEGIN
3210:
3211: SELECT pap.end_date
3212: INTO l_end_date

Line 3213: FROM pa_periods pap

3209: BEGIN
3210:
3211: SELECT pap.end_date
3212: INTO l_end_date
3213: FROM pa_periods pap
3214: WHERE trunc(p_date) between pap.start_date AND pap.end_date ;
3215:
3216: RETURN l_end_date ;
3217: EXCEPTION

Line 3333: FROM pa_periods_all papl

3329: -- Either the Cache is empty / date is not in the range
3330: BEGIN
3331: SELECT papl.end_date,papl.start_date,papl.period_name,papl.gl_period_name
3332: INTO l_org_pa_end_date,l_org_pa_start_date,l_org_pa_period_name,l_org_gl_period_name
3333: FROM pa_periods_all papl
3334: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3335: AND trunc(p_ei_date) between papl.start_date and papl.end_date;
3336:
3337: IF ( l_org_gl_period_name <> p_gl_period )

Line 3353: FROM pa_periods_all papl

3349:
3350: l_pa_overlaps_gl := 'Y';
3351: SELECT papl.end_date,papl.start_date,papl.period_name
3352: INTO l_org_pa_end_date,l_org_pa_start_date,l_org_pa_period_name
3353: FROM pa_periods_all papl
3354: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3355: AND papl.gl_period_name=p_gl_period
3356: AND papl.start_date= ( SELECT MAX(papl1.start_date)
3357: FROM pa_periods_all papl1

Line 3357: FROM pa_periods_all papl1

3353: FROM pa_periods_all papl
3354: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3355: AND papl.gl_period_name=p_gl_period
3356: AND papl.start_date= ( SELECT MAX(papl1.start_date)
3357: FROM pa_periods_all papl1
3358: WHERE nvl(papl1.org_id, -99 ) = nvl( p_org_id, -99 )
3359: AND papl1.gl_period_name=p_gl_period
3360: );
3361: END IF;

Line 3463: FROM pa_periods_all papl

3459: ----Rev EI GL date is used to get the pa date. EPP flag is checked in the select itself.
3460: BEGIN
3461: SELECT min(decode(p_epp_flag,'Y',papl.start_date,papl.end_date))
3462: INTO l_rev_pa_date
3463: FROM pa_periods_all papl
3464: WHERE nvl(papl.org_id, -99 ) = nvl(p_org_id, -99 )
3465: AND papl.gl_period_name = p_gl_period ;
3466: END;
3467: IF ( l_debug_mode = 'Y' ) THEN

Line 3478: FROM pa_periods_all papl

3474: -- Get the Period Name
3475: BEGIN
3476: SELECT period_name
3477: INTO l_rev_pa_period_name
3478: FROM pa_periods_all papl
3479: WHERE nvl(papl.org_id, -99 ) = nvl(p_org_id, -99 )
3480: AND trunc(l_rev_pa_date) between papl.start_date and papl.end_date;
3481: EXCEPTION
3482: WHEN NO_DATA_FOUND THEN

Line 3972: -- and the Corresponding PA Periods.If any of them are null/not in a O/F period, then

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.
3976: -- p_reference_date - Accrual Date/GL Date of the Trx.

Line 4579: -- Deriving PA periods

4575: x_recvr_gl_date := l_recvr_gl_date ;
4576: x_prvdr_gl_period_name := l_prvdr_gl_period_name;
4577: x_recvr_gl_period_name := l_recvr_gl_period_name;
4578:
4579: -- Deriving PA periods
4580:
4581: pa_debug.g_err_stage := 'Deriving the PA Dates';
4582: IF(l_debug_mode = 'Y') THEN
4583: pa_debug.write_file(pa_debug.g_err_stage);

Line 4776: RETURN pa_periods.period_name%TYPE

4772: -----------------------------------------------------------------------
4773: FUNCTION get_pa_period_name( p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4774: ,p_org_id IN pa_implementations_all.org_id%TYPE
4775: )
4776: RETURN pa_periods.period_name%TYPE
4777: IS
4778: l_pa_period_name pa_periods.period_name%TYPE;
4779: l_pa_date date;
4780: BEGIN

Line 4778: l_pa_period_name pa_periods.period_name%TYPE;

4774: ,p_org_id IN pa_implementations_all.org_id%TYPE
4775: )
4776: RETURN pa_periods.period_name%TYPE
4777: IS
4778: l_pa_period_name pa_periods.period_name%TYPE;
4779: l_pa_date date;
4780: BEGIN
4781:
4782: IF ( p_txn_date IS NOT NULL )