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 PQH_BUDGET_VERSIONS

Line 20: g_version_number pqh_budget_versions.version_number%TYPE;

16: g_user_je_source_name gl_interface.user_je_source_name%TYPE;
17: g_user_je_category_name gl_interface.user_je_category_name%TYPE;
18: g_budget_version_id gl_interface.budget_version_id%TYPE;
19: g_gl_budget_version_id gl_interface.budget_version_id%TYPE;
20: g_version_number pqh_budget_versions.version_number%TYPE;
21: g_chart_of_accounts_id gl_interface.chart_of_accounts_id%TYPE;
22: g_currency_code gl_interface.currency_code%TYPE;
23: g_detail_error VARCHAR2(10);
24: g_currency_code1 gl_interface.currency_code%TYPE;

Line 117: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

113: PROCEDURE conc_post_budget
114: (
115: errbuf OUT NOCOPY VARCHAR2,
116: retcode OUT NOCOPY VARCHAR2,
117: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
118: p_validate IN varchar2 default 'N'
119: ) IS
120: /*
121: This procedure will call the post_budget procedure . This procedure is written as this

Line 159: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

155: -- ----------------------------------------------------------------------------
156:
157: PROCEDURE post_budget
158: (
159: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
160: p_validate IN boolean default false,
161: p_status OUT NOCOPY varchar2
162: ) IS
163: /*

Line 313: update gl_status of pqh_budget_versions and pqh_budget_details

309: end if;
310: END IF;
311:
312: /*
313: update gl_status of pqh_budget_versions and pqh_budget_details
314: update posting_date and status of pqh_gl_interface
315: update the global g_status with the program status
316: */
317:

Line 358: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE

354:
355: -- ----------------------------------------------------------------------------
356: PROCEDURE populate_globals
357: (
358: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE
359: ) IS
360: /*
361: This procedure will populate all the global variables and start the log context
362: If there is any error in populate globals we will end log and terminate the program

Line 369: l_budget_versions_rec pqh_budget_versions%ROWTYPE;

365: -- local variables
366: --
367: l_proc varchar2(72) := g_package||'.populate_globals';
368: l_budgets_rec pqh_budgets%ROWTYPE;
369: l_budget_versions_rec pqh_budget_versions%ROWTYPE;
370: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;
371: l_shared_types_rec per_shared_types%ROWTYPE;
372: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;
373: l_gl_je_sources_rec gl_je_sources%ROWTYPE;

Line 389: FROM pqh_budget_versions

385: l_gl_budget_name pqh_budgets.GL_BUDGET_NAME%TYPE;
386:
387: CURSOR csr_budget_versions_rec IS
388: SELECT *
389: FROM pqh_budget_versions
390: WHERE budget_version_id = p_budget_version_id;
391:
392: CURSOR csr_budgets_rec (c_budget_id IN NUMBER) IS
393: SELECT *

Line 398: FROM pqh_budget_versions

394: FROM pqh_budgets
395: WHERE budget_id = c_budget_id;
396: /* ns budget_id is already available, no need to fetch again
397: ( SELECT budget_id
398: FROM pqh_budget_versions
399: WHERE budget_version_id = p_budget_version_id ) ;
400: */
401:
402: CURSOR csr_bus_grp (p_business_group_id IN NUMBER) IS

Line 816: -- get the table route id for pqh_budget versions

