eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASSIGNMENT_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 6: g_team_role_name_token PA_PROJECT_ASSIGNMENTS.assignment_name%TYPE := NULL;

2: -- $Header: PARAUTLS.pls 120.2 2005/08/19 16:48:42 mwasowic noship $
3:
4: g_team_template_id PA_TEAM_TEMPLATES.team_template_id%TYPE := NULL;
5: g_team_template_name_token PA_TEAM_TEMPLATES.team_template_name%TYPE := NULL;
6: g_team_role_name_token PA_PROJECT_ASSIGNMENTS.assignment_name%TYPE := NULL;
7: g_provisional_hours NUMBER := 0;
8: g_confirmed_hours NUMBER := 0;
9: g_person_id_wo_name pa_resources_denorm.person_id%TYPE := NULL;
10: g_project_id_wo_name pa_project_assignments.project_id%TYPE := NULL;

Line 10: g_project_id_wo_name pa_project_assignments.project_id%TYPE := NULL;

6: g_team_role_name_token PA_PROJECT_ASSIGNMENTS.assignment_name%TYPE := NULL;
7: g_provisional_hours NUMBER := 0;
8: g_confirmed_hours NUMBER := 0;
9: g_person_id_wo_name pa_resources_denorm.person_id%TYPE := NULL;
10: g_project_id_wo_name pa_project_assignments.project_id%TYPE := NULL;
11: g_ei_date_wo_name DATE := NULL;
12:
13: g_person_id_w_name pa_resources_denorm.person_id%TYPE := NULL;
14: g_project_id_w_name pa_project_assignments.project_id%TYPE := NULL;

Line 14: g_project_id_w_name pa_project_assignments.project_id%TYPE := NULL;

10: g_project_id_wo_name pa_project_assignments.project_id%TYPE := NULL;
11: g_ei_date_wo_name DATE := NULL;
12:
13: g_person_id_w_name pa_resources_denorm.person_id%TYPE := NULL;
14: g_project_id_w_name pa_project_assignments.project_id%TYPE := NULL;
15: g_ei_date_w_name DATE := NULL;
16:
17: g_in_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
18: g_out_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;

Line 17: g_in_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;

13: g_person_id_w_name pa_resources_denorm.person_id%TYPE := NULL;
14: g_project_id_w_name pa_project_assignments.project_id%TYPE := NULL;
15: g_ei_date_w_name DATE := NULL;
16:
17: g_in_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
18: g_out_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
19: g_assignment_id_w_name pa_project_assignments.assignment_id%TYPE := NULL;
20: g_assignment_id_wo_name pa_project_assignments.assignment_id%TYPE := NULL;
21:

Line 18: g_out_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;

14: g_project_id_w_name pa_project_assignments.project_id%TYPE := NULL;
15: g_ei_date_w_name DATE := NULL;
16:
17: g_in_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
18: g_out_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
19: g_assignment_id_w_name pa_project_assignments.assignment_id%TYPE := NULL;
20: g_assignment_id_wo_name pa_project_assignments.assignment_id%TYPE := NULL;
21:
22: --

Line 19: g_assignment_id_w_name pa_project_assignments.assignment_id%TYPE := NULL;

15: g_ei_date_w_name DATE := NULL;
16:
17: g_in_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
18: g_out_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
19: g_assignment_id_w_name pa_project_assignments.assignment_id%TYPE := NULL;
20: g_assignment_id_wo_name pa_project_assignments.assignment_id%TYPE := NULL;
21:
22: --
23: -- PROCEDURE

Line 20: g_assignment_id_wo_name pa_project_assignments.assignment_id%TYPE := NULL;

16:
17: g_in_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
18: g_out_asgmt_name pa_project_assignments.assignment_name%TYPE := NULL;
19: g_assignment_id_w_name pa_project_assignments.assignment_id%TYPE := NULL;
20: g_assignment_id_wo_name pa_project_assignments.assignment_id%TYPE := NULL;
21:
22: --
23: -- PROCEDURE
24: -- Check_Status_Is_In_use

Line 46: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE

42: -- 17-JUL-2000 R. Krishnamurthy Created
43: --
44: PROCEDURE Validate_Asgmt_Competency
45: ( p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL
46: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
47: ,p_competence_id IN per_competences.competence_id%TYPE
48: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
50:

Line 144: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

140: -- PURPOSE
141: -- This procedure Checks whether a given project has
142: -- Assignments and assignment schedules
143:
144: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
145: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE
146: ,p_check_id_flag IN VARCHAR2 := 'A'
147: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 145: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE

141: -- This procedure Checks whether a given project has
142: -- Assignments and assignment schedules
143:
144: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
145: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE
146: ,p_check_id_flag IN VARCHAR2 := 'A'
147: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 147: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

143:
144: PROCEDURE Check_Assignment_Number_Or_Id( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
145: ,p_assignment_number IN pa_project_assignments.assignment_number%TYPE
146: ,p_check_id_flag IN VARCHAR2 := 'A'
147: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
150:
151: --Validates the assignment number

Line 158: PROCEDURE Check_STF_PriorityName_Or_Code (p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE

154:
155: --
156: --Validate the Staffing Priority Name/Code
157: --
158: PROCEDURE Check_STF_PriorityName_Or_Code (p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
159: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE
160: ,p_check_id_flag IN VARCHAR2
161: ,x_staffing_priority_code OUT NOCOPY pa_project_assignments.staffing_priority_code%TYPE --File.Sql.39 bug 4440895
162: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 161: ,x_staffing_priority_code OUT NOCOPY pa_project_assignments.staffing_priority_code%TYPE --File.Sql.39 bug 4440895

157: --
158: PROCEDURE Check_STF_PriorityName_Or_Code (p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
159: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE
160: ,p_check_id_flag IN VARCHAR2
161: ,x_staffing_priority_code OUT NOCOPY pa_project_assignments.staffing_priority_code%TYPE --File.Sql.39 bug 4440895
162: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
164: --
165: --Possible values for return: 'Roll On', 'Roll Off', 'Pending Approval'

Line 201: ,p_project_id IN pa_project_assignments.project_id%TYPE

197: RETURN VARCHAR2;
198:
199: PROCEDURE Get_Person_Asgmt
200: ( p_person_id IN pa_resources_denorm.person_id%TYPE
201: ,p_project_id IN pa_project_assignments.project_id%TYPE
202: ,p_ei_date IN DATE
203: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895
204: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
205: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 203: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895

199: PROCEDURE Get_Person_Asgmt
200: ( p_person_id IN pa_resources_denorm.person_id%TYPE
201: ,p_project_id IN pa_project_assignments.project_id%TYPE
202: ,p_ei_date IN DATE
203: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895
204: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
205: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
206: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
207:

Line 204: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

200: ( p_person_id IN pa_resources_denorm.person_id%TYPE
201: ,p_project_id IN pa_project_assignments.project_id%TYPE
202: ,p_ei_date IN DATE
203: ,x_assignment_name IN OUT NOCOPY pa_project_assignments.assignment_name%TYPE --File.Sql.39 bug 4440895
204: ,x_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
205: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
206: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
207:
208: FUNCTION Get_Assignment_Measures

Line 209: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

205: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
206: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
207:
208: FUNCTION Get_Assignment_Measures
209: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
210: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
211: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
212: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
213: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE

Line 210: ,p_resource_id IN pa_project_assignments.resource_id%TYPE

206: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
207:
208: FUNCTION Get_Assignment_Measures
209: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
210: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
211: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
212: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
213: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
214: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)

Line 211: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE

207:
208: FUNCTION Get_Assignment_Measures
209: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
210: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
211: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
212: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
213: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
214: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)
215: RETURN NUMBER;

Line 212: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE

208: FUNCTION Get_Assignment_Measures
209: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
210: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
211: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
212: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
213: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
214: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)
215: RETURN NUMBER;
216:

Line 213: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE

209: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
210: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
211: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
212: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
213: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
214: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)
215: RETURN NUMBER;
216:
217: FUNCTION Get_Asgn_Provisional_Hours

Line 214: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)

210: ,p_resource_id IN pa_project_assignments.resource_id%TYPE
211: ,p_asgn_effort IN pa_project_assignments.assignment_effort%TYPE
212: ,p_asgn_start_date IN pa_project_assignments.start_date%TYPE
213: ,p_asgn_end_date IN pa_project_assignments.end_date%TYPE
214: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE)
215: RETURN NUMBER;
216:
217: FUNCTION Get_Asgn_Provisional_Hours
218: RETURN NUMBER;

Line 234: ,p_exp_org_id IN pa_project_assignments.expenditure_org_id%TYPE := NULL

230: -- 29-APR-2003 shyugen Created
231: --
232: PROCEDURE Get_Default_Staffing_Owner
233: ( p_project_id IN pa_projects_all.project_id%TYPE
234: ,p_exp_org_id IN pa_project_assignments.expenditure_org_id%TYPE := NULL
235: ,x_person_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
236: ,x_person_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
237: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
238: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 250: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

246: -- HISTORY
247: -- 29-APR-2003 shyugen Created
248: ------------------------------------------------------------------------------
249: PROCEDURE Get_All_Staffing_Owners
250: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
251: ,p_project_id IN pa_projects_all.project_id%TYPE
252: ,x_person_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
253: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
254: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 275: /* Added for bug 3724780, to get assignment_id from pa_project_assignments */

271: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
272:
273: FUNCTION Get_multi_team_role_flag RETURN VARCHAR2; /* Added new function to check if team role is associated with multiple assignement
274: or requirement for bug 3724780 */
275: /* Added for bug 3724780, to get assignment_id from pa_project_assignments */
276: FUNCTION Get_project_assignment_id
277: (p_resource_list_member_id IN NUMBER,
278: p_project_id IN NUMBER) RETURN NUMBER;
279: FUNCTION Get_project_assignment_type