APPS.PQH_BGT_BUS dependencies on GL_BUDGETS

Line 594: l_gl_budget_rec gl_budgets%ROWTYPE;

590: --
591: l_proc varchar2(72) := g_package||'chk_transfer_to_gl';
592: -- l_api_updating boolean;
593: l_dummy varchar2(30);
594: l_gl_budget_rec gl_budgets%ROWTYPE;
595: l_gl_bgt_start_date date;
596: l_gl_bgt_end_date date;
597: l_gl_budget_range varchar2(30);
598: l_budget_range varchar2(30);

Line 599: -- check if the budget is defined in gl_budgets and the budget

595: l_gl_bgt_start_date date;
596: l_gl_bgt_end_date date;
597: l_gl_budget_range varchar2(30);
598: l_budget_range varchar2(30);
599: -- check if the budget is defined in gl_budgets and the budget
600: -- has been opened i.e latest_opened_year IS NOT NULL
601:
602: CURSOR csr_gl_budgets_rec IS
603: SELECT *

Line 602: CURSOR csr_gl_budgets_rec IS

598: l_budget_range varchar2(30);
599: -- check if the budget is defined in gl_budgets and the budget
600: -- has been opened i.e latest_opened_year IS NOT NULL
601:
602: CURSOR csr_gl_budgets_rec IS
603: SELECT *
604: FROM gl_budgets
605: WHERE budget_name = p_gl_budget_name ;
606:

Line 604: FROM gl_budgets

600: -- has been opened i.e latest_opened_year IS NOT NULL
601:
602: CURSOR csr_gl_budgets_rec IS
603: SELECT *
604: FROM gl_budgets
605: WHERE budget_name = p_gl_budget_name ;
606:
607: CURSOR csr_gl_budget_dates IS
608: SELECT start_date,end_date

Line 609: FROM gl_budgets_v

605: WHERE budget_name = p_gl_budget_name ;
606:
607: CURSOR csr_gl_budget_dates IS
608: SELECT start_date,end_date
609: FROM gl_budgets_v
610: WHERE budget_name = p_gl_budget_name ;
611:
612: Cursor csr_set_of_books is
613: SELECT 'X'

Line 672: OPEN csr_gl_budgets_rec;

668: -- budget Not defined in GL
669: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');
670: hr_utility.raise_error;
671: END IF;
672: OPEN csr_gl_budgets_rec;
673: FETCH csr_gl_budgets_rec INTO l_gl_budget_rec;
674: CLOSE csr_gl_budgets_rec;
675: IF l_gl_budget_rec.budget_name IS NULL THEN
676: -- budget Not defined in GL

Line 673: FETCH csr_gl_budgets_rec INTO l_gl_budget_rec;

669: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');
670: hr_utility.raise_error;
671: END IF;
672: OPEN csr_gl_budgets_rec;
673: FETCH csr_gl_budgets_rec INTO l_gl_budget_rec;
674: CLOSE csr_gl_budgets_rec;
675: IF l_gl_budget_rec.budget_name IS NULL THEN
676: -- budget Not defined in GL
677: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');

Line 674: CLOSE csr_gl_budgets_rec;

670: hr_utility.raise_error;
671: END IF;
672: OPEN csr_gl_budgets_rec;
673: FETCH csr_gl_budgets_rec INTO l_gl_budget_rec;
674: CLOSE csr_gl_budgets_rec;
675: IF l_gl_budget_rec.budget_name IS NULL THEN
676: -- budget Not defined in GL
677: hr_utility.set_message(8302,'PQH_GL_BUDGET_INVALID');
678: hr_utility.raise_error;