1 Package pqh_WORKSHEETS_api as
2 /* $Header: pqwksapi.pkh 120.0 2005/05/29 03:00:59 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_WORKSHEET >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_budget_id Yes number
18 -- p_worksheet_name Yes varchar2
19 -- p_version_number Yes number
20 -- p_action_date Yes date
21 -- p_date_from No date
22 -- p_date_to No date
23 -- p_worksheet_mode_cd No varchar2
24 -- p_transaction_status No varchar2
25 -- p_budget_version_id Yes number
26 -- p_propagation_method No varchar2
27 -- p_effective_date Yes date Session Date.
28 --
29 -- Post Success:
30 --
31 -- Out Parameters:
32 -- Name Type Description
33 -- p_worksheet_id Yes number PK of record
34 -- p_object_version_number Yes number OVN of record
35 --
36 -- Post Failure:
37 --
38 -- Access Status:
39 -- Public.
40 --
41 -- {End Of Comments}
42 --
43 procedure create_WORKSHEET
44 (
45 p_validate in boolean default false
46 ,p_worksheet_id out nocopy number
47 ,p_budget_id in number
48 ,p_worksheet_name in varchar2
49 ,p_version_number in number
50 ,p_action_date in date
51 ,p_date_from in date default null
52 ,p_date_to in date default null
53 ,p_worksheet_mode_cd in varchar2 default null
54 ,p_transaction_status in varchar2 default null
55 ,p_object_version_number out nocopy number
56 ,p_budget_version_id in number
57 ,p_propagation_method in varchar2 default null
58 ,p_effective_date in date
59 ,p_wf_transaction_category_id in number
60 );
61 -- ----------------------------------------------------------------------------
62 -- |------------------------< update_WORKSHEET >------------------------|
63 -- ----------------------------------------------------------------------------
64 -- {Start Of Comments}
65 --
66 -- Description:
67 --
68 -- Prerequisites:
69 --
70 --
71 -- In Parameters:
72 -- Name Reqd Type Description
73 -- p_validate Yes boolean Commit or Rollback.
74 -- p_worksheet_id Yes number PK of record
75 -- p_budget_id Yes number
76 -- p_worksheet_name Yes varchar2
77 -- p_version_number Yes number
78 -- p_action_date Yes date
79 -- p_date_from No date
80 -- p_date_to No date
81 -- p_worksheet_mode_cd No varchar2
82 -- p_transaction_status No varchar2
83 -- p_budget_version_id Yes number
84 -- p_propagation_method No varchar2
85 -- p_effective_date Yes date Session Date.
86 --
87 -- Post Success:
88 --
89 -- Name Type Description
90 -- p_object_version_number Yes number OVN of record
91 --
92 -- Post Failure:
93 --
94 -- Access Status:
95 -- Public.
96 --
97 -- {End Of Comments}
98 --
99 procedure update_WORKSHEET
100 (
101 p_validate in boolean default false
102 ,p_worksheet_id in number
103 ,p_budget_id in number default hr_api.g_number
104 ,p_worksheet_name in varchar2 default hr_api.g_varchar2
105 ,p_version_number in number default hr_api.g_number
106 ,p_action_date in date default hr_api.g_date
107 ,p_date_from in date default hr_api.g_date
108 ,p_date_to in date default hr_api.g_date
109 ,p_worksheet_mode_cd in varchar2 default hr_api.g_varchar2
110 ,p_transaction_status in varchar2 default hr_api.g_varchar2
111 ,p_object_version_number in out nocopy number
112 ,p_budget_version_id in number default hr_api.g_number
113 ,p_propagation_method in varchar2 default hr_api.g_varchar2
114 ,p_effective_date in date
115 ,p_wf_transaction_category_id in number default hr_api.g_number
116 );
117 --
118 -- ----------------------------------------------------------------------------
119 -- |------------------------< delete_WORKSHEET >------------------------|
120 -- ----------------------------------------------------------------------------
121 -- {Start Of Comments}
122 --
123 -- Description:
124 --
125 -- Prerequisites:
126 --
127 --
128 -- In Parameters:
129 -- Name Reqd Type Description
130 -- p_validate Yes boolean Commit or Rollback.
131 -- p_worksheet_id Yes number PK of record
132 -- p_effective_date Yes date Session Date.
133 --
134 -- Post Success:
135 --
136 -- Name Type Description
137 -- p_object_version_number Yes number OVN of record
138 --
139 -- Post Failure:
140 --
141 -- Access Status:
142 -- Public.
143 --
144 -- {End Of Comments}
145 --
146 procedure delete_WORKSHEET
147 (
148 p_validate in boolean default false
149 ,p_worksheet_id in number
150 ,p_object_version_number in number
151 ,p_effective_date in date
152 );
153 --
154 --
155 end pqh_WORKSHEETS_api;