[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;