812: end if;
813: End Loop;
814:
815: /* ns fetched it in one cursor instead.
816: -- get the table route id for pqh_budget versions
817: OPEN csr_table_route(p_table_alias => 'BVR');
818: FETCH csr_table_route INTO g_table_route_id_bvr;
819: CLOSE csr_table_route;
820:

Line 1962: This procedure will update the gl_status of pqh_budget_versions, pqh_budget_details

1958: -- ----------------------------------------------------------------------------
1959: PROCEDURE update_gl_status
1960: IS
1961: /*
1962: This procedure will update the gl_status of pqh_budget_versions, pqh_budget_details
1963: and update the pqh_gl_interface table
1964:
1965: We always update the TRANSFERED_TO_GL_FLAG = Y to indicate this is the latest budget_version that is posted to GL
1966: gl_status = POST or ERROR

Line 2004: -- update pqh_budget_versions and the program out variable

2000: WHERE CURRENT OF csr_budget_details;
2001: END LOOP;
2002: CLOSE csr_budget_details;
2003:
2004: -- update pqh_budget_versions and the program out variable
2005: OPEN csr_budget_details_cnt;
2006: FETCH csr_budget_details_cnt INTO l_count;
2007: CLOSE csr_budget_details_cnt;
2008:

Line 2013: UPDATE pqh_budget_versions

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;
2017:

Line 2023: UPDATE pqh_budget_versions

2019: g_status := 'SUCCESS';
2020: END IF;
2021: ELSE
2022: -- there were errors in details
2023: UPDATE pqh_budget_versions
2024: SET gl_status = 'ERROR',
2025: transfered_to_gl_flag = 'Y'
2026: WHERE budget_version_id = g_budget_version_id;
2027:

Line 3542: pqh_budget_versions bvr

3538: CURSOR csr_curr_code IS
3539: SELECT bg.ORG_INFORMATION10
3540: FROM HR_ORGANIZATION_INFORMATION bg,
3541: pqh_budgets bgt,
3542: pqh_budget_versions bvr
3543: WHERE bgt.budget_id = bvr.budget_id
3544: AND bvr.budget_version_id = g_budget_version_id
3545: AND bgt.business_group_id = bg.organization_id
3546: AND bg.ORG_INFORMATION_CONTEXT = 'Business Group Information';

Line 3551: pqh_budget_versions bvr

3547:
3548: CURSOR csr_bgt_curr IS
3549: SELECT bgt.currency_code
3550: FROM pqh_budgets bgt,
3551: pqh_budget_versions bvr
3552: WHERE bgt.budget_id = bvr.budget_id
3553: AND bvr.budget_version_id = g_budget_version_id;
3554:
3555:

Line 4023: The column TRANSFERED_TO_GL_FLAG in pqh_budget_versions will indicate the last posted version.

4019: PROCEDURE reverse_prev_posted_version
4020: IS
4021: /*
4022: Added on 10/10/2000 -- At any point of time , only ONE budget version can be posted to GL.
4023: The column TRANSFERED_TO_GL_FLAG in pqh_budget_versions will indicate the last posted version.
4024: For a given budget, only one budget_version will have TRANSFERED_TO_GL_FLAG = 'Y' , which is the last
4025: posted version.
4026: We check if the current budget_version_id has TRANSFERED_TO_GL_FLAG = 'Y' ,
4027: If Yes => this is the last posted version and the user is doing adjustments on the version.

Line 4058: FROM pqh_budget_versions

4054: l_pqh_gl_interface_rec pqh_gl_interface%ROWTYPE;
4055:
4056: CURSOR csr_last_posted_ver IS
4057: SELECT budget_version_id
4058: FROM pqh_budget_versions
4059: WHERE budget_id = g_budget_id
4060: AND NVL(transfered_to_gl_flag,'N') = 'Y';
4061:
4062: CURSOR csr_unpost_version (p_budget_version_id IN number )IS

Line 4149: UPDATE pqh_budget_versions

4145: END LOOP;
4146: CLOSE csr_unpost_version;
4147:
4148: -- update the last posted version, gl_status to UNPOST and TRANSFERED_TO_GL_FLAG to N
4149: UPDATE pqh_budget_versions
4150: SET transfered_to_gl_flag = 'N' ,
4151: gl_status = 'UNPOST'
4152: WHERE budget_version_id = g_last_posted_ver;
4153:

Line 4345: UPDATE pqh_budget_versions

4341: CLOSE csr_unpost_version;
4342: --
4343: -- update the last posted version, commitment_gl_status to UNPOST
4344: --
4345: UPDATE pqh_budget_versions
4346: SET commitment_gl_status = 'UNPOST'
4347: WHERE budget_version_id = g_last_posted_ver;
4348: --
4349: -- update the budget_detail records corresponding to this version

Line 4582: From pqh_budget_versions

4578: Where budget_id=g_budget_id;
4579:
4580: Cursor csr_last_posted_ver IS
4581: Select budget_version_id
4582: From pqh_budget_versions
4583: Where budget_id = g_budget_id
4584: AND NVL(transfered_to_gl_flag,'N') = 'Y';
4585:
4586: