4:
5: PROCEDURE apply_budget
6: (
7: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
8: p_budget_version_id OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE
9: );
10:
11: PROCEDURE apply_new_budget
12: (
26:
27: PROCEDURE carry_forward_budget
28: (
29: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
30: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE
31: );
32:
33: PROCEDURE populate_budget_versions
34: (
34: (
35: p_worksheets_rec IN pqh_worksheets%ROWTYPE,
36: p_budget_id IN pqh_budgets.budget_id%TYPE,
37: p_worksheet_mode_cd IN pqh_worksheets.worksheet_mode_cd%TYPE,
38: p_budget_version_id_o OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE
39: );
40:
41: PROCEDURE populate_budget_details
42: (
40:
41: PROCEDURE populate_budget_details
42: (
43: p_worksheet_details_rec IN pqh_worksheet_details%ROWTYPE,
44: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
45: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
46: p_worksheet_mode_cd IN pqh_worksheets.worksheet_mode_cd%TYPE,
47: p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE
48: );
77:
78: PROCEDURE carry_forward_budget_details
79: (
80: p_pqh_budget_details_rec IN pqh_budget_details%ROWTYPE,
81: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
82: p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE
83: );
84:
85: PROCEDURE carry_forward_budget_periods
167:
168:
169: PROCEDURE comp_bgt_ver_unit_val
170: (
171: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE
172: ) ;
173:
174:
175: PROCEDURE updt_budget_status