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_ELEMENTS

Line 298: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;

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;
299: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
300: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
301: l_curr_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
302: l_log_context pqh_process_log.log_context%TYPE;

Line 457: -- create records in pqh_budget_elements

453: p_level => 5,
454: p_log_context => l_log_context
455: );
456:
457: -- create records in pqh_budget_elements
458: populate_budget_elements
459: (
460: p_worksheet_bdgt_elmnts_rec => l_pqh_worksheet_bdgt_elmnt_rec,
461: p_budget_set_id => l_budget_set_id,

Line 1093: p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE

1089: PROCEDURE populate_budget_elements
1090: (
1091: p_worksheet_bdgt_elmnts_rec IN pqh_worksheet_bdgt_elmnts%ROWTYPE,
1092: p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,
1093: p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE
1094: )
1095: IS
1096:
1097: -- local variables and cursors

Line 1109: pqh_budget_elements_api.create_budget_element

1105:
1106: IF p_budget_set_id IS NOT NULL THEN
1107:
1108: -- call insert API
1109: pqh_budget_elements_api.create_budget_element
1110: (
1111: p_validate => false
1112: ,p_budget_element_id => p_budget_element_id_o
1113: ,p_budget_set_id => p_budget_set_id

Line 1140: p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,

1136: --------------------------------------------------------------------------------------------------------------
1137: PROCEDURE populate_budget_fund_srcs
1138: (
1139: p_worksheet_fund_srcs_rec IN pqh_worksheet_fund_srcs%ROWTYPE,
1140: p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,
1141: p_budget_fund_src_id_o OUT NOCOPY pqh_budget_fund_srcs.budget_fund_src_id%TYPE
1142: )
1143: IS
1144: -- local variables and cursors

Line 1222: CURSOR pqh_budget_elements_cur (p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE) IS

1218: SELECT *
1219: FROM pqh_budget_sets
1220: WHERE budget_period_id = p_budget_period_id;
1221:
1222: CURSOR pqh_budget_elements_cur (p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE) IS
1223: SELECT *
1224: FROM pqh_budget_elements
1225: WHERE budget_set_id = p_budget_set_id;
1226:

Line 1224: FROM pqh_budget_elements

1220: WHERE budget_period_id = p_budget_period_id;
1221:
1222: CURSOR pqh_budget_elements_cur (p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE) IS
1223: SELECT *
1224: FROM pqh_budget_elements
1225: WHERE budget_set_id = p_budget_set_id;
1226:
1227: CURSOR pqh_budget_fund_srcs_cur (p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE) IS
1228: SELECT *

Line 1227: CURSOR pqh_budget_fund_srcs_cur (p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE) IS

1223: SELECT *
1224: FROM pqh_budget_elements
1225: WHERE budget_set_id = p_budget_set_id;
1226:
1227: CURSOR pqh_budget_fund_srcs_cur (p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE) IS
1228: SELECT *
1229: FROM pqh_budget_fund_srcs
1230: WHERE budget_element_id = p_budget_element_id;
1231:

Line 1249: l_pqh_budget_elements_rec pqh_budget_elements%ROWTYPE;

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;
1251: l_pqh_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;
1252: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1253: l_curr_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

Line 1250: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;

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;
1251: l_pqh_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;
1252: l_budget_fund_src_id pqh_budget_fund_srcs.budget_fund_src_id%TYPE;
1253: l_curr_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1254:

Line 1312: -- open pqh_budget_elements_cur

1308: p_budget_period_id => l_budget_period_id,
1309: p_budget_set_id_o => l_budget_set_id
1310: );
1311:
1312: -- open pqh_budget_elements_cur
1313: OPEN pqh_budget_elements_cur(p_budget_set_id => l_pqh_budget_sets_rec.budget_set_id);
1314: LOOP -- loop 5
1315: FETCH pqh_budget_elements_cur INTO l_pqh_budget_elements_rec;
1316: EXIT WHEN pqh_budget_elements_cur%NOTFOUND;

Line 1313: OPEN pqh_budget_elements_cur(p_budget_set_id => l_pqh_budget_sets_rec.budget_set_id);

1309: p_budget_set_id_o => l_budget_set_id
1310: );
1311:
1312: -- open pqh_budget_elements_cur
1313: OPEN pqh_budget_elements_cur(p_budget_set_id => l_pqh_budget_sets_rec.budget_set_id);
1314: LOOP -- loop 5
1315: FETCH pqh_budget_elements_cur INTO l_pqh_budget_elements_rec;
1316: EXIT WHEN pqh_budget_elements_cur%NOTFOUND;
1317: -- create records in pqh_budget_elements

