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_DETAILS

Line 59: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

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:
63: PROCEDURE insert_pqh_gms_interface

Line 914: -- get the table route id for pqh_budget details

910: FETCH csr_table_route INTO g_table_route_id_bvr;
911: CLOSE csr_table_route;
912:
913: --
914: -- get the table route id for pqh_budget details
915: --
916: OPEN csr_table_route(p_table_alias => 'BDT');
917: FETCH csr_table_route INTO g_table_route_id_bdt;
918: CLOSE csr_table_route;

Line 921: -- get the table route id for pqh_budget details

917: FETCH csr_table_route INTO g_table_route_id_bdt;
918: CLOSE csr_table_route;
919:
920: --
921: -- get the table route id for pqh_budget details
922: --
923: OPEN csr_table_route(p_table_alias => 'BPR');
924: FETCH csr_table_route INTO g_table_route_id_bpr;
925: CLOSE csr_table_route;

Line 1391: p_position_id IN pqh_budget_details.position_id%type,

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,
1395: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,

Line 1392: p_organization_id IN pqh_budget_details.organization_id%type,

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,
1395: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1396: p_budget_unit_seq IN number,

Line 1393: p_job_id IN pqh_budget_details.job_id%type,

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,
1395: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1396: p_budget_unit_seq IN number,
1397: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,

Line 1394: p_grade_id IN pqh_budget_details.grade_id%type,

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,
1395: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1396: p_budget_unit_seq IN number,
1397: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1398: p_effective_date IN varchar2) IS

Line 1499: p_position_id IN pqh_budget_details.position_id%type,

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,
1503: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,

Line 1500: p_organization_id IN pqh_budget_details.organization_id%type,

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,
1503: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1504: p_budget_unit_seq IN number,

Line 1501: p_job_id IN pqh_budget_details.job_id%type,

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,
1503: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1504: p_budget_unit_seq IN number,
1505: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,

Line 1502: p_grade_id IN pqh_budget_details.grade_id%type,

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,
1503: p_budget_period_id IN pqh_budget_periods.budget_period_id%type,
1504: p_budget_unit_seq IN number,
1505: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1506: p_effective_date IN varchar2) IS

Line 1642: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

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,
1646: p_grade_id IN pqh_budget_details.grade_id%TYPE,

Line 1643: p_position_id IN pqh_budget_details.position_id%TYPE,

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,
1646: p_grade_id IN pqh_budget_details.grade_id%TYPE,
1647: p_effective_date IN varchar2) IS

Line 1644: p_organization_id IN pqh_budget_details.organization_id%TYPE,

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,
1646: p_grade_id IN pqh_budget_details.grade_id%TYPE,
1647: p_effective_date IN varchar2) IS
1648: --

Line 1645: p_job_id IN pqh_budget_details.job_id%TYPE,

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,
1646: p_grade_id IN pqh_budget_details.grade_id%TYPE,
1647: p_effective_date IN varchar2) IS
1648: --
1649: -- local variables

Line 1646: p_grade_id IN pqh_budget_details.grade_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,
1646: p_grade_id IN pqh_budget_details.grade_id%TYPE,
1647: p_effective_date IN varchar2) IS
1648: --
1649: -- local variables
1650: --

Line 2000: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

1996: -----------------------------------------------------------------------------------------
1997: --
1998: PROCEDURE update_period_commitment_tab
1999: (
2000: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
2001: p_post_to_period_name IN gl_period_statuses.period_name%TYPE
2002: )
2003: IS
2004: --

Line 2216: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

2212: ***************************************************************************************************************/
2213: --
2214: PROCEDURE build_old_bdgt_dtls_tab
2215: (
2216: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
2217: p_posting_type_cd IN varchar2
2218: ) IS
2219: --
2220: -- local variables

