[Home] [Help]
PACKAGE: APPS.PER_CHECKLIST_EVENTS
Source
1 package PER_CHECKLIST_EVENTS AUTHID CURRENT_USER as
2 /* $Header: pecklevt.pkh 120.4.12010000.2 2010/04/03 12:22:10 brsinha ship $ */
3 --g_temp_num number :=1;
4 --
5 -- ------------------------------------------------------------------------
6 -- |----------------------------< create_event>---------------------------|
7 -- ------------------------------------------------------------------------
8 --
9
10 procedure CREATE_EVENT
11 (p_effective_date in date,
12 P_person_id in number,
13 P_assignment_id in number,
14 P_ler_id in number);
15
16 --
17
18 -- ---------------------------------------------------------------------------------
19 -- |------------------------------PROCESS EVENT------------------------------------|
20 -- ---------------------------------------------------------------------------------
21 -- {Start Of Comments}
22 --
23 -- Description:
24 -- This API is provided to allow creation of new checklist in PER_CHECKLISTS
25 --
26 -- Prerequisites:
27 -- None
28 --
29 -- In Parameters:
30 -- Name Reqd Type Description
31 --
32 -- p_validate Yes boolean Commit or Rollback
33 -- p_effective_date Yes date Effective date of record
34 -- p_name No varchar2 Name of the checklist
35 -- p_description No varchar2 Description of the checklist
36 -- p_life_event_reason_id No number The id of the life event reason
37 -- p_business_group_id No number The business group the person
38 -- p_checklist_category No varchar2 Checklist category
39 --
40 -- Post Success:
41 -- Api creates a checklist event
42 --
43 -- Post Failure:
44 -- The API does not create checklist event and raises an error.
45 --
46 --
47 -- Access Status:
48 -- Internal.
49 --
50 -- {End Of Comments}
51 --
52 procedure PROCESS_EVENT
53 (p_person_id in number
54 ,p_assignment_id in number default null
55 ,p_date in date
56 ,p_ler_event_id in number);
57
58 --
59 -- ------------------------------------------------------------------------
60 -- |------------------------------< PROCESS_VOTING >--------------------------|
61 -- ------------------------------------------------------------------------
62 --
63
64 procedure PROCESS_VOTING
65 (itemtype in varchar2,
66 itemkey in varchar2,
67 actid in number,
68 funcmode in varchar2,
69 resultout out nocopy varchar2);
70
71 --
72 -- ------------------------------------------------------------------------
73 -- |------------------------------< check_approvers_exist >--------------------------|
74 -- ------------------------------------------------------------------------
75 --
76
77 procedure check_approvers_exist
78 (itemtype in varchar2,
79 itemkey in varchar2,
80 actid in number,
81 funcmode in varchar2,
82 resultout out nocopy varchar2);
83 --
84 -- ---------------------------------------------------------------------------------
85 -- |------------------------------Allocate Tasks-----------------------------------|
86 -- ---------------------------------------------------------------------------------
87 --
88 Procedure ALLOCATE_TASKS(errbuf out nocopy varchar2
89 ,retcode out nocopy number
90 ,p_purge in varchar2);
91 --
92 --
93 -- ---------------------------------------------------------------------------------
94 -- |----------------------------Allocate Person Tasks------------------------------|
95 -- ---------------------------------------------------------------------------------
96 --
97 Procedure ALLOCATE_PERSON_TASKS(p_person_id in number);
98 --
99 --
100 -- ------------------------------------------------------------------------
101 -- |----------------------< Start_WF_Process>-----------------------|
102 -- ------------------------------------------------------------------------
103 --
104 -- Description
105 --
106 -- Initialize the Checklist Workflow process
107 --
108 --
109 --
110 procedure START_WF_PROCESS (p_person_id in number
111 ,p_assignment_id in number default null
112 ,p_checklist_name in varchar2
113 ,p_checklist_description in varchar2
114 ,p_task_name in varchar2
115 ,p_task_description in varchar2
116 ,p_performer_name in varchar2
117 ,p_performer_display_name in varchar2
118 ,p_target_date in date
119 ,p_total_approvers in number
120 ,p_current_approver_num in number default 1
121 ,p_allocated_task_id in number
122 ,p_task_in_checklist_id in number);
123 --
124 --
125 -- ------------------------------------------------------------------------
126 -- |----------------------< approve_wf_Process>-----------------------|
127 -- ------------------------------------------------------------------------
128 --
129 procedure APPROVE_WF_PROCESS
130 --
131 (itemtype in varchar2,
132 itemkey in varchar2,
133 actid in number,
134 funcmode in varchar2,
135 resultout out nocopy varchar2);
136 --
137 -- ------------------------------------------------------------------------
138 -- |-------------------------< rejected_wf_Process>-----------------------|
139 -- ------------------------------------------------------------------------
140 --
141 procedure REJECTED_WF_PROCESS
142 --
143 (itemtype in varchar2,
144 itemkey in varchar2,
145 actid in number,
146 funcmode in varchar2,
147 resultout out nocopy varchar2);
148 --
149 -- ------------------------------------------------------------------------
150 -- |------------------------------< Process_fyi>--------------------------|
151 -- ------------------------------------------------------------------------
152 --
153 procedure PROCESS_FYI
154 --
155 (itemtype in varchar2,
156 itemkey in varchar2,
157 actid in number,
158 funcmode in varchar2,
159 resultout out nocopy varchar2);
160 --
161 -- ------------------------------------------------------------------------
162 -- |------------------------------< Copy_Tasks >--------------------------|
163 -- ------------------------------------------------------------------------
164 --
165 PROCEDURE Copy_Tasks (p_from_ckl_id IN NUMBER
166 ,p_to_alloc_ckl_id IN NUMBER
167 ,p_task_owner_person_id IN NUMBER
168 );
169 --
170 -- ------------------------------------------------------------------------
171 -- |------------------------------< get_person_id >------------------------|
172 -- ------------------------------------------------------------------------
173 FUNCTION get_person_id (p_transaction_id IN varchar2) RETURN NUMBER;
174 --
175 -- ------------------------------------------------------------------------
176 -- |------------------------------< get_supervisor_id >------------------------|
177 -- ------------------------------------------------------------------------
178 FUNCTION get_supervisor_id (p_transaction_id IN varchar2) RETURN NUMBER;
179 --
180 -- ------------------------------------------------------------------------
181 -- |------------------------------< get_ame_attribute_identifier >---------|
182 -- ------------------------------------------------------------------------
183 FUNCTION get_ame_attribute_identifier (p_transaction_id IN varchar2)
184 RETURN VARCHAR2 ;
185 --
186
187 end per_checklist_events;