DBA Data[Home] [Help]

PACKAGE: APPS.PQH_TRANSACTION_TEMPLATES_API

Source


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