Line 2393: ( p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

2389: -- transaction for all records where reverse_flag is Y and update the posted
2390: -- record amount to 0
2391: --
2392: PROCEDURE reverse_old_bdgt_dtls_tab
2393: ( p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
2394: p_posting_type_cd IN varchar2) IS
2395: --
2396: -- local variables
2397: --

Line 2640: -- update the pqh_budget_details table gl_status to ERROR

2636:
2637: END LOOP;
2638: CLOSE csr_adj;
2639: --
2640: -- update the pqh_budget_details table gl_status to ERROR
2641: --
2642: UPDATE pqh_budget_details
2643: SET commitment_gl_status = 'ERROR'
2644: WHERE budget_version_id = g_budget_version_id

Line 2642: UPDATE pqh_budget_details

2638: CLOSE csr_adj;
2639: --
2640: -- update the pqh_budget_details table gl_status to ERROR
2641: --
2642: UPDATE pqh_budget_details
2643: SET commitment_gl_status = 'ERROR'
2644: WHERE budget_version_id = g_budget_version_id
2645: AND budget_detail_id IN
2646: ( SELECT distinct budget_detail_id

Line 2995: -- pqh_budget_details and update the pqh_gl_interface table

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
2999: --

Line 3002: l_budget_details_rec pqh_budget_details%ROWTYPE;

2998: -- gl_status = POST or ERROR
2999: --
3000: -- local variables
3001: --
3002: l_budget_details_rec pqh_budget_details%ROWTYPE;
3003: l_count NUMBER;
3004: --
3005: CURSOR csr_budget_details IS
3006: SELECT *

Line 3007: FROM pqh_budget_details

3003: l_count NUMBER;
3004: --
3005: CURSOR csr_budget_details IS
3006: SELECT *
3007: FROM pqh_budget_details
3008: WHERE budget_version_id = g_budget_version_id
3009: AND NVL(commitment_gl_status,'X') <> 'ERROR'
3010: FOR UPDATE OF commitment_gl_status;
3011: --

Line 3014: FROM pqh_budget_details

3010: FOR UPDATE OF commitment_gl_status;
3011: --
3012: CURSOR csr_budget_details_cnt IS
3013: SELECT COUNT(*)
3014: FROM pqh_budget_details
3015: WHERE budget_version_id = g_budget_version_id
3016: AND NVL(commitment_gl_status,'ERROR') = 'ERROR';
3017: --
3018: l_proc varchar2(72) := g_package||'update_commitment_gl_status';

Line 3024: -- update pqh_budget_details

3020: BEGIN
3021: --
3022: hr_utility.set_location('Entering: '||l_proc, 5);
3023: --
3024: -- update pqh_budget_details
3025: --
3026: OPEN csr_budget_details;
3027: LOOP
3028: FETCH csr_budget_details INTO l_budget_details_rec;

Line 3031: UPDATE pqh_budget_details

3027: LOOP
3028: FETCH csr_budget_details INTO l_budget_details_rec;
3029: EXIT WHEN csr_budget_details%NOTFOUND;
3030: --
3031: UPDATE pqh_budget_details
3032: SET commitment_gl_status = 'POST'
3033: WHERE CURRENT OF csr_budget_details;
3034: --
3035: END LOOP;

Line 3106: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

3102: --------------------------------------------------------------------------------------------------
3103: --
3104: PROCEDURE set_bdt_log_context
3105: (
3106: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
3107: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
3108: ) IS
3109: --
3110: -- This procedure will set the log_context at Budget detail level

Line 3114: l_budget_details_rec pqh_budget_details%ROWTYPE;

3110: -- This procedure will set the log_context at Budget detail level
3111: -- We are processing only positions . So we need to set store the
3112: -- position_name.
3113: --
3114: l_budget_details_rec pqh_budget_details%ROWTYPE;
3115: l_position_name hr_all_positions.name%TYPE;
3116: l_log_context pqh_process_log.log_context%TYPE;
3117: --
3118: CURSOR csr_bdt_detail_rec IS

Line 3120: FROM pqh_budget_details

3116: l_log_context pqh_process_log.log_context%TYPE;
3117: --
3118: CURSOR csr_bdt_detail_rec IS
3119: SELECT *
3120: FROM pqh_budget_details
3121: WHERE budget_detail_id = p_budget_detail_id ;
3122: --
3123: l_proc varchar2(72) := g_package||'set_bdt_log_context';
3124: --

Line 3393: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

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
3397: --

Line 3401: -- then update the pqh_budget_details record with gl_status = ERROR.

3397: --
3398: -- This procedure will update or insert into pqh_gl_interface if there was
3399: -- no error -- for the current budget detail record i.e g_detail_error = N.
3400: -- If g_detail_error = Y
3401: -- then update the pqh_budget_details record with gl_status = ERROR.
3402: --
3403: l_pqh_gl_interface_rec pqh_gl_interface%ROWTYPE;
3404: l_uom1_count number;
3405: l_uom2_count number;

Line 3583: -- update pqh_budget_details reset status if previous run was ERROR

3579: --
3580: END IF;
3581: END LOOP; -- end of pl sql table
3582: --
3583: -- update pqh_budget_details reset status if previous run was ERROR
3584: --
3585: UPDATE pqh_budget_details
3586: SET commitment_gl_status = ''
3587: WHERE budget_detail_id = p_budget_detail_id;

Line 3585: UPDATE pqh_budget_details

3581: END LOOP; -- end of pl sql table
3582: --
3583: -- update pqh_budget_details reset status if previous run was ERROR
3584: --
3585: UPDATE pqh_budget_details
3586: SET commitment_gl_status = ''
3587: WHERE budget_detail_id = p_budget_detail_id;
3588: --
3589: ELSE -- g_detail_error = Y i.e errors in budget details children

Line 3592: -- update pqh_budget_details

3588: --
3589: ELSE -- g_detail_error = Y i.e errors in budget details children
3590: hr_utility.set_location('******############',101);
3591: --
3592: -- update pqh_budget_details
3593: --
3594: UPDATE pqh_budget_details
3595: SET commitment_gl_status = 'ERROR'
3596: WHERE budget_detail_id = p_budget_detail_id;

Line 3594: UPDATE pqh_budget_details

3590: hr_utility.set_location('******############',101);
3591: --
3592: -- update pqh_budget_details
3593: --
3594: UPDATE pqh_budget_details
3595: SET commitment_gl_status = 'ERROR'
3596: WHERE budget_detail_id = p_budget_detail_id;
3597: --
3598: END IF; -- g_detail_error = 'N'

Line 3634: l_budget_details_rec pqh_budget_details%ROWTYPE;

3630: ) IS
3631: --
3632: -- Declaring local variables
3633: --
3634: l_budget_details_rec pqh_budget_details%ROWTYPE;
3635: l_log_context pqh_process_log.log_context%TYPE;
3636: l_effective_dt date;
3637: --
3638: CURSOR csr_budget_detail_recs IS

Line 3640: FROM pqh_budget_details

3636: l_effective_dt date;
3637: --
3638: CURSOR csr_budget_detail_recs IS
3639: SELECT *
3640: FROM pqh_budget_details
3641: WHERE budget_version_id = p_budget_version_id
3642: AND NVL(commitment_gl_status,'X') <> 'POST';
3643: --
3644: -- Cursor added to check the passed budget version is control budget.(Bug 2288274)

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 4126: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

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
4130: /*

Line 4133: if g_detail_error = Y then update the pqh_budget_details record with gl_status = ERROR

4129: IS
4130: /*
4131: This procedure will update or insert GMS records into pqh_gl_interface if there was no error for
4132: the current budget detail record i.e g_detail_error = N
4133: if g_detail_error = Y then update the pqh_budget_details record with gl_status = ERROR
4134:
4135: Also it will Deduct a similar amount from Budget Commitments.
4136: If a Bduget Commitment for that Detail/Period is not available error is thrown and program is
4137: aborted

Line 4341: -- update pqh_budget_details reset status if previous run was ERROR

4337:
4338: END IF; -- Insert only GMS records
4339: END LOOP; -- end of pl sql table
4340:
4341: -- update pqh_budget_details reset status if previous run was ERROR
4342: UPDATE pqh_budget_details
4343: SET commitment_gl_status = ''
4344: WHERE budget_detail_id = p_budget_detail_id;
4345:

Line 4342: UPDATE pqh_budget_details

4338: END IF; -- Insert only GMS records
4339: END LOOP; -- end of pl sql table
4340:
4341: -- update pqh_budget_details reset status if previous run was ERROR
4342: UPDATE pqh_budget_details
4343: SET commitment_gl_status = ''
4344: WHERE budget_detail_id = p_budget_detail_id;
4345:
4346:

Line 4350: -- update pqh_budget_details

4346:
4347:
4348: ELSE -- g_detail_error = Y i.e errors in budget details children
4349:
4350: -- update pqh_budget_details
4351: UPDATE pqh_budget_details
4352: SET commitment_gl_status = 'ERROR'
4353: WHERE budget_detail_id = p_budget_detail_id;
4354:

Line 4351: UPDATE pqh_budget_details

4347:
4348: ELSE -- g_detail_error = Y i.e errors in budget details children
4349:
4350: -- update pqh_budget_details
4351: UPDATE pqh_budget_details
4352: SET commitment_gl_status = 'ERROR'
4353: WHERE budget_detail_id = p_budget_detail_id;
4354:
4355: END IF; -- g_detail_error = 'N'

Line 4738: UPDATE pqh_budget_details

4734: --For each record that failed in import update budget_detail status
4735: --
4736: hr_utility.set_location('Set Budget Detail status to Error', 25);
4737: begin
4738: UPDATE pqh_budget_details
4739: SET gl_status = 'ERROR'
4740: Where budget_detail_id in (select budget_detail_id from pqh_gl_interface where
4741: budget_version_id=g_budget_version_id
4742: And cost_allocation_keyflex_id is null