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_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PQH_BUDGETS

Line 109: -- VALIDATE IF THIS IS A VALID BUDGET IN PQH_BUDGETS

105: Begin
106: --
107: hr_utility.set_location('Entering :'||l_proc,5);
108: --
109: -- VALIDATE IF THIS IS A VALID BUDGET IN PQH_BUDGETS
110: --
111: Open csr_bdgt;
112: Fetch csr_bdgt into p_budget_id;
113: If csr_bdgt%notfound then

Line 484: From pqh_budgets

480: is
481: --
482: Cursor csr_uom_in_bdgt is
483: Select null
484: From pqh_budgets
485: Where budget_id = p_budget_id
486: AND (budget_unit1_id = p_unit_of_measure_id OR
487: budget_unit2_id = p_unit_of_measure_id OR
488: budget_unit3_id = p_unit_of_measure_id);

Line 514: l_budget_start_date pqh_budgets.budget_start_date%type;

510: PROCEDURE Validate_actuals_dates(p_actuals_start_dt in date,
511: p_actuals_end_dt in date,
512: p_budget_id in number) is
513: --
514: l_budget_start_date pqh_budgets.budget_start_date%type;
515: l_budget_end_date pqh_budgets.budget_end_date%type;
516: --
517: l_proc varchar2(72) := g_package||'Validate_actuals_dates';
518: --

Line 515: l_budget_end_date pqh_budgets.budget_end_date%type;

511: p_actuals_end_dt in date,
512: p_budget_id in number) is
513: --
514: l_budget_start_date pqh_budgets.budget_start_date%type;
515: l_budget_end_date pqh_budgets.budget_end_date%type;
516: --
517: l_proc varchar2(72) := g_package||'Validate_actuals_dates';
518: --
519: Cursor csr_bdgt is

Line 521: From pqh_budgets

517: l_proc varchar2(72) := g_package||'Validate_actuals_dates';
518: --
519: Cursor csr_bdgt is
520: Select budget_start_date,budget_end_date
521: From pqh_budgets
522: Where budget_id = p_budget_id;
523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);

Line 557: l_budget_start_date pqh_budgets.budget_start_date%type;

553: PROCEDURE Validate_commitment_dates(p_cmmtmnt_start_dt in date,
554: p_cmmtmnt_end_dt in date,
555: p_budget_id in number) is
556: --
557: l_budget_start_date pqh_budgets.budget_start_date%type;
558: l_budget_end_date pqh_budgets.budget_end_date%type;
559: --
560: l_proc varchar2(72) := g_package||'Validate_commitment_dates';
561: --

Line 558: l_budget_end_date pqh_budgets.budget_end_date%type;

554: p_cmmtmnt_end_dt in date,
555: p_budget_id in number) is
556: --
557: l_budget_start_date pqh_budgets.budget_start_date%type;
558: l_budget_end_date pqh_budgets.budget_end_date%type;
559: --
560: l_proc varchar2(72) := g_package||'Validate_commitment_dates';
561: --
562: Cursor csr_bdgt is

Line 564: From pqh_budgets

560: l_proc varchar2(72) := g_package||'Validate_commitment_dates';
561: --
562: Cursor csr_bdgt is
563: Select budget_start_date,budget_end_date
564: From pqh_budgets
565: Where budget_id = p_budget_id;
566: --
567: Begin
568: --

Line 1784: l_budget_id pqh_budgets.budget_id%type := NULL;

1780: l_assign_commitment number := 0;
1781: l_assign_actuals number := 0;
1782: l_last_payroll_dt per_time_periods.end_date%type := NULL;
1783: --
1784: l_budget_id pqh_budgets.budget_id%type := NULL;
1785: l_budget_version_id pqh_budget_versions.budget_version_id%type;
1786: --
1787:
1788: l_unit_of_measure per_shared_types.system_type_cd%type;

