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_PERIODS

Line 69: l_budget_period_id pqh_budget_periods.budget_period_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);
72:
73:

Line 226: -- create records in pqh_budget_periods

222: p_log_context => l_log_context
223: );
224:
225:
226: -- create records in pqh_budget_periods
227: populate_budget_periods
228: (
229: p_per_budget_val_rec => l_per_budget_val_rec,
230: p_budget_detail_id => l_budget_detail_id,

Line 607: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE

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

Line 613: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

609: IS
610: -- local variables and cursors
611:
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: /*

Line 614: l_budget_unit1_value_type_cd pqh_budget_periods.budget_unit1_value_type_cd%TYPE := 'V';

610: -- local variables and cursors
611:
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

Line 615: l_budget_unit1_percent pqh_budget_periods.budget_unit1_percent%TYPE;

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

Line 635: pqh_budget_periods_api.create_budget_period

631: -- compute l_budget_unit1_percent
632: l_budget_unit1_percent := (p_per_budget_val_rec.value/p_budget_unit1_value)*100 ;
633:
634: -- call insert API
635: pqh_budget_periods_api.create_budget_period
636: (
637: p_validate => false
638: ,p_budget_period_id => p_budget_period_id_o
639: ,p_budget_detail_id => p_budget_detail_id

Line 844: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,

840: --------------------------------------------------------------------------------------------------------------
841:
842: PROCEDURE populate_period_details
843: (
844: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
845: p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE
846: )
847: IS
848: /*

Line 855: l_budget_periods_rec pqh_budget_periods%ROWTYPE;

851: */
852: -- local variables and cursors
853:
854: l_proc varchar2(72) := g_package||'populate_period_details';
855: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
856: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;
857: l_dflt_budget_elements_rec pqh_dflt_budget_elements%ROWTYPE;
858: l_dflt_fund_srcs pqh_dflt_fund_srcs%ROWTYPE;
859: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;

Line 866: FROM pqh_budget_periods

862:
863:
864: CURSOR budget_periods_csr IS
865: SELECT *
866: FROM pqh_budget_periods
867: WHERE budget_period_id = p_budget_period_id;
868:
869: CURSOR pqh_dflt_budget_sets_cur (p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE) IS
870: SELECT *

Line 963: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,

959:
960: PROCEDURE populate_budget_sets
961: (
962: p_dflt_budget_sets_rec IN pqh_dflt_budget_sets%ROWTYPE,
963: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
964: p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE
965: )
966: IS
967: -- local variables and cursors

Line 970: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

966: IS
967: -- local variables and cursors
968:
969: l_proc varchar2(72) := g_package||'populate_budget_sets';
970: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
971: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
972: l_percent_sum pqh_dflt_budget_elements.dflt_dist_percentage%TYPE;
973: l_budget_unit1_available pqh_budget_periods.budget_unit1_available%TYPE;
974:

Line 971: l_budget_periods_rec pqh_budget_periods%ROWTYPE;

967: -- local variables and cursors
968:
969: l_proc varchar2(72) := g_package||'populate_budget_sets';
970: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
971: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
972: l_percent_sum pqh_dflt_budget_elements.dflt_dist_percentage%TYPE;
973: l_budget_unit1_available pqh_budget_periods.budget_unit1_available%TYPE;
974:
975: CURSOR budget_periods_csr IS

Line 973: l_budget_unit1_available pqh_budget_periods.budget_unit1_available%TYPE;

969: l_proc varchar2(72) := g_package||'populate_budget_sets';
970: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
971: l_budget_periods_rec pqh_budget_periods%ROWTYPE;
972: l_percent_sum pqh_dflt_budget_elements.dflt_dist_percentage%TYPE;
973: l_budget_unit1_available pqh_budget_periods.budget_unit1_available%TYPE;
974:
975: CURSOR budget_periods_csr IS
976: SELECT *
977: FROM pqh_budget_periods

Line 977: FROM pqh_budget_periods

973: l_budget_unit1_available pqh_budget_periods.budget_unit1_available%TYPE;
974:
975: CURSOR budget_periods_csr IS
976: SELECT *
977: FROM pqh_budget_periods
978: WHERE budget_period_id = p_budget_period_id;
979:
980: CURSOR budget_set_percent_csr IS
981: SELECT SUM(dflt_dist_percentage)

Line 1052: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1048:
1049: -- local variables and cursors
1050:
1051: l_proc varchar2(72) := g_package||'populate_budget_elements';
1052: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1053:
1054: BEGIN
1055:
1056: hr_utility.set_location('Entering: '||l_proc, 5);

Line 1093: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1089: IS
1090: -- local variables and cursors
1091:
1092: l_proc varchar2(72) := g_package||'populate_budget_fund_srcs';
1093: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1094:
1095: BEGIN
1096:
1097: hr_utility.set_location('Entering: '||l_proc, 5);