Line 1315: FETCH pqh_budget_elements_cur INTO l_pqh_budget_elements_rec;

1311:
1312: -- open pqh_budget_elements_cur
1313: OPEN pqh_budget_elements_cur(p_budget_set_id => l_pqh_budget_sets_rec.budget_set_id);
1314: LOOP -- loop 5
1315: FETCH pqh_budget_elements_cur INTO l_pqh_budget_elements_rec;
1316: EXIT WHEN pqh_budget_elements_cur%NOTFOUND;
1317: -- create records in pqh_budget_elements
1318: carry_forward_budget_elements
1319: (

Line 1316: EXIT WHEN pqh_budget_elements_cur%NOTFOUND;

1312: -- open pqh_budget_elements_cur
1313: OPEN pqh_budget_elements_cur(p_budget_set_id => l_pqh_budget_sets_rec.budget_set_id);
1314: LOOP -- loop 5
1315: FETCH pqh_budget_elements_cur INTO l_pqh_budget_elements_rec;
1316: EXIT WHEN pqh_budget_elements_cur%NOTFOUND;
1317: -- create records in pqh_budget_elements
1318: carry_forward_budget_elements
1319: (
1320: p_pqh_budget_elements_rec => l_pqh_budget_elements_rec,

Line 1317: -- create records in pqh_budget_elements

1313: OPEN pqh_budget_elements_cur(p_budget_set_id => l_pqh_budget_sets_rec.budget_set_id);
1314: LOOP -- loop 5
1315: FETCH pqh_budget_elements_cur INTO l_pqh_budget_elements_rec;
1316: EXIT WHEN pqh_budget_elements_cur%NOTFOUND;
1317: -- create records in pqh_budget_elements
1318: carry_forward_budget_elements
1319: (
1320: p_pqh_budget_elements_rec => l_pqh_budget_elements_rec,
1321: p_budget_set_id => l_budget_set_id,

Line 1320: p_pqh_budget_elements_rec => l_pqh_budget_elements_rec,

1316: EXIT WHEN pqh_budget_elements_cur%NOTFOUND;
1317: -- create records in pqh_budget_elements
1318: carry_forward_budget_elements
1319: (
1320: p_pqh_budget_elements_rec => l_pqh_budget_elements_rec,
1321: p_budget_set_id => l_budget_set_id,
1322: p_budget_element_id_o => l_budget_element_id
1323: );
1324:

Line 1326: OPEN pqh_budget_fund_srcs_cur(p_budget_element_id => l_pqh_budget_elements_rec.budget_element_id);

1322: p_budget_element_id_o => l_budget_element_id
1323: );
1324:
1325: -- open pqh_budget_fund_srcs_cur
1326: OPEN pqh_budget_fund_srcs_cur(p_budget_element_id => l_pqh_budget_elements_rec.budget_element_id);
1327: LOOP -- loop 6
1328: FETCH pqh_budget_fund_srcs_cur INTO l_pqh_budget_fund_srcs_rec;
1329: EXIT WHEN pqh_budget_fund_srcs_cur%NOTFOUND;
1330: -- create records in pqh_budget_fund_srcs

Line 1343: CLOSE pqh_budget_elements_cur;

1339: END LOOP; -- loop 6
1340: CLOSE pqh_budget_fund_srcs_cur;
1341:
1342: END LOOP; -- loop 5
1343: CLOSE pqh_budget_elements_cur;
1344:
1345: END LOOP; -- loop 4
1346: CLOSE pqh_budget_sets_cur;
1347:

Line 1534: p_pqh_budget_elements_rec IN pqh_budget_elements%ROWTYPE,

1530:
1531: --------------------------------------------------------------------------------------------------------------
1532: PROCEDURE carry_forward_budget_elements
1533: (
1534: p_pqh_budget_elements_rec IN pqh_budget_elements%ROWTYPE,
1535: p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,
1536: p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE
1537: )
1538: IS

Line 1536: p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE

1532: PROCEDURE carry_forward_budget_elements
1533: (
1534: p_pqh_budget_elements_rec IN pqh_budget_elements%ROWTYPE,
1535: p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,
1536: p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE
1537: )
1538: IS
1539:
1540: -- local variables and cursors

Line 1552: pqh_budget_elements_api.create_budget_element

1548:
1549: IF p_budget_set_id IS NOT NULL THEN
1550:
1551: -- call insert API
1552: pqh_budget_elements_api.create_budget_element
1553: (
1554: p_validate => false
1555: ,p_budget_element_id => p_budget_element_id_o
1556: ,p_budget_set_id => p_budget_set_id

Line 1557: ,p_element_type_id => p_pqh_budget_elements_rec.element_type_id

1553: (
1554: p_validate => false
1555: ,p_budget_element_id => p_budget_element_id_o
1556: ,p_budget_set_id => p_budget_set_id
1557: ,p_element_type_id => p_pqh_budget_elements_rec.element_type_id
1558: ,p_distribution_percentage => p_pqh_budget_elements_rec.distribution_percentage
1559: ,p_object_version_number => l_object_version_number
1560: );
1561:

Line 1558: ,p_distribution_percentage => p_pqh_budget_elements_rec.distribution_percentage

1554: p_validate => false
1555: ,p_budget_element_id => p_budget_element_id_o
1556: ,p_budget_set_id => p_budget_set_id
1557: ,p_element_type_id => p_pqh_budget_elements_rec.element_type_id
1558: ,p_distribution_percentage => p_pqh_budget_elements_rec.distribution_percentage
1559: ,p_object_version_number => l_object_version_number
1560: );
1561:
1562: END IF; -- p_budget_set_id is not null

Line 1577: p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,

1573: --------------------------------------------------------------------------------------------------------------
1574: PROCEDURE carry_forward_budget_fund_srcs
1575: (
1576: p_pqh_budget_fund_srcs_rec IN pqh_budget_fund_srcs%ROWTYPE,
1577: p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,
1578: p_budget_fund_src_id_o OUT NOCOPY pqh_budget_fund_srcs.budget_fund_src_id%TYPE
1579: )
1580: IS
1581: -- local variables and cursors

Line 1649: FROM pqh_budget_elements bel, pqh_budget_sets bst,

1645: AND wks.worksheet_id = p_worksheet_id;
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

Line 1661: FROM pqh_budget_fund_srcs bfs, pqh_budget_elements bel, pqh_budget_sets bst,

1657: AND wks.worksheet_id = p_worksheet_id;
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

Line 1675: l_budget_element_id pqh_budget_elements.budget_element_id%TYPE;

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:
1678:
1679: BEGIN

Line 1694: -- delete from pqh_budget_elements

1690: WHERE budget_fund_src_id = l_budget_fund_src_id;
1691: END LOOP;
1692: CLOSE budget_fund_src_id_cur;
1693:
1694: -- delete from pqh_budget_elements
1695:
1696: OPEN budget_element_id_cur;
1697: LOOP
1698: FETCH budget_element_id_cur INTO l_budget_element_id;

Line 1700: DELETE from pqh_budget_elements

1696: OPEN budget_element_id_cur;
1697: LOOP
1698: FETCH budget_element_id_cur INTO l_budget_element_id;
1699: EXIT WHEN budget_element_id_cur%NOTFOUND;
1700: DELETE from pqh_budget_elements
1701: WHERE budget_element_id = l_budget_element_id;
1702: END LOOP;
1703: CLOSE budget_element_id_cur;
1704: