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_COMMITMENT_POSTING dependencies on PQH_BUDGET_VERSIONS

Line 25: g_version_number pqh_budget_versions.version_number%TYPE;

21: g_user_je_category_name gl_interface.user_je_category_name%TYPE;
22: --
23: g_budget_version_id gl_interface.budget_version_id%TYPE;
24: g_gl_budget_version_id gl_interface.budget_version_id%TYPE;
25: g_version_number pqh_budget_versions.version_number%TYPE;
26: g_last_posted_ver gl_interface.budget_version_id%TYPE;
27: --
28: g_chart_of_accounts_id gl_interface.chart_of_accounts_id%TYPE;
29: g_default_currency_code gl_interface.currency_code%TYPE;

Line 58: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

54: -- Private Procedures added for Transfer to Grants
55: ---------------------------------------------------------------------------------------
56: PROCEDURE populate_pqh_gms_interface
57: (
58: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
59: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
60: p_posting_type_cd IN pqh_gl_interface.posting_type_cd%TYPE
61: );
62:

Line 194: (p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

190: -- If there is a currency associated with the budget,it will override all other currencies
191: --
192: --
193: PROCEDURE get_default_currency
194: (p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
195: p_default_currency_code OUT NOCOPY gl_interface.currency_code%TYPE) IS
196: --
197: -- local variables
198: --

Line 206: pqh_budget_versions bvr

202: CURSOR csr_curr_code IS
203: SELECT bg.currency_code
204: FROM per_business_groups bg,
205: pqh_budgets bgt,
206: pqh_budget_versions bvr
207: WHERE bgt.budget_id = bvr.budget_id
208: AND bvr.budget_version_id = p_budget_version_id
209: AND bgt.business_group_id = bg.business_group_id ;
210: --

Line 214: pqh_budget_versions bvr

210: --
211: CURSOR csr_bgt_curr IS
212: SELECT bgt.currency_code
213: FROM pqh_budgets bgt,
214: pqh_budget_versions bvr
215: WHERE bgt.budget_id = bvr.budget_id
216: AND bvr.budget_version_id = g_budget_version_id;
217: --
218: l_proc varchar2(72) := g_package||'get_default_currency';

Line 306: (p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE) IS

302:
303: ----------------------------------------------------------------------------------------------------
304: --
305: PROCEDURE fetch_global_values
306: (p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE) IS
307: --
308: l_proc varchar2(72) := g_package||'fetch_global_values';
309: --
310: l_budgets_rec pqh_budgets%ROWTYPE;

Line 311: l_budget_versions_rec pqh_budget_versions%ROWTYPE;

307: --
308: l_proc varchar2(72) := g_package||'fetch_global_values';
309: --
310: l_budgets_rec pqh_budgets%ROWTYPE;
311: l_budget_versions_rec pqh_budget_versions%ROWTYPE;
312: --
313: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;
314: l_shared_types_rec per_shared_types%ROWTYPE;
315: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;

Line 320: l_version_gl_status pqh_budget_versions.gl_status%TYPE;

316: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
317: l_gl_je_categories_rec gl_je_categories%ROWTYPE;
318: --
319: --
320: l_version_gl_status pqh_budget_versions.gl_status%TYPE;
321: --
322: l_gl_encumbrance_type_id gl_encumbrance_types.encumbrance_type_id%TYPE;
323: --
324: l_transfer_to_gl_flag pqh_budgets.transfer_to_gl_flag%TYPE;

Line 341: FROM pqh_budget_versions

337: --
338: --
339: CURSOR csr_budget_versions_rec IS
340: SELECT *
341: FROM pqh_budget_versions
342: WHERE budget_version_id = p_budget_version_id;
343:
344: CURSOR csr_budgets_rec IS
345: SELECT *

Line 348: FROM pqh_budget_versions

344: CURSOR csr_budgets_rec IS
345: SELECT *
346: FROM pqh_budgets
347: WHERE budget_id = ( SELECT budget_id
348: FROM pqh_budget_versions
349: WHERE budget_version_id = p_budget_version_id ) ;
350: --
351: CURSOR csr_chart_of_acc_id(p_set_of_books_id IN NUMBER) IS
352: SELECT *

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

903: END IF;
904:
905: END IF; -- budget_unit3_id IS NOT NULL
906: --
907: -- get the table route id for pqh_budget versions
908: --
909: OPEN csr_table_route(p_table_alias => 'BVR');
910: FETCH csr_table_route INTO g_table_route_id_bvr;
911: CLOSE csr_table_route;

Line 1390: (p_budget_version_id IN pqh_budget_versions.budget_version_id%type,

1386: --
1387: -------------------------------------------------------------------------------------
1388: --
1389: Procedure distribute_other_commitments
1390: (p_budget_version_id IN pqh_budget_versions.budget_version_id%type,
1391: p_position_id IN pqh_budget_details.position_id%type,
1392: p_organization_id IN pqh_budget_details.organization_id%type,
1393: p_job_id IN pqh_budget_details.job_id%type,
1394: p_grade_id IN pqh_budget_details.grade_id%type,

Line 1413: PQH_BUDGET_VERSIONS BVR

1409: --
1410: Cursor csr_get_budget_entity_cd is
1411: Select BGT.BUDGETED_ENTITY_CD , BGT.BUSINESS_GROUP_ID
1412: From PQH_BUDGETS BGT,
1413: PQH_BUDGET_VERSIONS BVR
1414: Where BGT.BUDGET_ID = BVR.BUDGET_ID
1415: And BGT.POSITION_CONTROL_FLAG ='Y'
1416: And l_effective_dt BETWEEN BGT.BUDGET_START_DATE AND BGT.BUDGET_END_DATE
1417: And BVR.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;

Line 1498: (p_budget_version_id IN pqh_budget_versions.budget_version_id%type,

1494: --
1495: -------------------------------------------------------------------------------------
1496: --
1497: Procedure distribute_money_commitments
1498: (p_budget_version_id IN pqh_budget_versions.budget_version_id%type,
1499: p_position_id IN pqh_budget_details.position_id%type,
1500: p_organization_id IN pqh_budget_details.organization_id%type,
1501: p_job_id IN pqh_budget_details.job_id%type,
1502: p_grade_id IN pqh_budget_details.grade_id%type,

Line 1519: PQH_BUDGET_VERSIONS BVR

1515: --
1516: Cursor csr_get_budget_entity_cd is
1517: Select BGT.BUDGETED_ENTITY_CD, BGT.BUSINESS_GROUP_ID
1518: From PQH_BUDGETS BGT,
1519: PQH_BUDGET_VERSIONS BVR
1520: Where BGT.BUDGET_ID = BVR.BUDGET_ID
1521: And BGT.POSITION_CONTROL_FLAG ='Y'
1522: And l_effective_dt BETWEEN BGT.BUDGET_START_DATE AND BGT.BUDGET_END_DATE
1523: And BVR.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;

Line 1641: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

1637: -- budget detail and distribute it to the funding sources.
1638: --
1639: --
1640: PROCEDURE populate_period_commitment_tab (
1641: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
1642: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
1643: p_position_id IN pqh_budget_details.position_id%TYPE,
1644: p_organization_id IN pqh_budget_details.organization_id%TYPE,
1645: p_job_id IN pqh_budget_details.job_id%TYPE,

Line 2994: -- This procedure will update the gl_status of pqh_budget_versions,

2990: ----------------------------------------------------------------------------------------------
2991: PROCEDURE update_commitment_gl_status
2992: IS
2993: --
2994: -- This procedure will update the gl_status of pqh_budget_versions,
2995: -- pqh_budget_details and update the pqh_gl_interface table
2996: -- We always update the TRANSFERED_TO_GL_FLAG = Y to indicate this is the
2997: -- latest budget_version that is posted to GL
2998: -- gl_status = POST or ERROR

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

3034: --
3035: END LOOP;
3036: CLOSE csr_budget_details;
3037: --
3038: -- update pqh_budget_versions and the program out variable
3039: --
3040: OPEN csr_budget_details_cnt;
3041: FETCH csr_budget_details_cnt INTO l_count;
3042: CLOSE csr_budget_details_cnt;

Line 3048: UPDATE pqh_budget_versions

3044: IF NVL(l_count,0) = 0 THEN
3045: --
3046: -- no errors
3047: --
3048: UPDATE pqh_budget_versions
3049: SET commitment_gl_status = 'POST'
3050: WHERE budget_version_id = g_budget_version_id;
3051: --
3052: -- set the OUT variable to SUCCESS

Line 3060: UPDATE pqh_budget_versions

3056: ELSE
3057: --
3058: -- there were errors in details
3059: --
3060: UPDATE pqh_budget_versions
3061: SET commitment_gl_status = 'ERROR'
3062: WHERE budget_version_id = g_budget_version_id;
3063: --
3064: -- set the OUT variable to ERROR

Line 3392: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

3388: -- ----------------------------------------------------------------------------
3389: --
3390: PROCEDURE populate_pqh_gl_interface
3391: (
3392: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
3393: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
3394: p_posting_type_cd IN pqh_gl_interface.posting_type_cd%TYPE
3395: )
3396: IS

Line 3627: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

3623: (
3624: errbuf OUT NOCOPY VARCHAR2,
3625: retcode OUT NOCOPY VARCHAR2,
3626: p_effective_date IN VARCHAR2 ,
3627: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
3628: p_post_to_period_name IN gl_period_statuses.period_name%TYPE DEFAULT NULL,
3629: p_validate IN VARCHAR2 default 'N'
3630: ) IS
3631: --

Line 3650: PQH_BUDGET_VERSIONS BVR

3646:
3647: Cursor csr_check_budget_is_ctrlbgt IS
3648: Select 1
3649: From PQH_BUDGETS BGT,
3650: PQH_BUDGET_VERSIONS BVR
3651: Where BGT.BUDGET_ID = BVR.BUDGET_ID
3652: And BGT.POSITION_CONTROL_FLAG ='Y'
3653: And l_effective_dt BETWEEN BGT.BUDGET_START_DATE AND BGT.BUDGET_END_DATE
3654: And BVR.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;

Line 3834: -- update gl_status of pqh_budget_versions and pqh_budget_details

3830: end if;
3831: --
3832: END IF;
3833: --
3834: -- update gl_status of pqh_budget_versions and pqh_budget_details
3835: -- update posting_date and status of pqh_gl_interface
3836: -- update the global g_status with the program status
3837: --
3838: IF NOT g_validate THEN

Line 4125: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,

4121: --------------------------------------------------------------------------------------------
4122:
4123: PROCEDURE populate_pqh_gms_interface
4124: (
4125: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
4126: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
4127: p_posting_type_cd IN pqh_gl_interface.posting_type_cd%TYPE
4128: )
4129: IS