Line 1918: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1914: PROCEDURE get_pos_money_amounts
1915: (
1916: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
1917: p_position_id IN per_positions.position_id%TYPE,
1918: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1919: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1920: p_actual_amount OUT NOCOPY number,
1921: p_commitment_amount OUT NOCOPY number,
1922: p_total_amount OUT NOCOPY number

Line 1919: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1915: (
1916: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
1917: p_position_id IN per_positions.position_id%TYPE,
1918: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1919: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1920: p_actual_amount OUT NOCOPY number,
1921: p_commitment_amount OUT NOCOPY number,
1922: p_total_amount OUT NOCOPY number
1923: ) IS

Line 1938: l_budget_id pqh_budgets.budget_id%type := NULL;

1934: l_position_name hr_all_positions_f.name%type := NULL;
1935: l_assignment_id per_all_assignments_f.assignment_id%type;
1936: l_last_actuals_date per_time_periods.end_date%type;
1937: --
1938: l_budget_id pqh_budgets.budget_id%type := NULL;
1939: --
1940: l_unit_of_measure per_shared_types.system_type_cd%type;
1941: --
1942: l_assignment_actuals number := 0;

Line 2322: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2318: (
2319: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
2320: p_position_id IN per_positions.position_id%TYPE,
2321: p_element_type_id IN number default NULL,
2322: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2323: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2324: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2325: p_value_type IN varchar2,
2326: p_ex_assignment_id IN number default -1,

Line 2323: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2319: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
2320: p_position_id IN per_positions.position_id%TYPE,
2321: p_element_type_id IN number default NULL,
2322: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2323: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2324: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2325: p_value_type IN varchar2,
2326: p_ex_assignment_id IN number default -1,
2327: p_validate IN varchar2 default 'Y'

Line 2324: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2320: p_position_id IN per_positions.position_id%TYPE,
2321: p_element_type_id IN number default NULL,
2322: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2323: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2324: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2325: p_value_type IN varchar2,
2326: p_ex_assignment_id IN number default -1,
2327: p_validate IN varchar2 default 'Y'
2328: )

Line 2345: l_budget_id pqh_budgets.budget_id%type := NULL;

2341: l_position_name hr_all_positions_f.name%type := NULL;
2342: l_assignment_id per_all_assignments_f.assignment_id%type;
2343: l_last_actuals_date per_time_periods.end_date%type;
2344: --
2345: l_budget_id pqh_budgets.budget_id%type := NULL;
2346: --
2347: l_unit_of_measure per_shared_types.system_type_cd%type;
2348: --
2349: l_assignment_actuals number := 0;

Line 2572: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

2568: --
2569: Function get_ent_actual_and_cmmtmnt
2570: (
2571: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
2572: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
2573: p_entity_id IN pqh_budget_details.position_id%TYPE,
2574: p_element_type_id IN number default NULL,
2575: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2576: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2575: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2571: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
2572: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
2573: p_entity_id IN pqh_budget_details.position_id%TYPE,
2574: p_element_type_id IN number default NULL,
2575: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2576: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2577: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2578: p_value_type IN varchar2
2579: )

Line 2576: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2572: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
2573: p_entity_id IN pqh_budget_details.position_id%TYPE,
2574: p_element_type_id IN number default NULL,
2575: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2576: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2577: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2578: p_value_type IN varchar2
2579: )
2580: RETURN NUMBER IS

Line 2577: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2573: p_entity_id IN pqh_budget_details.position_id%TYPE,
2574: p_element_type_id IN number default NULL,
2575: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2576: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2577: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2578: p_value_type IN varchar2
2579: )
2580: RETURN NUMBER IS
2581: --

Line 2620: l_budget_id pqh_budgets.budget_id%type := NULL;

2616: l_assignment_id per_all_assignments_f.assignment_id%type;
2617: l_business_group_id per_all_assignments_f.business_group_id%type;
2618: l_last_actuals_date per_time_periods.end_date%type;
2619: --
2620: l_budget_id pqh_budgets.budget_id%type := NULL;
2621: --
2622: l_unit_of_measure per_shared_types.system_type_cd%type;
2623: --
2624: l_assignment_actuals number := 0;

