APPS.PQH_APPLY_BUDGET dependencies on PQH_WORKSHEETS

Line 7: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,

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

Line 13: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,

9: );
10:
11: PROCEDURE apply_new_budget
12: (
13: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
14: p_mode IN varchar2
15: );
16:
17: PROCEDURE edit_create_new_budget

Line 19: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE

15: );
16:
17: PROCEDURE edit_create_new_budget
18: (
19: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
20: );
21:
22: PROCEDURE edit_update_budget
23: (

Line 24: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE

20: );
21:
22: PROCEDURE edit_update_budget
23: (
24: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
25: );
26:
27: PROCEDURE carry_forward_budget
28: (

Line 29: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,

25: );
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

Line 35: p_worksheets_rec IN pqh_worksheets%ROWTYPE,

31: );
32:
33: PROCEDURE populate_budget_versions
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: );

Line 37: p_worksheet_mode_cd IN pqh_worksheets.worksheet_mode_cd%TYPE,

33: PROCEDURE populate_budget_versions
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

Line 45: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,

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: );
49:

Line 46: p_worksheet_mode_cd IN pqh_worksheets.worksheet_mode_cd%TYPE,

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: );
49:
50: PROCEDURE populate_budget_periods

Line 115: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE

111: );
112:
113: PROCEDURE delete_child_rows
114: (
115: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
116: );
117:
118: PROCEDURE check_valid_mode
119: (

Line 120: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE

116: );
117:
118: PROCEDURE check_valid_mode
119: (
120: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
121: );
122:
123:
124: PROCEDURE populate_globals

Line 126: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE

122:
123:
124: PROCEDURE populate_globals
125: (
126: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE
127: );
128:
129:
130: PROCEDURE set_wks_log_context

Line 182: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,

178: );
179:
180: PROCEDURE updt_wks_status
181: (
182: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
183: p_status IN pqh_worksheets.transaction_status%TYPE
184: );
185:
186: FUNCTION get_txn_state

Line 183: p_status IN pqh_worksheets.transaction_status%TYPE

179:
180: PROCEDURE updt_wks_status
181: (
182: p_worksheet_id IN pqh_worksheets.worksheet_id%TYPE,
183: p_status IN pqh_worksheets.transaction_status%TYPE
184: );
185:
186: FUNCTION get_txn_state
187: (

Line 256: p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,

252:
253: FUNCTION set_status
254: (
255: p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,
256: p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,
257: p_status IN pqh_worksheets.transaction_status%TYPE
258: ) RETURN varchar2;
259:
260: ---------------------------------------------------------

Line 257: p_status IN pqh_worksheets.transaction_status%TYPE

253: FUNCTION set_status
254: (
255: p_transaction_category_id IN pqh_transaction_categories.transaction_category_id%TYPE,
256: p_transaction_id IN pqh_worksheets.worksheet_id%TYPE,
257: p_status IN pqh_worksheets.transaction_status%TYPE
258: ) RETURN varchar2;
259:
260: ---------------------------------------------------------
261: