DBA Data[Home] [Help]

PACKAGE: APPS.PQH_WORKSHEET_BDGT_ELMNTS_API

Source


1 Package pqh_WORKSHEET_BDGT_ELMNTS_api as
2 /* $Header: pqwelapi.pkh 120.0 2005/05/29 02:58:24 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_WORKSHEET_BDGT_ELMNT >------------------------|
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_budget_set_id      Yes  number
18 --   p_element_type_id              Yes  number
19 --   p_distribution_percentage      No   number
20 --
21 -- Post Success:
22 --
23 -- Out Parameters:
24 --   Name                                Type     Description
25 --   p_worksheet_bdgt_elmnt_id      Yes  number    PK of record
26 --   p_object_version_number        Yes  number    OVN of record
27 --
28 -- Post Failure:
29 --
30 -- Access Status:
31 --   Public.
32 --
33 -- {End Of Comments}
34 --
35 procedure create_WORKSHEET_BDGT_ELMNT
36 (
37    p_validate                       in boolean    default false
38   ,p_worksheet_bdgt_elmnt_id        out nocopy number
39   ,p_worksheet_budget_set_id        in  number
40   ,p_element_type_id                in  number
41   ,p_distribution_percentage        in  number    default null
42   ,p_object_version_number          out nocopy number
43  );
44 -- ----------------------------------------------------------------------------
45 -- |------------------------< update_WORKSHEET_BDGT_ELMNT >------------------------|
46 -- ----------------------------------------------------------------------------
47 -- {Start Of Comments}
48 --
49 -- Description:
50 --
51 -- Prerequisites:
52 --
53 --
54 -- In Parameters:
55 --   Name                           Reqd Type     Description
56 --   p_validate                     Yes  boolean  Commit or Rollback.
57 --   p_worksheet_bdgt_elmnt_id      Yes  number    PK of record
58 --   p_worksheet_budget_set_id      Yes  number
59 --   p_element_type_id              Yes  number
60 --   p_distribution_percentage      No   number
61 --
62 -- Post Success:
63 --
64 --   Name                           Type     Description
65 --   p_object_version_number        Yes  number    OVN of record
66 --
67 -- Post Failure:
68 --
69 -- Access Status:
70 --   Public.
71 --
72 -- {End Of Comments}
73 --
74 procedure update_WORKSHEET_BDGT_ELMNT
75   (
76    p_validate                       in boolean    default false
77   ,p_worksheet_bdgt_elmnt_id        in  number
78   ,p_worksheet_budget_set_id        in  number    default hr_api.g_number
79   ,p_element_type_id                in  number    default hr_api.g_number
80   ,p_distribution_percentage        in  number    default hr_api.g_number
81   ,p_object_version_number          in out nocopy number
82   );
83 --
84 -- ----------------------------------------------------------------------------
85 -- |------------------------< delete_WORKSHEET_BDGT_ELMNT >------------------------|
86 -- ----------------------------------------------------------------------------
87 -- {Start Of Comments}
88 --
89 -- Description:
90 --
91 -- Prerequisites:
92 --
93 --
94 -- In Parameters:
95 --   Name                           Reqd Type     Description
96 --   p_validate                     Yes  boolean  Commit or Rollback.
97 --   p_worksheet_bdgt_elmnt_id      Yes  number    PK of record
98 --
99 -- Post Success:
100 --
101 --   Name                           Type     Description
102 --   p_object_version_number        Yes  number    OVN of record
103 --
104 -- Post Failure:
105 --
106 -- Access Status:
107 --   Public.
108 --
109 -- {End Of Comments}
110 --
111 procedure delete_WORKSHEET_BDGT_ELMNT
112   (
113    p_validate                       in boolean        default false
114   ,p_worksheet_bdgt_elmnt_id        in number
115   ,p_object_version_number          in number
116   );
117 --
118 --
119 end pqh_WORKSHEET_BDGT_ELMNTS_api;