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_FP_SPREAD_AMTS_PKG dependencies on GL_PERIODS

Line 92: period_name gl_periods.period_name%TYPE, --VARCHAR2,

88:
89: TYPE spread_record_type IS RECORD
90: (start_date DATE,
91: end_date DATE,
92: period_name gl_periods.period_name%TYPE, --VARCHAR2,
93: actual_days INTEGER,
94: actual_periods NUMBER,
95: allocation NUMBER,
96: percentage NUMBER,

Line 2811: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=2)

2807: EXPLAIN PLAN IS:
2808: ================
2809: 1:SELECT STATEMENT :(cost=8,rows=2)
2810: 2:SORT ORDER BY :(cost=8,rows=2)
2811: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=2)
2812: 4:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=2)
2813: **/
2814: CURSOR get_gl_periods_csr IS
2815: SELECT START_DATE, END_DATE, PERIOD_NAME

Line 2812: 4:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=2)

2808: ================
2809: 1:SELECT STATEMENT :(cost=8,rows=2)
2810: 2:SORT ORDER BY :(cost=8,rows=2)
2811: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=2)
2812: 4:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=2)
2813: **/
2814: CURSOR get_gl_periods_csr IS
2815: SELECT START_DATE, END_DATE, PERIOD_NAME
2816: FROM gl_periods gp

Line 2814: CURSOR get_gl_periods_csr IS

2810: 2:SORT ORDER BY :(cost=8,rows=2)
2811: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=2)
2812: 4:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=2)
2813: **/
2814: CURSOR get_gl_periods_csr IS
2815: SELECT START_DATE, END_DATE, PERIOD_NAME
2816: FROM gl_periods gp
2817: WHERE gp.period_set_name = l_period_set_name
2818: AND gp.period_type = decode(l_time_phase_code,'G',l_accounted_period_type,'P',l_pa_period_type)

Line 2816: FROM gl_periods gp

2812: 4:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=2)
2813: **/
2814: CURSOR get_gl_periods_csr IS
2815: SELECT START_DATE, END_DATE, PERIOD_NAME
2816: FROM gl_periods gp
2817: WHERE gp.period_set_name = l_period_set_name
2818: AND gp.period_type = decode(l_time_phase_code,'G',l_accounted_period_type,'P',l_pa_period_type)
2819: AND gp.adjustment_period_flag = 'N'
2820: AND gp.start_date <= l_end_date -- plan end date

Line 2830: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=8,rows=1)

2826: EXPLAIN PLAN IS:
2827: ================
2828: 1:SELECT STATEMENT :(cost=8,rows=1)
2829: 2:FILTER :(cost=,rows=)
2830: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=8,rows=1)
2831: 4:INDEX RANGE SCAN GL_PERIODS_N1 :(cost=2,rows=1)
2832: 5:SORT AGGREGATE :(cost=,rows=1)
2833: 6:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=4)
2834: 7:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=4)

Line 2831: 4:INDEX RANGE SCAN GL_PERIODS_N1 :(cost=2,rows=1)

2827: ================
2828: 1:SELECT STATEMENT :(cost=8,rows=1)
2829: 2:FILTER :(cost=,rows=)
2830: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=8,rows=1)
2831: 4:INDEX RANGE SCAN GL_PERIODS_N1 :(cost=2,rows=1)
2832: 5:SORT AGGREGATE :(cost=,rows=1)
2833: 6:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=4)
2834: 7:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=4)
2835: 3:SORT AGGREGATE :(cost=,rows=1)

Line 2833: 6:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=4)

2829: 2:FILTER :(cost=,rows=)
2830: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=8,rows=1)
2831: 4:INDEX RANGE SCAN GL_PERIODS_N1 :(cost=2,rows=1)
2832: 5:SORT AGGREGATE :(cost=,rows=1)
2833: 6:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=4)
2834: 7:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=4)
2835: 3:SORT AGGREGATE :(cost=,rows=1)
2836: 4:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=5)
2837: 5:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=5)

Line 2834: 7:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=4)

2830: 3:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=8,rows=1)
2831: 4:INDEX RANGE SCAN GL_PERIODS_N1 :(cost=2,rows=1)
2832: 5:SORT AGGREGATE :(cost=,rows=1)
2833: 6:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=4)
2834: 7:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=4)
2835: 3:SORT AGGREGATE :(cost=,rows=1)
2836: 4:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=5)
2837: 5:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=5)
2838: CURSOR get_gl_periods_csr IS