Line 2635: From pqh_budgets

2631: l_effective_date date;
2632:
2633: CURSOR csr_bg_id is
2634: Select business_group_id
2635: From pqh_budgets
2636: Where budget_id = l_budget_id;
2637:
2638: --
2639: l_proc varchar2(72) := g_package||'get_ent_actual_and_cmmtmnt';

Line 3189: l_budget_id pqh_budgets.budget_id%type := NULL;

3185: l_position_actuals number;
3186: l_budget_actuals number;
3187: l_position_id pqh_budget_details.position_id%type;
3188: --
3189: l_budget_id pqh_budgets.budget_id%type := NULL;
3190: l_unit_of_measure per_shared_types.system_type_cd%type;
3191: --
3192: Cursor csr_positions_in_bdgt is
3193: Select Position_id

Line 3265: l_budget_id pqh_budgets.budget_id%type := NULL;

3261: l_position_commitment number;
3262: l_budget_commitment number;
3263: l_position_id pqh_budget_details.position_id%type;
3264: --
3265: l_budget_id pqh_budgets.budget_id%type := NULL;
3266: l_unit_of_measure per_shared_types.system_type_cd%type;
3267: --
3268:
3269: Cursor csr_positions_in_bdgt is

Line 3351: l_budget_id pqh_budgets.budget_id%type := NULL;

3347: l_job_id pqh_budget_details.position_id%type;
3348: l_grade_id pqh_budget_details.position_id%type;
3349: l_organization_id pqh_budget_details.position_id%type;
3350: --
3351: l_budget_id pqh_budgets.budget_id%type := NULL;
3352: l_unit_of_measure per_shared_types.system_type_cd%type;
3353: --
3354:
3355: Cursor csr_positions_in_bdgt is

Line 3357: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3353: --
3354:
3355: Cursor csr_positions_in_bdgt is
3356: Select Position_id
3357: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3358: Where bvr.budget_id = bgt.budget_id
3359: AND bvr.budget_version_id = p_budget_version_id
3360: AND bvr.budget_version_id = bdt.budget_version_id
3361: AND bgt.budgeted_entity_cd = 'POSITION';

Line 3365: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3361: AND bgt.budgeted_entity_cd = 'POSITION';
3362: --
3363: Cursor csr_jobs_in_bdgt is
3364: Select job_id
3365: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3366: Where bvr.budget_id = bgt.budget_id
3367: AND bvr.budget_version_id = p_budget_version_id
3368: AND bvr.budget_version_id = bdt.budget_version_id
3369: AND bgt.budgeted_entity_cd = 'JOB';

Line 3373: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3369: AND bgt.budgeted_entity_cd = 'JOB';
3370: --
3371: Cursor csr_grades_in_bdgt is
3372: Select grade_id
3373: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3374: Where bvr.budget_id = bgt.budget_id
3375: AND bvr.budget_version_id = p_budget_version_id
3376: AND bvr.budget_version_id = bdt.budget_version_id
3377: AND bgt.budgeted_entity_cd = 'GRADE';

Line 3381: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3377: AND bgt.budgeted_entity_cd = 'GRADE';
3378: --
3379: Cursor csr_orgs_in_bdgt is
3380: Select organization_id
3381: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3382: Where bvr.budget_id = bgt.budget_id
3383: AND bvr.budget_version_id = p_budget_version_id
3384: AND bvr.budget_version_id = bdt.budget_version_id
3385: AND bgt.budgeted_entity_cd = 'ORGANIZATION';

Line 3574: l_budget_id pqh_budgets.budget_id%type := NULL;

