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 nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
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 nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
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 nvl( pap.org_id, -99 ) = nvl( p_org_id, -99 )
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 NVL(pap.org_id, -99) = NVL(p_org_id, -99) ;
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 nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
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 nvl( pap1.org_id, -99 ) = nvl( p_org_id, -99 )
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 nvl( pap.org_id, -99 ) = nvl( p_org_id, -99 )
732: AND trunc(p_ei_date) <= pap.start_date
733: );

Line 2650: * Deriving PA periods for Provider.

2646: l_recvr_gl_period_name := g_recvr_gl_period_name;
2647: END IF;
2648: END IF; -- expense report check
2649: /*
2650: * Deriving PA periods for Provider.
2651: */
2652: IF ( l_use_same_pa_gl_period_prvdr = 'Y' AND
2653: ( p_calling_module <> 'AR_INSTALLED_INVOICE' OR p_calling_module <> 'AR_NOT_INSTALLED_INVOICE')
2654: )

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

2659: pa_debug.g_err_stage := TO_CHAR(l_stage) || ': Copying Provider GL info to Provider PA';
2660: pa_debug.write_file(pa_debug.g_err_stage);
2661: END IF; -- debug
2662: /*
2663: * Copy Provider Gl period information to Provider Pa periods.
2664: */
2665: l_prvdr_pa_date := l_prvdr_gl_date;
2666: l_prvdr_pa_period_name := l_prvdr_gl_period_name;
2667: ELSE

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

2665: l_prvdr_pa_date := l_prvdr_gl_date;
2666: l_prvdr_pa_period_name := l_prvdr_gl_period_name;
2667: ELSE
2668: /*
2669: * Get Provider Pa periods based on ei date.
2670: */
2671: l_stage := 500;
2672: IF ( l_debug_mode = 'Y' )
2673: THEN

Line 2699: * Deriving PA periods for Receiver.

2695: END IF;
2696: END IF; -- burden VI cdl check.
2697: END IF; -- implementations option
2698: /*
2699: * Deriving PA periods for Receiver.
2700: * Receiver information need not be derived if calling module is CCDL.
2701: */
2702: IF ( p_calling_module <> 'CCDL' )
2703: THEN

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

2703: THEN
2704: IF ( l_use_same_pa_gl_period_recvr = 'Y' AND p_calling_module <> 'AR_INSTALLED_INVOICE' )
2705: THEN
2706: /*
2707: * Copy Receiver Gl period information to Receiver Pa periods.
2708: */
2709: l_stage := 600;
2710: IF ( l_debug_mode = 'Y' )
2711: THEN

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

2715: l_recvr_pa_date := l_recvr_gl_date;
2716: l_recvr_pa_period_name := l_recvr_gl_period_name;
2717: ELSE
2718: /*
2719: * Get Receiver Pa periods based on ei date.
2720: */
2721: l_stage := 700;
2722: IF ( l_debug_mode = 'Y' )
2723: THEN

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

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

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

3163: ---------------------------------------------------------------
3164: /*
3165: * This function returns the end_date of the PA period in which the input date falls.
3166: */
3167: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3168: RETURN pa_periods_all.end_date%TYPE
3169: IS
3170: l_end_date pa_periods_all.end_date%TYPE ;
3171: BEGIN

Line 3168: RETURN pa_periods_all.end_date%TYPE

3164: /*
3165: * This function returns the end_date of the PA period in which the input date falls.
3166: */
3167: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3168: RETURN pa_periods_all.end_date%TYPE
3169: IS
3170: l_end_date pa_periods_all.end_date%TYPE ;
3171: BEGIN
3172:

Line 3170: l_end_date pa_periods_all.end_date%TYPE ;

3166: */
3167: FUNCTION get_pa_period_end_date_OU ( p_date IN pa_periods_all.end_date%TYPE)
3168: RETURN pa_periods_all.end_date%TYPE
3169: IS
3170: l_end_date pa_periods_all.end_date%TYPE ;
3171: BEGIN
3172:
3173: SELECT pap.end_date
3174: INTO l_end_date

Line 3175: FROM pa_periods pap

