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.

[Home] [Help]

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 1787: l_budget_id pqh_budgets.budget_id%type := NULL;

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

Line 1921: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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

Line 1922: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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

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

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

Line 2325: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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

Line 2326: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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

Line 2327: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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

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

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

Line 2575: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

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

Line 2578: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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

Line 2579: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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

Line 2580: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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

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

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

Line 2638: From pqh_budgets

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3821: from pqh_budgets bgt, pqh_budget_versions ver

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

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

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

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

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