3570: l_job_id pqh_budget_details.position_id%type;
3571: l_grade_id pqh_budget_details.position_id%type;
3572: l_organization_id pqh_budget_details.position_id%type;
3573: --
3574: l_budget_id pqh_budgets.budget_id%type := NULL;
3575: l_unit_of_measure per_shared_types.system_type_cd%type;
3576: --
3577:
3578: Cursor csr_positions_in_bdgt is

Line 3580: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3576: --
3577:
3578: Cursor csr_positions_in_bdgt is
3579: Select Position_id
3580: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3581: Where bvr.budget_id = bgt.budget_id
3582: AND bvr.budget_version_id = p_budget_version_id
3583: AND bvr.budget_version_id = bdt.budget_version_id
3584: AND bgt.budgeted_entity_cd = 'POSITION';

Line 3588: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3584: AND bgt.budgeted_entity_cd = 'POSITION';
3585: --
3586: Cursor csr_jobs_in_bdgt is
3587: Select job_id
3588: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3589: Where bvr.budget_id = bgt.budget_id
3590: AND bvr.budget_version_id = p_budget_version_id
3591: AND bvr.budget_version_id = bdt.budget_version_id
3592: AND bgt.budgeted_entity_cd = 'JOB';

Line 3596: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3592: AND bgt.budgeted_entity_cd = 'JOB';
3593: --
3594: Cursor csr_grades_in_bdgt is
3595: Select grade_id
3596: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3597: Where bvr.budget_id = bgt.budget_id
3598: AND bvr.budget_version_id = p_budget_version_id
3599: AND bvr.budget_version_id = bdt.budget_version_id
3600: AND bgt.budgeted_entity_cd = 'GRADE';

Line 3604: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr

3600: AND bgt.budgeted_entity_cd = 'GRADE';
3601: --
3602: Cursor csr_orgs_in_bdgt is
3603: Select organization_id
3604: From pqh_budgets bgt,pqh_budget_details bdt,pqh_budget_versions bvr
3605: Where bvr.budget_id = bgt.budget_id
3606: AND bvr.budget_version_id = p_budget_version_id
3607: AND bvr.budget_version_id = bdt.budget_version_id
3608: AND bgt.budgeted_entity_cd = 'ORGANIZATION';

Line 3710: l_budget_id pqh_budgets.budget_id%type := NULL;

3706: ,p_assignment_commitment out nocopy number
3707: ,p_assignment_total out nocopy number
3708: ) is
3709: l_last_actuals_date per_time_periods.end_date%type;
3710: l_budget_id pqh_budgets.budget_id%type := NULL;
3711: --
3712: begin
3713: --
3714: p_assignment_total := 0;

Line 3818: from pqh_budgets bgt, pqh_budget_versions ver

3814: -- Single or multiple controlled budgets
3815: --
3816: cursor c_budgets is
3817: select bgt.budget_id, budget_version_id, budget_start_date, budget_end_date
3818: from pqh_budgets bgt, pqh_budget_versions ver
3819: where bgt.budget_id = ver.budget_id
3820: and (p_effective_date between date_from and date_to)
3821: and position_control_flag = 'Y'
3822: and budgeted_entity_cd = p_budget_entity

Line 3869: l_budget_id pqh_budgets.budget_id%type := NULL;

3865: l_position_name hr_all_positions_f.name%type := NULL;
3866: l_assignment_id per_all_assignments_f.assignment_id%type;
3867: l_last_actuals_date per_time_periods.end_date%type;
3868: --
3869: l_budget_id pqh_budgets.budget_id%type := NULL;
3870: --
3871: l_unit_of_measure per_shared_types.system_type_cd%type;
3872: --
3873: l_assignment_actuals number := 0;

Line 4160: l_budget_id pqh_budgets.budget_id%type := NULL;

4156: l_proc varchar2(72) := g_package ||'get_pos_money_total9';
4157: --
4158: l_dummy number;
4159: l_last_payroll_dt date;
4160: l_budget_id pqh_budgets.budget_id%type := NULL;
4161: --
4162: Begin
4163:
4164: hr_utility.set_location('Entering :'||l_proc,5);