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_BUDGET_DATA_MIGRATION dependencies on PQH_BUDGET_DETAILS

Line 66: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;

62: l_tot_budget_val per_budget_values.value%TYPE;
63: l_per_budget_ver_rec per_budget_versions%ROWTYPE;
64: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
65: l_per_budget_elmnt_rec per_budget_elements%ROWTYPE;
66: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
67: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;
68: l_per_budget_val_rec per_budget_values%ROWTYPE;
69: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
70: l_log_context pqh_process_log.log_context%TYPE;

Line 67: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;

63: l_per_budget_ver_rec per_budget_versions%ROWTYPE;
64: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
65: l_per_budget_elmnt_rec per_budget_elements%ROWTYPE;
66: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
67: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;
68: l_per_budget_val_rec per_budget_values%ROWTYPE;
69: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
70: l_log_context pqh_process_log.log_context%TYPE;
71: l_valid varchar2(10);

Line 193: -- create records in pqh_budget_details

189: p_log_context => l_log_context
190: );
191:
192:
193: -- create records in pqh_budget_details
194: populate_budget_details
195: (
196: p_per_budget_elmnt_rec => l_per_budget_elmnt_rec,
197: p_budget_version_id => l_budget_version_id,

Line 523: p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE,

519: (
520: p_per_budget_elmnt_rec IN per_budget_elements%ROWTYPE,
521: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
522: p_tot_budget_val IN per_budget_values.value%TYPE,
523: p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE,
524: p_budget_unit1_value_o OUT NOCOPY pqh_budget_details.budget_unit1_value%TYPE
525: )
526: IS
527: -- local variables and cursors

Line 524: p_budget_unit1_value_o OUT NOCOPY pqh_budget_details.budget_unit1_value%TYPE

520: p_per_budget_elmnt_rec IN per_budget_elements%ROWTYPE,
521: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
522: p_tot_budget_val IN per_budget_values.value%TYPE,
523: p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE,
524: p_budget_unit1_value_o OUT NOCOPY pqh_budget_details.budget_unit1_value%TYPE
525: )
526: IS
527: -- local variables and cursors
528:

Line 530: l_object_version_number pqh_budget_details.object_version_number%TYPE;

526: IS
527: -- local variables and cursors
528:
529: l_proc varchar2(72) := g_package||'populate_budget_details';
530: l_object_version_number pqh_budget_details.object_version_number%TYPE;
531: l_budget_unit1_value_type_cd pqh_budget_details.budget_unit1_value_type_cd%TYPE := 'V';
532: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;
533: l_budget_unit1_percent pqh_budget_details.budget_unit1_percent%TYPE;
534: l_budget_unit1_available pqh_budget_details.budget_unit1_available%TYPE := 0;

Line 531: l_budget_unit1_value_type_cd pqh_budget_details.budget_unit1_value_type_cd%TYPE := 'V';

527: -- local variables and cursors
528:
529: l_proc varchar2(72) := g_package||'populate_budget_details';
530: l_object_version_number pqh_budget_details.object_version_number%TYPE;
531: l_budget_unit1_value_type_cd pqh_budget_details.budget_unit1_value_type_cd%TYPE := 'V';
532: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;
533: l_budget_unit1_percent pqh_budget_details.budget_unit1_percent%TYPE;
534: l_budget_unit1_available pqh_budget_details.budget_unit1_available%TYPE := 0;
535:

Line 532: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;

528:
529: l_proc varchar2(72) := g_package||'populate_budget_details';
530: l_object_version_number pqh_budget_details.object_version_number%TYPE;
531: l_budget_unit1_value_type_cd pqh_budget_details.budget_unit1_value_type_cd%TYPE := 'V';
532: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;
533: l_budget_unit1_percent pqh_budget_details.budget_unit1_percent%TYPE;
534: l_budget_unit1_available pqh_budget_details.budget_unit1_available%TYPE := 0;
535:
536: -- cursor for unit1_value

Line 533: l_budget_unit1_percent pqh_budget_details.budget_unit1_percent%TYPE;

529: l_proc varchar2(72) := g_package||'populate_budget_details';
530: l_object_version_number pqh_budget_details.object_version_number%TYPE;
531: l_budget_unit1_value_type_cd pqh_budget_details.budget_unit1_value_type_cd%TYPE := 'V';
532: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;
533: l_budget_unit1_percent pqh_budget_details.budget_unit1_percent%TYPE;
534: l_budget_unit1_available pqh_budget_details.budget_unit1_available%TYPE := 0;
535:
536: -- cursor for unit1_value
537: CURSOR unit1_val_cur IS

Line 534: l_budget_unit1_available pqh_budget_details.budget_unit1_available%TYPE := 0;

530: l_object_version_number pqh_budget_details.object_version_number%TYPE;
531: l_budget_unit1_value_type_cd pqh_budget_details.budget_unit1_value_type_cd%TYPE := 'V';
532: l_budget_unit1_value pqh_budget_details.budget_unit1_value%TYPE;
533: l_budget_unit1_percent pqh_budget_details.budget_unit1_percent%TYPE;
534: l_budget_unit1_available pqh_budget_details.budget_unit1_available%TYPE := 0;
535:
536: -- cursor for unit1_value
537: CURSOR unit1_val_cur IS
538: SELECT SUM(val.value)

Line 559: pqh_budget_details_api.create_budget_detail

555: -- compute l_budget_unit1_percent
556: l_budget_unit1_percent := (l_budget_unit1_value/p_tot_budget_val) * 100 ;
557:
558: -- call insert API
559: pqh_budget_details_api.create_budget_detail
560: (
561: p_validate => false
562: ,p_budget_detail_id => p_budget_detail_id_o
563: ,p_organization_id => p_per_budget_elmnt_rec.organization_id

Line 605: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

601:
602: PROCEDURE populate_budget_periods
603: (
604: p_per_budget_val_rec IN per_budget_values%ROWTYPE,
605: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
606: p_budget_unit1_value IN pqh_budget_details.budget_unit1_value%TYPE,
607: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
608: )
609: IS

Line 606: p_budget_unit1_value IN pqh_budget_details.budget_unit1_value%TYPE,

602: PROCEDURE populate_budget_periods
603: (
604: p_per_budget_val_rec IN per_budget_values%ROWTYPE,
605: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
606: p_budget_unit1_value IN pqh_budget_details.budget_unit1_value%TYPE,
607: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
608: )
609: IS
610: -- local variables and cursors

Line 616: l_budget_unit1_available pqh_budget_details.budget_unit1_available%TYPE := 0;

612: l_proc varchar2(72) := g_package||'populate_budget_periods';
613: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
614: l_budget_unit1_value_type_cd pqh_budget_periods.budget_unit1_value_type_cd%TYPE := 'V';
615: l_budget_unit1_percent pqh_budget_periods.budget_unit1_percent%TYPE;
616: l_budget_unit1_available pqh_budget_details.budget_unit1_available%TYPE := 0;
617: /*
618: changed as per Sumit's reqt that p_budget_unit1_available equals value
619: 02/16/2000
620: changed on 3/20/1999 as now we also have records in budget sets for the budget_period