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_SETS

Line 296: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;

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;
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;

Line 427: -- create records in pqh_budget_sets

423: p_log_context => l_log_context
424: );
425:
426:
427: -- create records in pqh_budget_sets
428: populate_budget_sets
429: (
430: p_worksheet_budget_sets_rec => l_pqh_worksheet_budget_set_rec,
431: p_budget_period_id => l_budget_period_id,

Line 1032: p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE

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

Line 1047: pqh_budget_sets_api.create_budget_set

1043:
1044: IF p_budget_period_id IS NOT NULL THEN
1045:
1046: -- call insert API
1047: pqh_budget_sets_api.create_budget_set
1048: (
1049: p_validate => false
1050: ,p_budget_set_id => p_budget_set_id_o
1051: ,p_dflt_budget_set_id => p_worksheet_budget_sets_rec.dflt_budget_set_id

Line 1092: p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,

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

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 1219: FROM pqh_budget_sets

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:
1222: CURSOR pqh_budget_elements_cur (p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE) IS
1223: SELECT *

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 1247: l_pqh_budget_sets_rec pqh_budget_sets%ROWTYPE;

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;
1251: l_pqh_budget_fund_srcs_rec pqh_budget_fund_srcs%ROWTYPE;

Line 1248: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;

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;
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;

Line 1299: -- open pqh_budget_sets_cur

1295: p_budget_detail_id => l_budget_detail_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;

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 1302: FETCH pqh_budget_sets_cur INTO l_pqh_budget_sets_rec;

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
1305: carry_forward_budget_sets
1306: (

Line 1303: EXIT WHEN pqh_budget_sets_cur%NOTFOUND;

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
1305: carry_forward_budget_sets
1306: (
1307: p_pqh_budget_sets_rec => l_pqh_budget_sets_rec,

Line 1304: -- create records in pqh_budget_sets

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
1305: carry_forward_budget_sets
1306: (
1307: p_pqh_budget_sets_rec => l_pqh_budget_sets_rec,
1308: p_budget_period_id => l_budget_period_id,

Line 1307: p_pqh_budget_sets_rec => l_pqh_budget_sets_rec,

1303: EXIT WHEN pqh_budget_sets_cur%NOTFOUND;
1304: -- create records in pqh_budget_sets
1305: carry_forward_budget_sets
1306: (
1307: p_pqh_budget_sets_rec => l_pqh_budget_sets_rec,
1308: p_budget_period_id => l_budget_period_id,
1309: p_budget_set_id_o => l_budget_set_id
1310: );
1311:

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 1346: CLOSE pqh_budget_sets_cur;

1342: END LOOP; -- loop 5
1343: CLOSE pqh_budget_elements_cur;
1344:
1345: END LOOP; -- loop 4
1346: CLOSE pqh_budget_sets_cur;
1347:
1348: END LOOP; -- loop 3
1349: CLOSE pqh_budget_periods_cur;
1350:

Line 1481: p_pqh_budget_sets_rec IN pqh_budget_sets%ROWTYPE,

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

Line 1483: p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE

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

Line 1498: pqh_budget_sets_api.create_budget_set

1494:
1495: IF p_budget_period_id IS NOT NULL THEN
1496:
1497: -- call insert API
1498: pqh_budget_sets_api.create_budget_set
1499: (
1500: p_validate => false
1501: ,p_budget_set_id => p_budget_set_id_o
1502: ,p_dflt_budget_set_id => p_pqh_budget_sets_rec.dflt_budget_set_id

Line 1502: ,p_dflt_budget_set_id => p_pqh_budget_sets_rec.dflt_budget_set_id

1498: pqh_budget_sets_api.create_budget_set
1499: (
1500: p_validate => false
1501: ,p_budget_set_id => p_budget_set_id_o
1502: ,p_dflt_budget_set_id => p_pqh_budget_sets_rec.dflt_budget_set_id
1503: ,p_budget_period_id => p_budget_period_id
1504: ,p_budget_unit1_percent => p_pqh_budget_sets_rec.budget_unit1_percent
1505: ,p_budget_unit2_percent => p_pqh_budget_sets_rec.budget_unit2_percent
1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent

Line 1504: ,p_budget_unit1_percent => p_pqh_budget_sets_rec.budget_unit1_percent

1500: p_validate => false
1501: ,p_budget_set_id => p_budget_set_id_o
1502: ,p_dflt_budget_set_id => p_pqh_budget_sets_rec.dflt_budget_set_id
1503: ,p_budget_period_id => p_budget_period_id
1504: ,p_budget_unit1_percent => p_pqh_budget_sets_rec.budget_unit1_percent
1505: ,p_budget_unit2_percent => p_pqh_budget_sets_rec.budget_unit2_percent
1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent
1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value
1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value

Line 1505: ,p_budget_unit2_percent => p_pqh_budget_sets_rec.budget_unit2_percent

1501: ,p_budget_set_id => p_budget_set_id_o
1502: ,p_dflt_budget_set_id => p_pqh_budget_sets_rec.dflt_budget_set_id
1503: ,p_budget_period_id => p_budget_period_id
1504: ,p_budget_unit1_percent => p_pqh_budget_sets_rec.budget_unit1_percent
1505: ,p_budget_unit2_percent => p_pqh_budget_sets_rec.budget_unit2_percent
1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent
1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value
1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value
1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value

Line 1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent

1502: ,p_dflt_budget_set_id => p_pqh_budget_sets_rec.dflt_budget_set_id
1503: ,p_budget_period_id => p_budget_period_id
1504: ,p_budget_unit1_percent => p_pqh_budget_sets_rec.budget_unit1_percent
1505: ,p_budget_unit2_percent => p_pqh_budget_sets_rec.budget_unit2_percent
1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent
1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value
1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value
1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value
1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available

Line 1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value

1503: ,p_budget_period_id => p_budget_period_id
1504: ,p_budget_unit1_percent => p_pqh_budget_sets_rec.budget_unit1_percent
1505: ,p_budget_unit2_percent => p_pqh_budget_sets_rec.budget_unit2_percent
1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent
1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value
1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value
1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value
1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available
1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available

Line 1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value

1504: ,p_budget_unit1_percent => p_pqh_budget_sets_rec.budget_unit1_percent
1505: ,p_budget_unit2_percent => p_pqh_budget_sets_rec.budget_unit2_percent
1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent
1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value
1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value
1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value
1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available
1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available
1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available

Line 1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value

1505: ,p_budget_unit2_percent => p_pqh_budget_sets_rec.budget_unit2_percent
1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent
1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value
1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value
1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value
1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available
1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available
1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available
1513: ,p_object_version_number => l_object_version_number

Line 1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available

1506: ,p_budget_unit3_percent => p_pqh_budget_sets_rec.budget_unit3_percent
1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value
1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value
1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value
1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available
1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available
1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available
1513: ,p_object_version_number => l_object_version_number
1514: ,p_budget_unit1_value_type_cd => p_pqh_budget_sets_rec.budget_unit1_value_type_cd

Line 1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available

1507: ,p_budget_unit1_value => p_pqh_budget_sets_rec.budget_unit1_value
1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value
1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value
1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available
1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available
1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available
1513: ,p_object_version_number => l_object_version_number
1514: ,p_budget_unit1_value_type_cd => p_pqh_budget_sets_rec.budget_unit1_value_type_cd
1515: ,p_budget_unit2_value_type_cd => p_pqh_budget_sets_rec.budget_unit2_value_type_cd

Line 1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available

1508: ,p_budget_unit2_value => p_pqh_budget_sets_rec.budget_unit2_value
1509: ,p_budget_unit3_value => p_pqh_budget_sets_rec.budget_unit3_value
1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available
1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available
1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available
1513: ,p_object_version_number => l_object_version_number
1514: ,p_budget_unit1_value_type_cd => p_pqh_budget_sets_rec.budget_unit1_value_type_cd
1515: ,p_budget_unit2_value_type_cd => p_pqh_budget_sets_rec.budget_unit2_value_type_cd
1516: ,p_budget_unit3_value_type_cd => p_pqh_budget_sets_rec.budget_unit3_value_type_cd

Line 1514: ,p_budget_unit1_value_type_cd => p_pqh_budget_sets_rec.budget_unit1_value_type_cd

1510: ,p_budget_unit1_available => p_pqh_budget_sets_rec.budget_unit1_available
1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available
1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available
1513: ,p_object_version_number => l_object_version_number
1514: ,p_budget_unit1_value_type_cd => p_pqh_budget_sets_rec.budget_unit1_value_type_cd
1515: ,p_budget_unit2_value_type_cd => p_pqh_budget_sets_rec.budget_unit2_value_type_cd
1516: ,p_budget_unit3_value_type_cd => p_pqh_budget_sets_rec.budget_unit3_value_type_cd
1517: ,p_effective_date => sysdate
1518: );

Line 1515: ,p_budget_unit2_value_type_cd => p_pqh_budget_sets_rec.budget_unit2_value_type_cd

1511: ,p_budget_unit2_available => p_pqh_budget_sets_rec.budget_unit2_available
1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available
1513: ,p_object_version_number => l_object_version_number
1514: ,p_budget_unit1_value_type_cd => p_pqh_budget_sets_rec.budget_unit1_value_type_cd
1515: ,p_budget_unit2_value_type_cd => p_pqh_budget_sets_rec.budget_unit2_value_type_cd
1516: ,p_budget_unit3_value_type_cd => p_pqh_budget_sets_rec.budget_unit3_value_type_cd
1517: ,p_effective_date => sysdate
1518: );
1519:

Line 1516: ,p_budget_unit3_value_type_cd => p_pqh_budget_sets_rec.budget_unit3_value_type_cd

1512: ,p_budget_unit3_available => p_pqh_budget_sets_rec.budget_unit3_available
1513: ,p_object_version_number => l_object_version_number
1514: ,p_budget_unit1_value_type_cd => p_pqh_budget_sets_rec.budget_unit1_value_type_cd
1515: ,p_budget_unit2_value_type_cd => p_pqh_budget_sets_rec.budget_unit2_value_type_cd
1516: ,p_budget_unit3_value_type_cd => p_pqh_budget_sets_rec.budget_unit3_value_type_cd
1517: ,p_effective_date => sysdate
1518: );
1519:
1520: END IF; -- p_budget_period_id is not null

Line 1535: p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,

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

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 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 1674: l_budget_set_id pqh_budget_sets.budget_set_id%TYPE;

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

Line 1705: -- delete from pqh_budget_sets

1701: WHERE budget_element_id = l_budget_element_id;
1702: END LOOP;
1703: CLOSE budget_element_id_cur;
1704:
1705: -- delete from pqh_budget_sets
1706:
1707: OPEN budget_set_id_cur;
1708: LOOP
1709: FETCH budget_set_id_cur INTO l_budget_set_id;

Line 1711: DELETE from pqh_budget_sets

1707: OPEN budget_set_id_cur;
1708: LOOP
1709: FETCH budget_set_id_cur INTO l_budget_set_id;
1710: EXIT WHEN budget_set_id_cur%NOTFOUND;
1711: DELETE from pqh_budget_sets
1712: WHERE budget_set_id = l_budget_set_id;
1713: END LOOP;
1714: CLOSE budget_set_id_cur;
1715: