1 Package pqh_WORKSHEET_FUND_SRCS_api as
2 /* $Header: pqwfsapi.pkh 120.0 2005/05/29 02:59:11 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_WORKSHEET_FUND_SRC >------------------------|
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_worksheet_bdgt_elmnt_id Yes number
18 -- p_distribution_percentage No number
19 -- p_cost_allocation_keyflex_id Yes number
20 -- p_project_id No number
21 -- p_award_id No number
22 -- p_task_id No number
23 -- p_expenditure_type No varchar
24 -- p_organization_id No number
25 --
26 -- Post Success:
27 --
28 -- Out Parameters:
29 -- Name Type Description
30 -- p_worksheet_fund_src_id Yes number PK of record
31 -- p_object_version_number Yes number OVN of record
32 --
33 -- Post Failure:
34 --
35 -- Access Status:
36 -- Public.
37 --
38 -- {End Of Comments}
39 --
40 procedure create_WORKSHEET_FUND_SRC
41 (
42 p_validate in boolean default false
43 ,p_worksheet_fund_src_id out nocopy number
44 ,p_worksheet_bdgt_elmnt_id in number
45 ,p_distribution_percentage in number default null
46 ,p_cost_allocation_keyflex_id in number
47 ,p_project_id in number default null
48 ,p_award_id in number default null
49 ,p_task_id in number default null
50 ,p_expenditure_type in varchar2 default null
51 ,p_organization_id in number default null
52 ,p_object_version_number out nocopy number
53 );
54 -- ----------------------------------------------------------------------------
55 -- |------------------------< update_WORKSHEET_FUND_SRC >------------------------|
56 -- ----------------------------------------------------------------------------
57 -- {Start Of Comments}
58 --
59 -- Description:
60 --
61 -- Prerequisites:
62 --
63 --
64 -- In Parameters:
65 -- Name Reqd Type Description
66 -- p_validate Yes boolean Commit or Rollback.
67 -- p_worksheet_fund_src_id Yes number PK of record
68 -- p_worksheet_bdgt_elmnt_id Yes number
69 -- p_distribution_percentage No number
70 -- p_cost_allocation_keyflex_id Yes number
71 -- p_project_id No number
72 -- p_award_id No number
73 -- p_task_id No number
74 -- p_expenditure_type No varchar
75 -- p_organization_id No number
76 --
77 -- Post Success:
78 --
79 -- Name Type Description
80 -- p_object_version_number Yes number OVN of record
81 --
82 -- Post Failure:
83 --
84 -- Access Status:
85 -- Public.
86 --
87 -- {End Of Comments}
88 --
89 procedure update_WORKSHEET_FUND_SRC
90 (
91 p_validate in boolean default false
92 ,p_worksheet_fund_src_id in number
93 ,p_worksheet_bdgt_elmnt_id in number default hr_api.g_number
94 ,p_distribution_percentage in number default hr_api.g_number
95 ,p_cost_allocation_keyflex_id in number default hr_api.g_number
96 ,p_project_id in number default hr_api.g_number
97 ,p_award_id in number default hr_api.g_number
98 ,p_task_id in number default hr_api.g_number
99 ,p_expenditure_type in varchar2 default hr_api.g_varchar2
100 ,p_organization_id in number default hr_api.g_number
101 ,p_object_version_number in out nocopy number
102 );
103 --
104 -- ----------------------------------------------------------------------------
105 -- |------------------------< delete_WORKSHEET_FUND_SRC >------------------------|
106 -- ----------------------------------------------------------------------------
107 -- {Start Of Comments}
108 --
109 -- Description:
110 --
111 -- Prerequisites:
112 --
113 --
114 -- In Parameters:
115 -- Name Reqd Type Description
116 -- p_validate Yes boolean Commit or Rollback.
117 -- p_worksheet_fund_src_id Yes number PK of record
118 --
119 -- Post Success:
120 --
121 -- Name Type Description
122 -- p_object_version_number Yes number OVN of record
123 --
124 -- Post Failure:
125 --
126 -- Access Status:
127 -- Public.
128 --
129 -- {End Of Comments}
130 --
131 procedure delete_WORKSHEET_FUND_SRC
132 (
133 p_validate in boolean default false
134 ,p_worksheet_fund_src_id in number
135 ,p_object_version_number in number
136 );
137 --
138 --
139 end pqh_WORKSHEET_FUND_SRCS_api;