Line 2836: 4:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=5)

2832: 5:SORT AGGREGATE :(cost=,rows=1)
2833: 6:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=4)
2834: 7:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=4)
2835: 3:SORT AGGREGATE :(cost=,rows=1)
2836: 4:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=5)
2837: 5:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=5)
2838: CURSOR get_gl_periods_csr IS
2839: SELECT START_DATE, END_DATE, PERIOD_NAME
2840: FROM gl_periods gp

Line 2837: 5:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=5)

2833: 6:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=4)
2834: 7:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=4)
2835: 3:SORT AGGREGATE :(cost=,rows=1)
2836: 4:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=5)
2837: 5:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=5)
2838: CURSOR get_gl_periods_csr IS
2839: SELECT START_DATE, END_DATE, PERIOD_NAME
2840: FROM gl_periods gp
2841: WHERE gp.period_set_name = l_period_set_name

Line 2838: CURSOR get_gl_periods_csr IS

2834: 7:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=4)
2835: 3:SORT AGGREGATE :(cost=,rows=1)
2836: 4:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=5)
2837: 5:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=5)
2838: CURSOR get_gl_periods_csr IS
2839: SELECT START_DATE, END_DATE, PERIOD_NAME
2840: FROM gl_periods gp
2841: WHERE gp.period_set_name = l_period_set_name
2842: AND gp.period_type = decode(l_time_phase_code,'G',l_accounted_period_type,'P',l_pa_period_type)

Line 2840: FROM gl_periods gp

2836: 4:TABLE ACCESS BY INDEX ROWID GL_PERIODS :(cost=4,rows=5)
2837: 5:INDEX RANGE SCAN GL_PERIODS_U2 :(cost=2,rows=5)
2838: CURSOR get_gl_periods_csr IS
2839: SELECT START_DATE, END_DATE, PERIOD_NAME
2840: FROM gl_periods gp
2841: WHERE gp.period_set_name = l_period_set_name
2842: AND gp.period_type = decode(l_time_phase_code,'G',l_accounted_period_type,'P',l_pa_period_type)
2843: AND gp.start_date >=
2844: (SELECT MIN(start_date)

Line 2845: FROM gl_periods

2841: WHERE gp.period_set_name = l_period_set_name
2842: AND gp.period_type = decode(l_time_phase_code,'G',l_accounted_period_type,'P',l_pa_period_type)
2843: AND gp.start_date >=
2844: (SELECT MIN(start_date)
2845: FROM gl_periods
2846: WHERE end_date >= l_start_date
2847: AND period_set_name = l_period_set_name
2848: AND period_type =
2849: decode(l_time_phase_code,'G',

Line 2855: FROM gl_periods

2851: 'P',l_pa_period_type)
2852: AND adjustment_period_flag = 'N')
2853: AND gp.end_date <=
2854: (SELECT MAX(end_date)
2855: FROM gl_periods
2856: WHERE start_date <= l_end_date
2857: AND period_set_name = l_period_set_name
2858: AND period_type =
2859: decode(l_time_phase_code,'G',

Line 2913: -- Get periods from gl_periods

2909: print_msg(' '||'time_phase_code => '||l_time_phase_code);
2910: End If;
2911:
2912:
2913: -- Get periods from gl_periods
2914:
2915: l_start_date := p_start_date;
2916: l_end_date := p_end_date;
2917: x_spread_amounts := spread_table_type();

Line 2919: FOR rec IN get_gl_periods_csr

2915: l_start_date := p_start_date;
2916: l_end_date := p_end_date;
2917: x_spread_amounts := spread_table_type();
2918: n := 0;
2919: FOR rec IN get_gl_periods_csr
2920: LOOP
2921: --print_msg('inside get_gl_periods_csr for SD['||rec.start_date||']');
2922: n := n + 1;
2923: x_spread_amounts.EXTEND();

Line 2921: --print_msg('inside get_gl_periods_csr for SD['||rec.start_date||']');

2917: x_spread_amounts := spread_table_type();
2918: n := 0;
2919: FOR rec IN get_gl_periods_csr
2920: LOOP
2921: --print_msg('inside get_gl_periods_csr for SD['||rec.start_date||']');
2922: n := n + 1;
2923: x_spread_amounts.EXTEND();
2924: tmp_rec.start_date := rec.start_date;
2925: tmp_rec.end_date := rec.end_date;