DBA Data[Home] [Help]

PACKAGE: APPS.HR_HRHD_RIR_WF

Source


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;