1 PACKAGE HR_HRHD_RIR_WF as
2 /* $Header: perhdrsyn.pkh 120.1.12010000.1 2008/10/20 15:05:38 sathkris noship $ */
3
4 /* Procedures called inside the workflow process HR RIR Process starts */
5
6 /*procedure called for create job api */
7 procedure create_job(itemtype in varchar2,
8 itemkey in varchar2,
9 actid in number,
10 funcmode in varchar2,
11 resultout in out NOCOPY varchar2);
12
13 /*procedure called for update job api */
14 procedure update_job(itemtype in varchar2,
15 itemkey in varchar2,
16 actid in number,
17 funcmode in varchar2,
18 resultout in out NOCOPY varchar2);
19
20 /*procedure called for delete job api*/
21 procedure delete_job(itemtype in varchar2,
22 itemkey in varchar2,
23 actid in number,
24 funcmode in varchar2,
25 resultout in out NOCOPY varchar2);
26
27 /*procedure called for create location api*/
28 procedure create_location(itemtype in varchar2,
29 itemkey in varchar2,
30 actid in number,
31 funcmode in varchar2,
32 resultout in out NOCOPY varchar2);
33
34 /*procedure called for update location api*/
35 procedure update_location(itemtype in varchar2,
36 itemkey in varchar2,
37 actid in number,
38 funcmode in varchar2,
39 resultout in out NOCOPY varchar2);
40
41 /*procedure called for delete location api*/
42 procedure delete_location(itemtype in varchar2,
43 itemkey in varchar2,
44 actid in number,
45 funcmode in varchar2,
46 resultout in out NOCOPY varchar2);
47
48 /*procedure called for create Organization api*/
49 procedure create_organization(itemtype in varchar2,
50 itemkey in varchar2,
51 actid in number,
52 funcmode in varchar2,
53 resultout in out NOCOPY varchar2);
54
55
56 /*procedure called for update Organization api*/
57 procedure update_organization(itemtype in varchar2,
58 itemkey in varchar2,
59 actid in number,
60 funcmode in varchar2,
61 resultout in out NOCOPY varchar2);
62
63 /*procedure called for delete Organization api*/
64 procedure delete_organization(itemtype in varchar2,
65 itemkey in varchar2,
66 actid in number,
67 funcmode in varchar2,
68 resultout in out NOCOPY varchar2);
69
70 /*procedure called for create person api*/
71 procedure create_person(itemtype in varchar2,
72 itemkey in varchar2,
73 actid in number,
74 funcmode in varchar2,
75 resultout in out NOCOPY varchar2);
76
77 /*procedure called for update person api*/
78 procedure update_person(itemtype in varchar2,
79 itemkey in varchar2,
80 actid in number,
81 funcmode in varchar2,
82 resultout in out NOCOPY varchar2);
83
84 /*procedure called for create or update address api*/
85 procedure cre_or_upd_address(itemtype in varchar2,
86 itemkey in varchar2,
87 actid in number,
88 funcmode in varchar2,
89 resultout in out NOCOPY varchar2);
90
91 /*procedure called for create or update phone api*/
92 procedure cre_or_upd_phone(itemtype in varchar2,
93 itemkey in varchar2,
94 actid in number,
95 funcmode in varchar2,
96 resultout in out NOCOPY varchar2);
97
98
99 /*procedure called for create workforce api*/
100 procedure create_workforce(itemtype in varchar2,
101 itemkey in varchar2,
102 actid in number,
103 funcmode in varchar2,
104 resultout in out NOCOPY varchar2);
105
106 /*procedure called for update workforce api*/
107 procedure update_workforce(itemtype in varchar2,
108 itemkey in varchar2,
109 actid in number,
110 funcmode in varchar2,
111 resultout in out NOCOPY varchar2);
112
113 /* Procedures called inside the workflow process HR RIR Process ends*/
114
115 /*Functions to generate the xml data starts*/
116
117 /*Function to generate the organization xml data*/
118 FUNCTION sif_organization_data(p_organization_id in number,
119 p_org_op_flag in varchar2,
120 p_date_to in boolean)
121 return clob;
122
123 /*Function to generate the person xml data*/
124 FUNCTION sif_person_data(p_person_id in number,
125 p_address_id in number,
126 p_phone_id in number,
127 p_person_op_flag in varchar2,
128 p_date in date)
129 return clob;
130
131 /*Function to generate the workforce data*/
132 FUNCTION sif_workforce_data(p_assignment_id in number,
133 p_asg_op_flag in varchar2,
134 p_date in date)
135 return clob;
136
137 /*Function to generate the location data*/
138 FUNCTION sif_location_data(p_location_id in number,
139 p_loc_op_flag in varchar2,
140 p_inactive_date in boolean)
141 return clob;
142
143 /*Function to generate the job data*/
144 FUNCTION sif_job_data(p_job_id in number,
145 p_job_op_flag in varchar2,
146 p_date_to in boolean)
147 return clob;
148
149 /*Functions to generate the xml data ends*/
150
151 /* Call backable Procedures definition starts */
152
153 procedure workforce_callbackable(my_parms in wf_parameter_list_t);
154
155 procedure person_callbackable(my_parms in wf_parameter_list_t);
156
157 procedure address_callbackable(my_parms in wf_parameter_list_t);
158
159 procedure phone_callbackable(my_parms in wf_parameter_list_t);
160
161 /* Call backable Procedures definition ends */
162
163 end HR_HRHD_RIR_WF;