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 PER_BUDGET_VALUES

Line 55: FROM per_budget_values

51: WHERE budget_version_id = p_budget_version_id;
52:
53: CURSOR per_budget_val_cur (p_budget_element_id IN per_budget_elements.budget_element_id%TYPE) IS
54: SELECT *
55: FROM per_budget_values
56: WHERE budget_element_id = p_budget_element_id;
57:
58:
59: l_proc varchar2(72) := g_package||'extract_data';

Line 62: l_tot_budget_val per_budget_values.value%TYPE;

58:
59: l_proc varchar2(72) := g_package||'extract_data';
60: l_per_budget_rec per_budgets%ROWTYPE;
61: l_budget_id pqh_budgets.budget_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;

Line 68: l_per_budget_val_rec per_budget_values%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);
72:

Line 290: p_tot_budget_val_o OUT NOCOPY per_budget_values.value%TYPE

286: (
287: p_per_budgets_rec IN per_budgets%ROWTYPE,
288: p_valid IN varchar2,
289: p_budget_id_o OUT NOCOPY pqh_budgets.budget_id%TYPE,
290: p_tot_budget_val_o OUT NOCOPY per_budget_values.value%TYPE
291: )
292: IS
293: -- local variables and cursors
294:

Line 301: l_tot_budget_val per_budget_values.value%TYPE;

297: l_budget_style_cd pqh_budgets.budget_style_cd%TYPE := 'BOTTOM';
298: l_budget_start_date pqh_budgets.budget_start_date%TYPE;
299: l_budget_end_date pqh_budgets.budget_end_date%TYPE;
300: l_object_version_number pqh_budgets.object_version_number%TYPE;
301: l_tot_budget_val per_budget_values.value%TYPE;
302: l_shared_type_id pqh_budgets.budget_unit1_id%TYPE;
303: l_status pqh_budgets.status%TYPE;
304: l_budget_unit1_aggregate pqh_budgets.budget_unit1_aggregate%TYPE := 'ACCUMULATE';
305:

Line 315: FROM per_budget_values val,

311: FROM per_time_periods
312: WHERE time_period_id IN
313: (
314: SELECT val.time_period_id
315: FROM per_budget_values val,
316: per_budget_elements ele,
317: per_budget_versions ver
318: WHERE val.budget_element_id = ele.budget_element_id
319: AND ele.budget_version_id = ver.budget_version_id

Line 325: -- in per_budget_values

321: );
322:
323:
324: -- cursor to compute budget start and end dates for budget with no child records
325: -- in per_budget_values
326:
327: CURSOR budget_cal_cur IS
328: SELECT start_date, start_date
329: FROM pay_calendars

Line 337: FROM per_budget_values

333: -- this is used to compute the percentage at detail level
334:
335: CURSOR tot_unit1_val_cur IS
336: SELECT SUM(value)
337: FROM per_budget_values
338: WHERE budget_element_id IN
339: ( SELECT ele.budget_element_id
340: FROM per_budget_elements ele,
341: per_budget_versions ver

Line 355: Start date is the minimum date in per_budget_values for the current budget_id

351: IF p_valid = 'Y' THEN
352:
353: -- compute the budget start and end date
354: /*
355: Start date is the minimum date in per_budget_values for the current budget_id
356: End date is the maximum date in per_budget_values for the current budget_id
357: If the budget has no records in per_budget_values then we get the start and end date
358: for the calender
359: */

Line 356: End date is the maximum date in per_budget_values for the current budget_id

352:
353: -- compute the budget start and end date
354: /*
355: Start date is the minimum date in per_budget_values for the current budget_id
356: End date is the maximum date in per_budget_values for the current budget_id
357: If the budget has no records in per_budget_values then we get the start and end date
358: for the calender
359: */
360:

Line 357: If the budget has no records in per_budget_values then we get the start and end date

353: -- compute the budget start and end date
354: /*
355: Start date is the minimum date in per_budget_values for the current budget_id
356: End date is the maximum date in per_budget_values for the current budget_id
357: If the budget has no records in per_budget_values then we get the start and end date
358: for the calender
359: */
360:
361: OPEN budget_date_cur;

Line 465: FROM per_budget_values val

461:
462: -- cursor for unit1_value
463: CURSOR unit1_val_cur IS
464: SELECT SUM(val.value)
465: FROM per_budget_values val
466: WHERE budget_element_id IN
467: ( SELECT DISTINCT budget_element_id
468: FROM per_budget_elements
469: WHERE budget_version_id = p_per_budget_ver_rec.budget_version_id);

Line 522: p_tot_budget_val IN per_budget_values.value%TYPE,

518: PROCEDURE populate_budget_details
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

Line 539: FROM per_budget_values val

535:
536: -- cursor for unit1_value
537: CURSOR unit1_val_cur IS
538: SELECT SUM(val.value)
539: FROM per_budget_values val
540: WHERE budget_element_id = p_per_budget_elmnt_rec.budget_element_id;
541:
542:
543: BEGIN

Line 604: p_per_budget_val_rec IN per_budget_values%ROWTYPE,

600: --------------------------------------------------------------------------------------------------------------
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: )

Line 1161: -- table_route_id for per_budget_values

1157: OPEN csr_table_route (p_table_alias => 'P_BDT');
1158: FETCH csr_table_route INTO g_table_route_id_p_bdt;
1159: CLOSE csr_table_route;
1160:
1161: -- table_route_id for per_budget_values
1162: OPEN csr_table_route (p_table_alias => 'P_BPR');
1163: FETCH csr_table_route INTO g_table_route_id_p_bpr;
1164: CLOSE csr_table_route;
1165:

Line 1368: p_budget_value_id IN per_budget_values.budget_value_id%TYPE,

1364:
1365: --------------------------------------------------------------------------------------------------------------
1366: PROCEDURE set_p_bpr_log_context
1367: (
1368: p_budget_value_id IN per_budget_values.budget_value_id%TYPE,
1369: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
1370: ) IS
1371: /*
1372: This procedure will set the log_context at per budgets level

Line 1376: l_per_budget_values_rec per_budget_values%ROWTYPE;

1372: This procedure will set the log_context at per budgets level
1373: */
1374:
1375: l_proc varchar2(72) := g_package||'set_p_bpr_log_context';
1376: l_per_budget_values_rec per_budget_values%ROWTYPE;
1377: l_per_time_periods_rec per_time_periods%ROWTYPE;
1378:
1379: CURSOR csr_bpr_periods_rec IS
1380: SELECT *

Line 1381: FROM per_budget_values

1377: l_per_time_periods_rec per_time_periods%ROWTYPE;
1378:
1379: CURSOR csr_bpr_periods_rec IS
1380: SELECT *
1381: FROM per_budget_values
1382: WHERE budget_value_id = p_budget_value_id ;
1383:
1384: CURSOR csr_per_time_periods ( p_time_period_id IN number ) IS
1385: SELECT *

Line 1395: FETCH csr_bpr_periods_rec INTO l_per_budget_values_rec;

1391:
1392: hr_utility.set_location('Entering:'||l_proc, 5);
1393:
1394: OPEN csr_bpr_periods_rec;
1395: FETCH csr_bpr_periods_rec INTO l_per_budget_values_rec;
1396: CLOSE csr_bpr_periods_rec;
1397:
1398: OPEN csr_per_time_periods(p_time_period_id => l_per_budget_values_rec.time_period_id);
1399: FETCH csr_per_time_periods INTO l_per_time_periods_rec;

Line 1398: OPEN csr_per_time_periods(p_time_period_id => l_per_budget_values_rec.time_period_id);

1394: OPEN csr_bpr_periods_rec;
1395: FETCH csr_bpr_periods_rec INTO l_per_budget_values_rec;
1396: CLOSE csr_bpr_periods_rec;
1397:
1398: OPEN csr_per_time_periods(p_time_period_id => l_per_budget_values_rec.time_period_id);
1399: FETCH csr_per_time_periods INTO l_per_time_periods_rec;
1400: CLOSE csr_per_time_periods;
1401:
1402: -- set log context

Line 1498: records in per_budget_elements which do not have child records in per_budget_values

1494: p_valid OUT NOCOPY varchar2
1495: ) IS
1496: /*
1497: This procedure validates if the budget is valid. For budget to be valid there must be no
1498: records in per_budget_elements which do not have child records in per_budget_values
1499: If it is not valid we set p_valid = N so that we can skip this budget migration and give the
1500: error message
1501: */
1502:

Line 1520: FROM per_budget_values

1516: );
1517:
1518: CURSOR cnt_values IS
1519: SELECT COUNT(distinct budget_element_id)
1520: FROM per_budget_values
1521: WHERE budget_element_id IN
1522: ( SELECT budget_element_id
1523: FROM per_budget_elements
1524: WHERE budget_version_id IN