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_APPLY_BUDGET dependencies on PQH_BUDGET_PERIODS

Line 294: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;

290: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
291: l_pqh_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
292: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
293: l_pqh_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
294: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
295: l_pqh_worksheet_budget_set_rec pqh_worksheet_budget_sets%ROWTYPE;
296: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
297: l_pqh_worksheet_bdgt_elmnt_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
298: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;

Line 396: -- create records in pqh_budget_periods

392: p_log_context => l_log_context
393: );
394:
395:
396: -- create records in pqh_budget_periods
397: populate_budget_periods
398: (
399: p_worksheet_periods_rec => l_pqh_worksheet_periods_rec,
400: p_budget_detail_id => l_budget_detail_id,

Line 586: and delete only those rows from pqh_budget_periods table onwards for the above

582: -- delete the rows from budget tables
583: /*
584: delete_child_rows
585: we pick budget_detail_id from pqh_worksheet_details table for this worksheet_id
586: and delete only those rows from pqh_budget_periods table onwards for the above
587: fetched budget_detail_id from pqh_worksheet_details table.
588: */
589: delete_child_rows
590: (

Line 970: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE

966: PROCEDURE populate_budget_periods
967: (
968: p_worksheet_periods_rec IN pqh_worksheet_periods%ROWTYPE,
969: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
970: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
971: )
972: IS
973: -- local variables and cursors
974:

Line 976: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

972: IS
973: -- local variables and cursors
974:
975: l_proc varchar2(72) := g_package||'populate_budget_periods';
976: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
977:
978: BEGIN
979:
980: hr_utility.set_location('Entering: '||l_proc, 5);

Line 985: pqh_budget_periods_api.create_budget_period

981:
982: IF p_budget_detail_id IS NOT NULL THEN
983:
984: -- call insert API
985: pqh_budget_periods_api.create_budget_period
986: (
987: p_validate => false
988: ,p_budget_period_id => p_budget_period_id_o
989: ,p_budget_detail_id => p_budget_detail_id

Line 1031: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,

1027:
1028: PROCEDURE populate_budget_sets
1029: (
1030: p_worksheet_budget_sets_rec IN pqh_worksheet_budget_sets%ROWTYPE,
1031: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
1032: p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE
1033: )
1034: IS
1035: -- local variables and cursors

Line 1038: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1034: IS
1035: -- local variables and cursors
1036:
1037: l_proc varchar2(72) := g_package||'populate_budget_sets';
1038: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1039:
1040: BEGIN
1041:
1042: hr_utility.set_location('Entering: '||l_proc, 5);

Line 1100: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1096:
1097: -- local variables and cursors
1098:
1099: l_proc varchar2(72) := g_package||'populate_budget_elements';
1100: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1101:
1102: BEGIN
1103:
1104: hr_utility.set_location('Entering: '||l_proc, 5);

Line 1147: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1143: IS
1144: -- local variables and cursors
1145:
1146: l_proc varchar2(72) := g_package||'populate_budget_fund_srcs';
1147: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1148:
1149: BEGIN
1150:
1151: hr_utility.set_location('Entering: '||l_proc, 5);

Line 1212: CURSOR pqh_budget_periods_cur (p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE) IS

1208: FROM pqh_worksheet_details
1209: WHERE worksheet_id = p_worksheet_id
1210: AND NVL(action_cd,'X') = 'B' ) ;
1211:
1212: CURSOR pqh_budget_periods_cur (p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE) IS
1213: SELECT *
1214: FROM pqh_budget_periods
1215: WHERE budget_detail_id = p_budget_detail_id;
1216:

Line 1214: FROM pqh_budget_periods

1210: AND NVL(action_cd,'X') = 'B' ) ;
1211:
1212: CURSOR pqh_budget_periods_cur (p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE) IS
1213: SELECT *
1214: FROM pqh_budget_periods
1215: WHERE budget_detail_id = p_budget_detail_id;
1216:
1217: CURSOR pqh_budget_sets_cur (p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE) IS
1218: SELECT *

Line 1217: CURSOR pqh_budget_sets_cur (p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE) IS

1213: SELECT *
1214: FROM pqh_budget_periods
1215: WHERE budget_detail_id = p_budget_detail_id;
1216:
1217: CURSOR pqh_budget_sets_cur (p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE) IS
1218: SELECT *
1219: FROM pqh_budget_sets
1220: WHERE budget_period_id = p_budget_period_id;
1221:

Line 1245: l_pqh_budget_periods_rec pqh_budget_periods%ROWTYPE;

1241: l_pqh_worksheets_rec pqh_worksheets%ROWTYPE;
1242: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1243: l_pqh_budget_details_rec pqh_budget_details%ROWTYPE;
1244: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
1245: l_pqh_budget_periods_rec pqh_budget_periods%ROWTYPE;
1246: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
1247: l_pqh_budget_sets_rec pqh_budget_sets%ROWTYPE;
1248: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
1249: l_pqh_budget_elements_rec pqh_budget_elements%ROWTYPE;

Line 1246: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;

1242: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1243: l_pqh_budget_details_rec pqh_budget_details%ROWTYPE;
1244: l_budget_detail_id pqh_budget_details.budget_detail_id%TYPE;
1245: l_pqh_budget_periods_rec pqh_budget_periods%ROWTYPE;
1246: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
1247: l_pqh_budget_sets_rec pqh_budget_sets%ROWTYPE;
1248: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
1249: l_pqh_budget_elements_rec pqh_budget_elements%ROWTYPE;
1250: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;

Line 1286: -- open pqh_budget_periods_cur

1282: p_budget_version_id => p_budget_version_id,
1283: p_budget_detail_id_o => l_budget_detail_id
1284: );
1285:
1286: -- open pqh_budget_periods_cur
1287: OPEN pqh_budget_periods_cur(p_budget_detail_id => l_pqh_budget_details_rec.budget_detail_id);
1288: LOOP -- loop 3
1289: FETCH pqh_budget_periods_cur INTO l_pqh_budget_periods_rec;
1290: EXIT WHEN pqh_budget_periods_cur%NOTFOUND;

