APPS.PQH_GL_POSTING dependencies on PQH_GL_POSTING

Line 1: PACKAGE BODY pqh_gl_posting AS

1: PACKAGE BODY pqh_gl_posting AS
2: /* $Header: pqglpost.pkb 120.8 2008/02/20 07:09:43 brsinha noship $ */
3:
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pqh_gl_posting'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_gl_posting'; -- Global package name
9: --
10: g_application_id NUMBER(15) := 101;
11: g_set_of_books_id gl_interface.set_of_books_id%TYPE;
12: g_budgetary_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE;

Line 793: l_budget_detail_result := pqh_gl_posting.chk_budget_details(p_budget_version_id => p_budget_version_id );

789:
790: -- This function will determine whether the budget has details or not
791: -- If the budget has details return 'Y' else 'N'
792:
793: l_budget_detail_result := pqh_gl_posting.chk_budget_details(p_budget_version_id => p_budget_version_id );
794: if l_budget_detail_result = 'N' then
795: FND_MESSAGE.SET_NAME('PQH','PQH_EMPTY_BUDGET');
796: l_message_text := FND_MESSAGE.GET;
797: populate_globals_error( p_message_text => l_message_text);

Line 938: SUM(pqh_gl_posting.get_amt1(bfs.budget_fund_src_id)) Amount1,

934: bfs.award_id,
935: bfs.task_id,
936: bfs.expenditure_type,
937: bfs.organization_id,
938: SUM(pqh_gl_posting.get_amt1(bfs.budget_fund_src_id)) Amount1,
939: SUM(pqh_gl_posting.get_amt2(bfs.budget_fund_src_id)) Amount2,
940: SUM(pqh_gl_posting.get_amt3(bfs.budget_fund_src_id)) Amount3
941: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
942: pqh_budget_sets bst, pqh_budget_periods bpr

Line 939: SUM(pqh_gl_posting.get_amt2(bfs.budget_fund_src_id)) Amount2,

935: bfs.task_id,
936: bfs.expenditure_type,
937: bfs.organization_id,
938: SUM(pqh_gl_posting.get_amt1(bfs.budget_fund_src_id)) Amount1,
939: SUM(pqh_gl_posting.get_amt2(bfs.budget_fund_src_id)) Amount2,
940: SUM(pqh_gl_posting.get_amt3(bfs.budget_fund_src_id)) Amount3
941: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
942: pqh_budget_sets bst, pqh_budget_periods bpr
943: WHERE bpr.budget_period_id = bst.budget_period_id

Line 940: SUM(pqh_gl_posting.get_amt3(bfs.budget_fund_src_id)) Amount3

936: bfs.expenditure_type,
937: bfs.organization_id,
938: SUM(pqh_gl_posting.get_amt1(bfs.budget_fund_src_id)) Amount1,
939: SUM(pqh_gl_posting.get_amt2(bfs.budget_fund_src_id)) Amount2,
940: SUM(pqh_gl_posting.get_amt3(bfs.budget_fund_src_id)) Amount3
941: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel,
942: pqh_budget_sets bst, pqh_budget_periods bpr
943: WHERE bpr.budget_period_id = bst.budget_period_id
944: AND bst.budget_set_id = bel.budget_set_id

Line 2012: IF pqh_gl_posting.chk_budget_details(p_budget_version_id => g_budget_version_id ) = 'Y' THEN

2008:
2009: IF NVL(l_count,0) = 0 THEN
2010: -- no errors
2011: -- mvankada
2012: IF pqh_gl_posting.chk_budget_details(p_budget_version_id => g_budget_version_id ) = 'Y' THEN
2013: UPDATE pqh_budget_versions
2014: SET gl_status = 'POST',
2015: transfered_to_gl_flag = 'Y'
2016: WHERE budget_version_id = g_budget_version_id;

Line 2035: IF pqh_gl_posting.chk_budget_details(p_budget_version_id => g_budget_version_id ) = 'Y' THEN

2031:
2032: hr_utility.set_location('Budget Details Error Count : '||l_count, 100);
2033:
2034: -- mvankada
2035: IF pqh_gl_posting.chk_budget_details(p_budget_version_id => g_budget_version_id ) = 'Y' THEN
2036: -- update the pqh_gl_interface table
2037: UPDATE pqh_gl_interface
2038: SET posting_date = sysdate,
2039: status = 'POST'

Line 6167: END pqh_gl_posting;

6163:
6164: end ins_gl_bc_run_fund_check;
6165:
6166:
6167: END pqh_gl_posting;