[Home] [Help]
PACKAGE: APPS.PQH_FYI_NOTIFY_API
Source
1 Package pqh_fyi_notify_api as
2 /* $Header: pqfynapi.pkh 120.0 2005/05/29 01:55:25 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_fyi_notify >------------------------|
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_transaction_category_id Yes number
18 -- p_transaction_id Yes number
19 -- p_notification_event_cd Yes varchar2
20 -- p_notified_type_cd No varchar2
21 -- p_notified_name No varchar2
22 -- p_notification_date No date
23 -- p_status No varchar2
24 -- p_effective_date Yes date Session Date.
25 --
26 -- Post Success:
27 --
28 -- Out Parameters:
29 -- Name Type Description
30 -- p_fyi_notified_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_fyi_notify
41 (
42 p_validate in boolean default false
43 ,p_fyi_notified_id out nocopy number
44 ,p_transaction_category_id in number default null
45 ,p_transaction_id in number default null
46 ,p_notification_event_cd in varchar2 default null
47 ,p_notified_type_cd in varchar2 default null
48 ,p_notified_name in varchar2 default null
49 ,p_notification_date in date default null
50 ,p_status in varchar2 default null
51 ,p_object_version_number out nocopy number
52 ,p_effective_date in date
53 );
54 -- ----------------------------------------------------------------------------
55 -- |------------------------< update_fyi_notify >------------------------|
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_fyi_notified_id Yes number PK of record
68 -- p_transaction_category_id Yes number
69 -- p_transaction_id Yes number
70 -- p_notification_event_cd Yes varchar2
71 -- p_notified_type_cd No varchar2
72 -- p_notified_name No varchar2
73 -- p_notification_date No date
74 -- p_status No varchar2
75 -- p_effective_date Yes date Session Date.
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_fyi_notify
90 (
91 p_validate in boolean default false
92 ,p_fyi_notified_id in number
93 ,p_transaction_category_id in number default hr_api.g_number
94 ,p_transaction_id in number default hr_api.g_number
95 ,p_notification_event_cd in varchar2 default hr_api.g_varchar2
96 ,p_notified_type_cd in varchar2 default hr_api.g_varchar2
97 ,p_notified_name in varchar2 default hr_api.g_varchar2
98 ,p_notification_date in date default hr_api.g_date
99 ,p_status in varchar2 default hr_api.g_varchar2
100 ,p_object_version_number in out nocopy number
101 ,p_effective_date in date
102 );
103 --
104 -- ----------------------------------------------------------------------------
105 -- |------------------------< delete_fyi_notify >------------------------|
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_fyi_notified_id Yes number PK of record
118 -- p_effective_date Yes date Session Date.
119 --
120 -- Post Success:
121 --
122 -- Name Type Description
123 -- p_object_version_number Yes number OVN of record
124 --
125 -- Post Failure:
126 --
127 -- Access Status:
128 -- Public.
129 --
130 -- {End Of Comments}
131 --
132 procedure delete_fyi_notify
133 (
134 p_validate in boolean default false
135 ,p_fyi_notified_id in number
136 ,p_object_version_number in number
137 ,p_effective_date in date
138 );
139 --
140 end pqh_fyi_notify_api;