Line 1287: OPEN pqh_budget_periods_cur(p_budget_detail_id => l_pqh_budget_details_rec.budget_detail_id);

1283: p_budget_detail_id_o => l_budget_detail_id
1284: );
1285:
1286: -- open pqh_budget_periods_cur
1287: OPEN pqh_budget_periods_cur(p_budget_detail_id => l_pqh_budget_details_rec.budget_detail_id);
1288: LOOP -- loop 3
1289: FETCH pqh_budget_periods_cur INTO l_pqh_budget_periods_rec;
1290: EXIT WHEN pqh_budget_periods_cur%NOTFOUND;
1291: -- create records in pqh_budget_periods

Line 1289: FETCH pqh_budget_periods_cur INTO l_pqh_budget_periods_rec;

1285:
1286: -- open pqh_budget_periods_cur
1287: OPEN pqh_budget_periods_cur(p_budget_detail_id => l_pqh_budget_details_rec.budget_detail_id);
1288: LOOP -- loop 3
1289: FETCH pqh_budget_periods_cur INTO l_pqh_budget_periods_rec;
1290: EXIT WHEN pqh_budget_periods_cur%NOTFOUND;
1291: -- create records in pqh_budget_periods
1292: carry_forward_budget_periods
1293: (

Line 1290: EXIT WHEN pqh_budget_periods_cur%NOTFOUND;

1286: -- open pqh_budget_periods_cur
1287: OPEN pqh_budget_periods_cur(p_budget_detail_id => l_pqh_budget_details_rec.budget_detail_id);
1288: LOOP -- loop 3
1289: FETCH pqh_budget_periods_cur INTO l_pqh_budget_periods_rec;
1290: EXIT WHEN pqh_budget_periods_cur%NOTFOUND;
1291: -- create records in pqh_budget_periods
1292: carry_forward_budget_periods
1293: (
1294: p_pqh_budget_periods_rec => l_pqh_budget_periods_rec,

Line 1291: -- create records in pqh_budget_periods

1287: OPEN pqh_budget_periods_cur(p_budget_detail_id => l_pqh_budget_details_rec.budget_detail_id);
1288: LOOP -- loop 3
1289: FETCH pqh_budget_periods_cur INTO l_pqh_budget_periods_rec;
1290: EXIT WHEN pqh_budget_periods_cur%NOTFOUND;
1291: -- create records in pqh_budget_periods
1292: carry_forward_budget_periods
1293: (
1294: p_pqh_budget_periods_rec => l_pqh_budget_periods_rec,
1295: p_budget_detail_id => l_budget_detail_id,

Line 1294: p_pqh_budget_periods_rec => l_pqh_budget_periods_rec,

1290: EXIT WHEN pqh_budget_periods_cur%NOTFOUND;
1291: -- create records in pqh_budget_periods
1292: carry_forward_budget_periods
1293: (
1294: p_pqh_budget_periods_rec => l_pqh_budget_periods_rec,
1295: p_budget_detail_id => l_budget_detail_id,
1296: p_budget_period_id_o => l_budget_period_id
1297: );
1298:

Line 1300: OPEN pqh_budget_sets_cur(p_budget_period_id => l_pqh_budget_periods_rec.budget_period_id);

1296: p_budget_period_id_o => l_budget_period_id
1297: );
1298:
1299: -- open pqh_budget_sets_cur
1300: OPEN pqh_budget_sets_cur(p_budget_period_id => l_pqh_budget_periods_rec.budget_period_id);
1301: LOOP -- loop 4
1302: FETCH pqh_budget_sets_cur INTO l_pqh_budget_sets_rec;
1303: EXIT WHEN pqh_budget_sets_cur%NOTFOUND;
1304: -- create records in pqh_budget_sets

Line 1349: CLOSE pqh_budget_periods_cur;

1345: END LOOP; -- loop 4
1346: CLOSE pqh_budget_sets_cur;
1347:
1348: END LOOP; -- loop 3
1349: CLOSE pqh_budget_periods_cur;
1350:
1351: END LOOP; -- loop 2
1352: CLOSE pqh_budget_details_cur;
1353:

Line 1426: p_pqh_budget_periods_rec IN pqh_budget_periods%ROWTYPE,

1422:
1423: --------------------------------------------------------------------------------------------------------------
1424: PROCEDURE carry_forward_budget_periods
1425: (
1426: p_pqh_budget_periods_rec IN pqh_budget_periods%ROWTYPE,
1427: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
1428: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
1429: )
1430: IS

Line 1428: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE

1424: PROCEDURE carry_forward_budget_periods
1425: (
1426: p_pqh_budget_periods_rec IN pqh_budget_periods%ROWTYPE,
1427: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
1428: p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
1429: )
1430: IS
1431: -- local variables and cursors
1432:

Line 1434: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1430: IS
1431: -- local variables and cursors
1432:
1433: l_proc varchar2(72) := g_package||'carry_forward_budget_periods';
1434: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1435:
1436: BEGIN
1437:
1438: hr_utility.set_location('Entering: '||l_proc, 5);

Line 1443: pqh_budget_periods_api.create_budget_period

1439:
1440: IF p_budget_detail_id IS NOT NULL THEN
1441:
1442: -- call insert API
1443: pqh_budget_periods_api.create_budget_period
1444: (
1445: p_validate => false
1446: ,p_budget_period_id => p_budget_period_id_o
1447: ,p_budget_detail_id => p_budget_detail_id

Line 1448: ,p_start_time_period_id => p_pqh_budget_periods_rec.start_time_period_id

1444: (
1445: p_validate => false
1446: ,p_budget_period_id => p_budget_period_id_o
1447: ,p_budget_detail_id => p_budget_detail_id
1448: ,p_start_time_period_id => p_pqh_budget_periods_rec.start_time_period_id
1449: ,p_end_time_period_id => p_pqh_budget_periods_rec.end_time_period_id
1450: ,p_budget_unit1_percent => p_pqh_budget_periods_rec.budget_unit1_percent
1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent
1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent

Line 1449: ,p_end_time_period_id => p_pqh_budget_periods_rec.end_time_period_id

1445: p_validate => false
1446: ,p_budget_period_id => p_budget_period_id_o
1447: ,p_budget_detail_id => p_budget_detail_id
1448: ,p_start_time_period_id => p_pqh_budget_periods_rec.start_time_period_id
1449: ,p_end_time_period_id => p_pqh_budget_periods_rec.end_time_period_id
1450: ,p_budget_unit1_percent => p_pqh_budget_periods_rec.budget_unit1_percent
1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent
1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent
1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value

Line 1450: ,p_budget_unit1_percent => p_pqh_budget_periods_rec.budget_unit1_percent

1446: ,p_budget_period_id => p_budget_period_id_o
1447: ,p_budget_detail_id => p_budget_detail_id
1448: ,p_start_time_period_id => p_pqh_budget_periods_rec.start_time_period_id
1449: ,p_end_time_period_id => p_pqh_budget_periods_rec.end_time_period_id
1450: ,p_budget_unit1_percent => p_pqh_budget_periods_rec.budget_unit1_percent
1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent
1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent
1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value
1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value

Line 1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent

1447: ,p_budget_detail_id => p_budget_detail_id
1448: ,p_start_time_period_id => p_pqh_budget_periods_rec.start_time_period_id
1449: ,p_end_time_period_id => p_pqh_budget_periods_rec.end_time_period_id
1450: ,p_budget_unit1_percent => p_pqh_budget_periods_rec.budget_unit1_percent
1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent
1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent
1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value
1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value
1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value

Line 1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent

1448: ,p_start_time_period_id => p_pqh_budget_periods_rec.start_time_period_id
1449: ,p_end_time_period_id => p_pqh_budget_periods_rec.end_time_period_id
1450: ,p_budget_unit1_percent => p_pqh_budget_periods_rec.budget_unit1_percent
1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent
1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent
1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value
1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value
1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value
1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd

Line 1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value

1449: ,p_end_time_period_id => p_pqh_budget_periods_rec.end_time_period_id
1450: ,p_budget_unit1_percent => p_pqh_budget_periods_rec.budget_unit1_percent
1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent
1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent
1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value
1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value
1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value
1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd
1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd

Line 1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value

1450: ,p_budget_unit1_percent => p_pqh_budget_periods_rec.budget_unit1_percent
1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent
1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent
1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value
1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value
1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value
1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd
1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd
1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd

Line 1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value

1451: ,p_budget_unit2_percent => p_pqh_budget_periods_rec.budget_unit2_percent
1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent
1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value
1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value
1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value
1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd
1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd
1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd
1459: ,p_budget_unit1_available => p_pqh_budget_periods_rec.budget_unit1_available

Line 1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd

1452: ,p_budget_unit3_percent => p_pqh_budget_periods_rec.budget_unit3_percent
1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value
1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value
1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value
1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd
1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd
1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd
1459: ,p_budget_unit1_available => p_pqh_budget_periods_rec.budget_unit1_available
1460: ,p_budget_unit2_available => p_pqh_budget_periods_rec.budget_unit2_available

Line 1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd

1453: ,p_budget_unit1_value => p_pqh_budget_periods_rec.budget_unit1_value
1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value
1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value
1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd
1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd
1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd
1459: ,p_budget_unit1_available => p_pqh_budget_periods_rec.budget_unit1_available
1460: ,p_budget_unit2_available => p_pqh_budget_periods_rec.budget_unit2_available
1461: ,p_budget_unit3_available => p_pqh_budget_periods_rec.budget_unit3_available

Line 1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd

1454: ,p_budget_unit2_value => p_pqh_budget_periods_rec.budget_unit2_value
1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value
1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd
1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd
1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd
1459: ,p_budget_unit1_available => p_pqh_budget_periods_rec.budget_unit1_available
1460: ,p_budget_unit2_available => p_pqh_budget_periods_rec.budget_unit2_available
1461: ,p_budget_unit3_available => p_pqh_budget_periods_rec.budget_unit3_available
1462: ,p_object_version_number => l_object_version_number

Line 1459: ,p_budget_unit1_available => p_pqh_budget_periods_rec.budget_unit1_available

1455: ,p_budget_unit3_value => p_pqh_budget_periods_rec.budget_unit3_value
1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd
1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd
1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd
1459: ,p_budget_unit1_available => p_pqh_budget_periods_rec.budget_unit1_available
1460: ,p_budget_unit2_available => p_pqh_budget_periods_rec.budget_unit2_available
1461: ,p_budget_unit3_available => p_pqh_budget_periods_rec.budget_unit3_available
1462: ,p_object_version_number => l_object_version_number
1463: );

Line 1460: ,p_budget_unit2_available => p_pqh_budget_periods_rec.budget_unit2_available

1456: ,p_budget_unit1_value_type_cd => p_pqh_budget_periods_rec.budget_unit1_value_type_cd
1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd
1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd
1459: ,p_budget_unit1_available => p_pqh_budget_periods_rec.budget_unit1_available
1460: ,p_budget_unit2_available => p_pqh_budget_periods_rec.budget_unit2_available
1461: ,p_budget_unit3_available => p_pqh_budget_periods_rec.budget_unit3_available
1462: ,p_object_version_number => l_object_version_number
1463: );
1464:

Line 1461: ,p_budget_unit3_available => p_pqh_budget_periods_rec.budget_unit3_available

1457: ,p_budget_unit2_value_type_cd => p_pqh_budget_periods_rec.budget_unit2_value_type_cd
1458: ,p_budget_unit3_value_type_cd => p_pqh_budget_periods_rec.budget_unit3_value_type_cd
1459: ,p_budget_unit1_available => p_pqh_budget_periods_rec.budget_unit1_available
1460: ,p_budget_unit2_available => p_pqh_budget_periods_rec.budget_unit2_available
1461: ,p_budget_unit3_available => p_pqh_budget_periods_rec.budget_unit3_available
1462: ,p_object_version_number => l_object_version_number
1463: );
1464:
1465:

Line 1482: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,

1478:
1479: PROCEDURE carry_forward_budget_sets
1480: (
1481: p_pqh_budget_sets_rec IN pqh_budget_sets%ROWTYPE,
1482: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
1483: p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE
1484: )
1485: IS
1486: -- local variables and cursors

Line 1489: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1485: IS
1486: -- local variables and cursors
1487:
1488: l_proc varchar2(72) := g_package||'carry_forward_budget_sets';
1489: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1490:
1491: BEGIN
1492:
1493: hr_utility.set_location('Entering: '||l_proc, 5);

Line 1543: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1539:
1540: -- local variables and cursors
1541:
1542: l_proc varchar2(72) := g_package||'carry_forward_budget_elements';
1543: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1544:
1545: BEGIN
1546:
1547: hr_utility.set_location('Entering: '||l_proc, 5);

Line 1584: l_object_version_number pqh_budget_periods.object_version_number%TYPE;

1580: IS
1581: -- local variables and cursors
1582:
1583: l_proc varchar2(72) := g_package||'carry_forward_budget_fund_srcs';
1584: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1585:
1586: BEGIN
1587:
1588: hr_utility.set_location('Entering: '||l_proc, 5);

Line 1631: FROM pqh_worksheets wks, pqh_worksheet_details wdt ,pqh_budget_periods bpr

1627: -- local variables and cursors
1628:
1629: CURSOR budget_period_id_cur IS
1630: SELECT bpr.budget_period_id
1631: FROM pqh_worksheets wks, pqh_worksheet_details wdt ,pqh_budget_periods bpr
1632: WHERE wks.worksheet_id = wdt.worksheet_id
1633: AND wdt.action_cd = 'B'
1634: AND wdt.budget_detail_id = bpr.budget_detail_id
1635: AND wks.worksheet_id = p_worksheet_id;

Line 1639: FROM pqh_budget_sets bst, pqh_budget_periods bpr, pqh_budget_details bdt,

1635: AND wks.worksheet_id = p_worksheet_id;
1636:
1637: CURSOR budget_set_id_cur IS
1638: SELECT bst.budget_set_id
1639: FROM pqh_budget_sets bst, pqh_budget_periods bpr, pqh_budget_details bdt,
1640: pqh_worksheet_details wdt , pqh_worksheets wks
1641: WHERE bst.budget_period_id = bpr.budget_period_id
1642: AND bpr.budget_detail_id = wdt.budget_detail_id
1643: AND wks.worksheet_id = wdt.worksheet_id

Line 1650: pqh_budget_periods bpr,

1646:
1647: CURSOR budget_element_id_cur IS
1648: SELECT bel.budget_element_id
1649: FROM pqh_budget_elements bel, pqh_budget_sets bst,
1650: pqh_budget_periods bpr,
1651: pqh_worksheet_details wdt , pqh_worksheets wks
1652: WHERE bel.budget_set_id = bst.budget_set_id
1653: AND bst.budget_period_id = bpr.budget_period_id
1654: AND bpr.budget_detail_id = wdt.budget_detail_id

Line 1662: pqh_budget_periods bpr,

1658:
1659: CURSOR budget_fund_src_id_cur IS
1660: SELECT bfs.budget_fund_src_id
1661: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel, pqh_budget_sets bst,
1662: pqh_budget_periods bpr,
1663: pqh_worksheet_details wdt , pqh_worksheets wks
1664: WHERE bfs.budget_element_id = bel.budget_element_id
1665: AND bel.budget_set_id = bst.budget_set_id
1666: AND bst.budget_period_id = bpr.budget_period_id

Line 1673: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;

1669: AND wdt.action_cd = 'B'
1670: AND wks.worksheet_id = p_worksheet_id;
1671:
1672: l_proc varchar2(72) := g_package||'delete_child_rows';
1673: l_budget_period_id pqh_budget_periods.budget_period_id%TYPE;
1674: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;
1675: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;
1676: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1677:

Line 1716: -- delete from pqh_budget_periods

1712: WHERE budget_set_id = l_budget_set_id;
1713: END LOOP;
1714: CLOSE budget_set_id_cur;
1715:
1716: -- delete from pqh_budget_periods
1717: OPEN budget_period_id_cur;
1718: LOOP
1719: FETCH budget_period_id_cur INTO l_budget_period_id;
1720: EXIT WHEN budget_period_id_cur%NOTFOUND;

Line 1721: DELETE from pqh_budget_periods

1717: OPEN budget_period_id_cur;
1718: LOOP
1719: FETCH budget_period_id_cur INTO l_budget_period_id;
1720: EXIT WHEN budget_period_id_cur%NOTFOUND;
1721: DELETE from pqh_budget_periods
1722: WHERE budget_period_id = l_budget_period_id;
1723: END LOOP;
1724: CLOSE budget_period_id_cur;
1725: