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_ELEMENTS

Line 50: FROM per_budget_elements

46: WHERE budget_id = p_budget_id;
47:
48: CURSOR per_budget_elmnt_cur (p_budget_version_id IN per_budget_versions.budget_version_id%TYPE) IS
49: SELECT *
50: FROM per_budget_elements
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 *

Line 53: CURSOR per_budget_val_cur (p_budget_element_id IN per_budget_elements.budget_element_id%TYPE) IS

49: SELECT *
50: FROM per_budget_elements
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:

Line 65: l_per_budget_elmnt_rec per_budget_elements%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;
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;

Line 316: per_budget_elements ele,

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
320: AND ver.budget_id = p_per_budgets_rec.budget_id

Line 340: FROM per_budget_elements ele,

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
342: WHERE ele.budget_version_id = ver.budget_version_id
343: AND ver.budget_id = p_per_budgets_rec.budget_id
344: );

Line 468: FROM per_budget_elements

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);
470:
471: BEGIN
472:

Line 520: p_per_budget_elmnt_rec IN per_budget_elements%ROWTYPE,

516: --------------------------------------------------------------------------------------------------------------
517:
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

Line 1156: -- table_route_id for per_budget_elements

1152: OPEN csr_table_route (p_table_alias => 'P_BVR');
1153: FETCH csr_table_route INTO g_table_route_id_p_bvr;
1154: CLOSE csr_table_route;
1155:
1156: -- table_route_id for per_budget_elements
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:

Line 1303: p_budget_element_id IN per_budget_elements.budget_element_id%TYPE,

1299:
1300: --------------------------------------------------------------------------------------------------------------
1301: PROCEDURE set_p_bdt_log_context
1302: (
1303: p_budget_element_id IN per_budget_elements.budget_element_id%TYPE,
1304: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
1305: ) IS
1306: /*
1307: This procedure will set the log_context at per budgets level

Line 1311: l_budget_elements_rec per_budget_elements%ROWTYPE;

1307: This procedure will set the log_context at per budgets level
1308: Display Order is P J O G ( which ever is not null
1309: */
1310: l_proc varchar2(72) := g_package||'set_p_bdt_log_context';
1311: l_budget_elements_rec per_budget_elements%ROWTYPE;
1312: l_position_name hr_all_positions.name%TYPE;
1313: l_job_name per_jobs.name%TYPE;
1314: l_organization_name hr_all_organization_units_tl.name%TYPE;
1315: l_grade_name per_grades.name%TYPE;

Line 1319: FROM per_budget_elements

1315: l_grade_name per_grades.name%TYPE;
1316:
1317: CURSOR csr_bdg_elmnt_rec IS
1318: SELECT *
1319: FROM per_budget_elements
1320: WHERE budget_element_id = p_budget_element_id ;
1321:
1322: BEGIN
1323:

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 1511: FROM per_budget_elements

1507:
1508:
1509: CURSOR cnt_elements IS
1510: SELECT COUNT(budget_element_id)
1511: FROM per_budget_elements
1512: WHERE budget_version_id IN
1513: ( SELECT budget_version_id
1514: FROM per_budget_versions
1515: WHERE budget_id = p_per_budgets_rec.budget_id

Line 1523: FROM per_budget_elements

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
1525: ( SELECT budget_version_id
1526: FROM per_budget_versions
1527: WHERE budget_id = p_per_budgets_rec.budget_id