[Home] [Help]
PACKAGE: APPS.PA_ADVERTISEMENTS_PVT
Source
4
1 PACKAGE PA_ADVERTISEMENTS_PVT AUTHID CURRENT_USER AS
2 --$Header: PARAVPVS.pls 120.2 2005/12/12 23:27:47 msachan noship $
3 --
5
6
7 ----------------------------------------------------------------------
8 -- Procedure
9 -- Order Advertisement Action Lines
10 --
11 -- Purpose
12 -- Order the action lines of an advertisement action set
13 -- or an advertisement action lines on a requirement that have been
14 -- inserted into pa_action_set_lines table.
15 ----------------------------------------------------------------------
16 PROCEDURE Order_Adv_Action_Lines (
17 p_action_set_id IN pa_action_sets.action_set_id%TYPE
18 , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
19 , p_object_start_date IN DATE := NULL
20 , p_action_set_status_code IN pa_action_sets.status_code%TYPE := NULL
21 , p_action_set_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
22 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23 );
24
25 ----------------------------------------------------------------------
26 -- Procedure
27 -- Perform Publish To All
28 --
29 -- Purpose
30 -- Advertise to everyone
31 ----------------------------------------------------------------------
32 PROCEDURE Publish_To_All (
33 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
34 , p_object_id IN pa_action_sets.object_id%TYPE
35 , p_action_code IN pa_action_set_lines.action_code%TYPE
36 , p_action_status_code IN pa_action_set_lines.status_code%TYPE
37 , p_insert_audit_flag IN VARCHAR2 := 'T'
38 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39 );
40
41 ----------------------------------------------------------------------
42 -- Procedure
43 -- Perform Publish To Organizations
44 --
45 -- Purpose
46 -- Advertise to all resources in organizations under the starting
47 -- organization in the organization hierarchy.
48 ----------------------------------------------------------------------
49 PROCEDURE Publish_To_Organizations (
50 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
51 , p_object_id IN pa_action_sets.object_id%TYPE
52 , p_action_code IN pa_action_set_lines.action_code%TYPE
53 , p_action_status_code IN pa_action_set_lines.status_code%TYPE
54 , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE
55 , p_starting_organization_id IN hr_organization_units.organization_id%TYPE := NULL
56 , p_insert_audit_flag IN VARCHAR2 := 'T'
57 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58 );
59
60 ----------------------------------------------------------------------
61 -- Procedure
62 -- Perform Escalate to Next Level
63 --
64 -- Purpose
65 -- Advertise to all resources in organizations under a higher starting
66 -- organization in the organization hierarchy.
67 ----------------------------------------------------------------------
68 PROCEDURE Escalate_to_Next_Level (
69 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
70 , p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE
71 , p_action_set_id IN pa_action_sets.action_set_id%TYPE
72 , p_action_set_line_rec_ver_num IN pa_action_set_lines.record_version_number%TYPE
73 , p_object_id IN pa_action_sets.object_id%TYPE
74 , p_action_code IN pa_action_set_lines.action_code%TYPE
78 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75 , p_action_status_code IN pa_action_set_lines.status_code%TYPE
76 , p_action_set_line_cond_tbl IN pa_action_set_utils.action_line_cond_tbl_type
77 , p_insert_audit_flag IN VARCHAR2 := 'T'
79 );
80
81 ----------------------------------------------------------------------
82 -- Procedure
83 -- Perform Publish To Staffing Managers
84 --
85 -- Purpose
86 -- Advertise to staffing managers of the specified organization.
87 ----------------------------------------------------------------------
88 PROCEDURE Publish_To_Staffing_Managers (
89 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
90 , p_object_id IN pa_action_sets.object_id%TYPE
91 , p_action_code IN pa_action_set_lines.action_code%TYPE
92 , p_action_status_code IN pa_action_set_lines.status_code%TYPE
93 , p_organization_id IN hr_organization_units.organization_id%TYPE
94 , p_insert_audit_flag IN VARCHAR2 := 'T'
95 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96 );
97
98
99 ----------------------------------------------------------------------
100 -- Procedure
101 -- Perform Send Email
102 --
103 -- Purpose
104 -- Send the advertisement email to a specific email address.
105 ----------------------------------------------------------------------
106 PROCEDURE Send_Email (
107 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
108 , p_object_id IN pa_action_sets.object_id%TYPE
109 , p_action_code IN pa_action_set_lines.action_code%TYPE
110 , p_action_status_code IN pa_action_set_lines.status_code%TYPE
111 , p_email_address IN VARCHAR2
112 , p_project_id IN pa_projects_all.project_id%TYPE
113 , p_insert_audit_flag IN VARCHAR2 := 'T'
114 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115 );
116
117 ----------------------------------------------------------------------
118 -- Procedure
119 -- Perform Send Notification
120 --
121 -- Purpose
122 -- Send the advertisement notification to a specific person or role
123 -- on the project.
124 ----------------------------------------------------------------------
125 PROCEDURE Send_Notification (
126 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
127 , p_object_id IN pa_action_sets.object_id%TYPE
128 , p_action_code IN pa_action_set_lines.action_code%TYPE
129 , p_action_status_code IN pa_action_set_lines.status_code%TYPE
130 , p_method IN VARCHAR2
131 , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM
132 , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
136 );
133 , p_project_id IN pa_project_assignments.project_id%TYPE
134 , p_insert_audit_flag IN VARCHAR2 := 'T'
135 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137
138 ----------------------------------------------------------------------
139 -- Procedure
140 -- Start Notification Workflow
141 --
142 -- Purpose
143 -- Start Workflow process to send advertisement notification
144 ----------------------------------------------------------------------
145 PROCEDURE Start_Adv_Notification_WF (
146 p_action_code IN pa_action_set_lines.action_code%TYPE
147 , p_ntf_recipient_person_id_tbl IN system.pa_num_tbl_type := NULL
148 , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
149 , p_wf_user_name IN VARCHAR2 := NULL
150 , p_wf_process IN VARCHAR2
151 , p_wf_item_type IN VARCHAR2 := 'PARADVWF'
155 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152 , p_assignment_id IN pa_project_assignments.assignment_id%TYPE
153 , p_project_id IN pa_projects_all.project_id%TYPE
154 , p_insert_audit_flag IN VARCHAR2 := 'T'
156 );
157
158 ----------------------------------------------------------------------
159 -- Procedure
160 -- Perform Update Staffing Priority
161 --
162 -- Purpose
163 -- Update the staffing priority of the requirement.
164 ----------------------------------------------------------------------
165 PROCEDURE Update_Staffing_Priority (
166 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
167 , p_object_id IN pa_action_sets.object_id%TYPE
168 , p_action_code IN pa_action_set_lines.action_code%TYPE
169 , p_action_status_code IN pa_action_set_lines.status_code%TYPE
170 , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
171 , p_record_version_number IN pa_project_assignments.record_version_number%TYPE
172 , p_insert_audit_flag IN VARCHAR2 := 'T'
173 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174 );
175
176 ----------------------------------------------------------------------
177 -- Procedure
178 -- Perform Remove Advertisement
179 --
180 -- Purpose
181 -- Remove the visibility or advertisement of the requirement.
182 ----------------------------------------------------------------------
183 PROCEDURE Remove_Advertisement (
184 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
185 , p_object_id IN pa_action_sets.object_id%TYPE
186 , p_action_code IN pa_action_set_lines.action_code%TYPE
187 , p_action_status_code IN pa_action_set_lines.status_code%TYPE
188 , p_project_id IN pa_projects_all.project_id%TYPE
189 , p_insert_audit_flag IN VARCHAR2 := 'T'
190 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
191 );
192
193 -- Start changes for 4777149
194 ----------------------------------------------------------------------
195 -- Procedure
196 -- Perform Check Assignment is in Open Status
197 --
198 -- Purpose
199 -- Check if assignment is in open status before sending the advertisement mail.
200 ----------------------------------------------------------------------
201 PROCEDURE check_assignment_open(
202 itemtype IN VARCHAR2
203 , itemkey IN VARCHAR2
204 , actid IN NUMBER
205 , funcmode IN VARCHAR2
206 , resultout OUT NOCOPY VARCHAR2 --NOCOPY required for OUT and IN/OUT parameters
207 );
208 -- End changes for 4777149
209
210 END PA_ADVERTISEMENTS_PVT;