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.PQH_GL_POSTING dependencies on PER_TIME_PERIODS

Line 2375: FROM per_time_periods

2371:
2372:
2373: CURSOR csr_time_period IS
2374: SELECT start_date
2375: FROM per_time_periods
2376: WHERE time_period_id = ( SELECT start_time_period_id
2377: FROM pqh_budget_periods
2378: WHERE budget_period_id = p_budget_period_id );
2379:

Line 2676: Table : per_time_periods

2672: This procedure will set the log_context at bpr periods level
2673:
2674: Display the period start date for start_time_period_id and
2675: Display the period end date for end_time_period_id
2676: Table : per_time_periods
2677:
2678: */
2679:
2680: l_proc varchar2(72) := g_package||'set_bpr_log_context';

Line 2682: l_per_time_periods per_time_periods%ROWTYPE;

2678: */
2679:
2680: l_proc varchar2(72) := g_package||'set_bpr_log_context';
2681: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
2682: l_per_time_periods per_time_periods%ROWTYPE;
2683: l_start_date per_time_periods.start_date%TYPE;
2684: l_end_date per_time_periods.end_date%TYPE;
2685:
2686: CURSOR csr_bpr_periods_rec IS

Line 2683: l_start_date per_time_periods.start_date%TYPE;

2679:
2680: l_proc varchar2(72) := g_package||'set_bpr_log_context';
2681: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
2682: l_per_time_periods per_time_periods%ROWTYPE;
2683: l_start_date per_time_periods.start_date%TYPE;
2684: l_end_date per_time_periods.end_date%TYPE;
2685:
2686: CURSOR csr_bpr_periods_rec IS
2687: SELECT *

Line 2684: l_end_date per_time_periods.end_date%TYPE;

2680: l_proc varchar2(72) := g_package||'set_bpr_log_context';
2681: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
2682: l_per_time_periods per_time_periods%ROWTYPE;
2683: l_start_date per_time_periods.start_date%TYPE;
2684: l_end_date per_time_periods.end_date%TYPE;
2685:
2686: CURSOR csr_bpr_periods_rec IS
2687: SELECT *
2688: FROM pqh_budget_periods

Line 2691: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS

2687: SELECT *
2688: FROM pqh_budget_periods
2689: WHERE budget_period_id = p_budget_period_id ;
2690:
2691: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2692: SELECT *
2693: FROM per_time_periods
2694: WHERE time_period_id = p_time_period_id ;
2695:

Line 2693: FROM per_time_periods

2689: WHERE budget_period_id = p_budget_period_id ;
2690:
2691: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
2692: SELECT *
2693: FROM per_time_periods
2694: WHERE time_period_id = p_time_period_id ;
2695:
2696: BEGIN
2697:

Line 2705: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.start_time_period_id);

2701: FETCH csr_bpr_periods_rec INTO l_budget_periods_rec;
2702: CLOSE csr_bpr_periods_rec;
2703:
2704: -- get the start date
2705: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.start_time_period_id);
2706: FETCH csr_per_time_periods INTO l_per_time_periods;
2707: CLOSE csr_per_time_periods;
2708:
2709: l_start_date := l_per_time_periods.start_date;

Line 2706: FETCH csr_per_time_periods INTO l_per_time_periods;

2702: CLOSE csr_bpr_periods_rec;
2703:
2704: -- get the start date
2705: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.start_time_period_id);
2706: FETCH csr_per_time_periods INTO l_per_time_periods;
2707: CLOSE csr_per_time_periods;
2708:
2709: l_start_date := l_per_time_periods.start_date;
2710:

Line 2707: CLOSE csr_per_time_periods;

2703:
2704: -- get the start date
2705: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.start_time_period_id);
2706: FETCH csr_per_time_periods INTO l_per_time_periods;
2707: CLOSE csr_per_time_periods;
2708:
2709: l_start_date := l_per_time_periods.start_date;
2710:
2711:

Line 2709: l_start_date := l_per_time_periods.start_date;

2705: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.start_time_period_id);
2706: FETCH csr_per_time_periods INTO l_per_time_periods;
2707: CLOSE csr_per_time_periods;
2708:
2709: l_start_date := l_per_time_periods.start_date;
2710:
2711:
2712: -- get the end date
2713:

Line 2714: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.end_time_period_id);

2710:
2711:
2712: -- get the end date
2713:
2714: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.end_time_period_id);
2715: FETCH csr_per_time_periods INTO l_per_time_periods;
2716: CLOSE csr_per_time_periods;
2717:
2718: l_end_date := l_per_time_periods.end_date;

Line 2715: FETCH csr_per_time_periods INTO l_per_time_periods;

2711:
2712: -- get the end date
2713:
2714: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.end_time_period_id);
2715: FETCH csr_per_time_periods INTO l_per_time_periods;
2716: CLOSE csr_per_time_periods;
2717:
2718: l_end_date := l_per_time_periods.end_date;
2719:

Line 2716: CLOSE csr_per_time_periods;

2712: -- get the end date
2713:
2714: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.end_time_period_id);
2715: FETCH csr_per_time_periods INTO l_per_time_periods;
2716: CLOSE csr_per_time_periods;
2717:
2718: l_end_date := l_per_time_periods.end_date;
2719:
2720: -- set log context

Line 2718: l_end_date := l_per_time_periods.end_date;

2714: OPEN csr_per_time_periods ( p_time_period_id => l_budget_periods_rec.end_time_period_id);
2715: FETCH csr_per_time_periods INTO l_per_time_periods;
2716: CLOSE csr_per_time_periods;
2717:
2718: l_end_date := l_per_time_periods.end_date;
2719:
2720: -- set log context
2721:
2722: p_log_context := l_start_date||' - '||l_end_date;

Line 4567: per_time_periods

4563: Select
4564: start_date,
4565: end_date
4566: From
4567: per_time_periods
4568: Where
4569: time_period_id = p_time_period_id;
4570:
4571: Cursor csr_budget_units IS