3171: BEGIN
3172:
3173: SELECT pap.end_date
3174: INTO l_end_date
3175: FROM pa_periods pap
3176: WHERE trunc(p_date) between pap.start_date AND pap.end_date ;
3177:
3178: RETURN l_end_date ;
3179: EXCEPTION

Line 3295: FROM pa_periods_all papl

3291: -- Either the Cache is empty / date is not in the range
3292: BEGIN
3293: SELECT papl.end_date,papl.start_date,papl.period_name,papl.gl_period_name
3294: INTO l_org_pa_end_date,l_org_pa_start_date,l_org_pa_period_name,l_org_gl_period_name
3295: FROM pa_periods_all papl
3296: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3297: AND trunc(p_ei_date) between papl.start_date and papl.end_date;
3298:
3299: IF ( l_org_gl_period_name <> p_gl_period )

Line 3315: FROM pa_periods_all papl

3311:
3312: l_pa_overlaps_gl := 'Y';
3313: SELECT papl.end_date,papl.start_date,papl.period_name
3314: INTO l_org_pa_end_date,l_org_pa_start_date,l_org_pa_period_name
3315: FROM pa_periods_all papl
3316: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3317: AND papl.gl_period_name=p_gl_period
3318: AND papl.start_date= ( SELECT MAX(papl1.start_date)
3319: FROM pa_periods_all papl1

Line 3319: FROM pa_periods_all papl1

3315: FROM pa_periods_all papl
3316: WHERE nvl(papl.org_id, -99 ) = nvl( p_org_id, -99 )
3317: AND papl.gl_period_name=p_gl_period
3318: AND papl.start_date= ( SELECT MAX(papl1.start_date)
3319: FROM pa_periods_all papl1
3320: WHERE nvl(papl1.org_id, -99 ) = nvl( p_org_id, -99 )
3321: AND papl1.gl_period_name=p_gl_period
3322: );
3323: END IF;

Line 3425: FROM pa_periods_all papl

3421: ----Rev EI GL date is used to get the pa date. EPP flag is checked in the select itself.
3422: BEGIN
3423: SELECT min(decode(p_epp_flag,'Y',papl.start_date,papl.end_date))
3424: INTO l_rev_pa_date
3425: FROM pa_periods_all papl
3426: WHERE nvl(papl.org_id, -99 ) = nvl(p_org_id, -99 )
3427: AND papl.gl_period_name = p_gl_period ;
3428: END;
3429: IF ( l_debug_mode = 'Y' ) THEN

Line 3440: FROM pa_periods_all papl

3436: -- Get the Period Name
3437: BEGIN
3438: SELECT period_name
3439: INTO l_rev_pa_period_name
3440: FROM pa_periods_all papl
3441: WHERE nvl(papl.org_id, -99 ) = nvl(p_org_id, -99 )
3442: AND trunc(l_rev_pa_date) between papl.start_date and papl.end_date;
3443: EXCEPTION
3444: WHEN NO_DATA_FOUND THEN

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

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

Line 4541: -- Deriving PA periods

4537: x_recvr_gl_date := l_recvr_gl_date ;
4538: x_prvdr_gl_period_name := l_prvdr_gl_period_name;
4539: x_recvr_gl_period_name := l_recvr_gl_period_name;
4540:
4541: -- Deriving PA periods
4542:
4543: pa_debug.g_err_stage := 'Deriving the PA Dates';
4544: IF(l_debug_mode = 'Y') THEN
4545: pa_debug.write_file(pa_debug.g_err_stage);

Line 4738: RETURN pa_periods.period_name%TYPE

4734: -----------------------------------------------------------------------
4735: FUNCTION get_pa_period_name( p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
4736: ,p_org_id IN pa_implementations_all.org_id%TYPE
4737: )
4738: RETURN pa_periods.period_name%TYPE
4739: IS
4740: l_pa_period_name pa_periods.period_name%TYPE;
4741: l_pa_date date;
4742: BEGIN

Line 4740: l_pa_period_name pa_periods.period_name%TYPE;

4736: ,p_org_id IN pa_implementations_all.org_id%TYPE
4737: )
4738: RETURN pa_periods.period_name%TYPE
4739: IS
4740: l_pa_period_name pa_periods.period_name%TYPE;
4741: l_pa_date date;
4742: BEGIN
4743:
4744: IF ( p_txn_date IS NOT NULL )