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