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_ROLE_PROFILES_PUB dependencies on PA_ROLE_PROFILES

Line 1: PACKAGE BODY PA_ROLE_PROFILES_PUB AS

1: PACKAGE BODY PA_ROLE_PROFILES_PUB AS
2: -- $Header: PARPRPPB.pls 120.1 2005/08/19 16:59:18 mwasowic noship $
3: --
4: -- PROCEDURE
5: -- Add_Default_Profile

Line 45: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Add_Default_Profile');

41: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
42:
43: BEGIN
44: IF l_enable_log = 'Y' THEN
45: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Add_Default_Profile');
46: END IF;
47:
48: -- Clear the global PL/SQL message table
49: FND_MSG_PUB.initialize;

Line 61: PA_ROLE_PROFILES_UTILS.Check_Business_Level_Attrs

57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
59: END IF;
60:
61: PA_ROLE_PROFILES_UTILS.Check_Business_Level_Attrs
62: ( p_business_group_id => p_business_group_id,
63: p_business_group_name => p_business_group_name,
64: p_organization_id => p_organization_id,
65: p_organization_name => p_organization_name,

Line 84: PA_ROLE_PROFILES_UTILS.Validate_Profile_Lines

80: END IF;
81:
82: --Next, validate profile lines
83:
84: PA_ROLE_PROFILES_UTILS.Validate_Profile_Lines
85: ( p_role_id_tbl => p_role_id_tbl,
86: p_role_name_tbl => p_role_name_tbl,
87: p_weighting_tbl => p_weighting_tbl,
88: x_role_id_tbl => l_role_id_tbl,

Line 107: FROM pa_role_profiles

103:
104: BEGIN
105: SELECT 'Y'
106: INTO l_exists
107: FROM pa_role_profiles
108: WHERE resource_id IS NULL
109: AND NVL(business_group_id, -1) = NVL(l_business_group_id, -1)
110: AND NVL(organization_id, -1) = NVL(l_organization_id, -1)
111: AND NVL(job_id, -1) = NVL(l_job_id, -1)

Line 129: FROM pa_role_profiles

125: BEGIN
126: --Check if p_start_date is in between any start_date, end_date combination
127: SELECT 'Y'
128: INTO l_exists
129: FROM pa_role_profiles
130: WHERE resource_id IS NULL
131: AND NVL(business_group_id, -1) = NVL(l_business_group_id, -1)
132: AND NVL(organization_id, -1) = NVL(l_organization_id, -1)
133: AND NVL(job_id, -1) = NVL(l_job_id, -1)

Line 157: FROM pa_role_profiles

153: SELECT profile_id,
154: effective_end_date
155: INTO l_prev_profile_id,
156: l_end_date
157: FROM pa_role_profiles
158: WHERE effective_start_date = (SELECT max(effective_start_date)
159: FROM pa_role_profiles
160: WHERE resource_id IS NULL
161: AND NVL(business_group_id, -1) = NVL(l_business_group_id, -1)

Line 159: FROM pa_role_profiles

155: INTO l_prev_profile_id,
156: l_end_date
157: FROM pa_role_profiles
158: WHERE effective_start_date = (SELECT max(effective_start_date)
159: FROM pa_role_profiles
160: WHERE resource_id IS NULL
161: AND NVL(business_group_id, -1) = NVL(l_business_group_id, -1)
162: AND NVL(organization_id, -1) = NVL(l_organization_id, -1)
163: AND NVL(job_id, -1) = NVL(l_job_id, -1)

Line 175: UPDATE pa_role_profiles

171: AND NVL(position_id, -1) = NVL(l_position_id, -1);
172:
173: --dbms_output.put_line ('l_prev_profile_id ' || l_prev_profile_id);
174: -- End-date previous profile as its end date is null
175: UPDATE pa_role_profiles
176: SET effective_end_date = p_effective_start_date - 1
177: WHERE profile_id = l_prev_profile_id;
178:
179: EXCEPTION

Line 186: PA_ROLE_PROFILES_PKG.Insert_Row1

182: END;
183:
184: --dbms_output.put_line ('4');
185:
186: PA_ROLE_PROFILES_PKG.Insert_Row1
187: ( p_profile_name => p_profile_name,
188: p_description => p_description,
189: p_effective_start_date => p_effective_start_date,
190: p_effective_end_date => p_effective_end_date,

Line 200: PA_ROLE_PROFILES_PKG.Insert_Row2

196: x_profile_id => l_profile_id,
197: x_return_status => l_return_status);
198:
199: FOR i IN 1..l_role_id_tbl.count LOOP
200: PA_ROLE_PROFILES_PKG.Insert_Row2
201: ( p_profile_id => l_profile_id,
202: p_project_role_id => l_role_id_tbl(i),
203: p_role_weighting => p_weighting_tbl(i),
204: x_return_status => l_return_status);

Line 266: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Update_Default_Profile');

262: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
263:
264: BEGIN
265: IF l_enable_log = 'Y' THEN
266: PA_DEBUG.init_err_stack('PA_ROLE_PROFILES_PUB.Update_Default_Profile');
267: END IF;
268:
269: -- Clear the global PL/SQL message table
270: FND_MSG_PUB.initialize;

Line 282: PA_ROLE_PROFILES_UTILS.Check_Business_Level_Attrs

278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: END IF;
281:
282: PA_ROLE_PROFILES_UTILS.Check_Business_Level_Attrs
283: ( p_business_group_id => p_business_group_id,
284: p_business_group_name => p_business_group_name,
285: p_organization_id => p_organization_id,
286: p_organization_name => p_organization_name,

Line 305: PA_ROLE_PROFILES_UTILS.Validate_Profile_Lines

301: END IF;
302:
303: --Next, validate profile lines
304:
305: PA_ROLE_PROFILES_UTILS.Validate_Profile_Lines
306: ( p_role_id_tbl => p_role_id_tbl,
307: p_role_name_tbl => p_role_name_tbl,
308: p_weighting_tbl => p_weighting_tbl,
309: x_role_id_tbl => l_role_id_tbl,

Line 328: FROM pa_role_profiles

324:
325: BEGIN
326: SELECT 'Y'
327: INTO l_exists
328: FROM pa_role_profiles
329: WHERE resource_id IS NULL
330: AND NVL(business_group_id, -1) = NVL(l_business_group_id, -1)
331: AND NVL(organization_id, -1) = NVL(l_organization_id, -1)
332: AND NVL(job_id, -1) = NVL(l_job_id, -1)

Line 351: FROM pa_role_profiles

347: BEGIN
348: --Check if p_start_date is in between any start_date, end_date combination
349: SELECT 'Y'
350: INTO l_exists
351: FROM pa_role_profiles
352: WHERE resource_id IS NULL
353: AND NVL(business_group_id, -1) = NVL(l_business_group_id, -1)
354: AND NVL(organization_id, -1) = NVL(l_organization_id, -1)
355: AND NVL(job_id, -1) = NVL(l_job_id, -1)

Line 379: FROM pa_role_profiles

375: SELECT profile_id,
376: effective_end_date
377: INTO l_prev_profile_id,
378: l_end_date
379: FROM pa_role_profiles
380: WHERE effective_start_date = (SELECT max(effective_start_date)
381: FROM pa_role_profiles
382: WHERE resource_id IS NULL
383: AND NVL(business_group_id, -1) = NVL(l_business_group_id, -1)

Line 381: FROM pa_role_profiles

377: INTO l_prev_profile_id,
378: l_end_date
379: FROM pa_role_profiles
380: WHERE effective_start_date = (SELECT max(effective_start_date)
381: FROM pa_role_profiles
382: WHERE resource_id IS NULL
383: AND NVL(business_group_id, -1) = NVL(l_business_group_id, -1)
384: AND NVL(organization_id, -1) = NVL(l_organization_id, -1)
385: AND NVL(job_id, -1) = NVL(l_job_id, -1)

Line 399: UPDATE pa_role_profiles

395: AND profile_id <> p_profile_id;
396:
397: --dbms_output.put_line ('l_prev_profile_id ' || l_prev_profile_id);
398: -- End-date previous profile as its end date is null
399: UPDATE pa_role_profiles
400: SET effective_end_date = p_effective_start_date - 1
401: WHERE profile_id = l_prev_profile_id;
402:
403: EXCEPTION

Line 411: PA_ROLE_PROFILES_PKG.Update_Row

407:
408: --dbms_output.put_line ('4');
409:
410: -- Update current profile
411: PA_ROLE_PROFILES_PKG.Update_Row
412: ( p_profile_id => p_profile_id,
413: p_profile_name => p_profile_name,
414: p_description => p_description,
415: p_effective_start_date => p_effective_start_date,

Line 429: PA_ROLE_PROFILES_PKG.Insert_Row2

425: WHERE profile_id = p_profile_id;
426:
427: -- Insert roles into the pa_role_profile_lines table
428: FOR i IN 1..l_role_id_tbl.count LOOP
429: PA_ROLE_PROFILES_PKG.Insert_Row2
430: ( p_profile_id => p_profile_id,
431: p_project_role_id => l_role_id_tbl(i),
432: p_role_weighting => p_weighting_tbl(i),
433: x_return_status => l_return_status);

Line 466: DELETE FROM pa_role_profiles

462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: x_msg_count := 0;
464: x_msg_data := null;
465:
466: DELETE FROM pa_role_profiles
467: WHERE profile_id = p_profile_id;
468:
469: DELETE FROM pa_role_profile_lines
470: WHERE profile_id = p_profile_id;

Line 517: FROM pa_role_profiles

513: + decode(job_id, null, 0, 3)
514: + decode(organization_id, null, 0, 2)
515: + decode(business_group_id, null, 0, 1)) AS weight,
516: profile_id
517: FROM pa_role_profiles
518: WHERE resource_id IS NULL
519: AND NVL(position_id,l_position_id) = l_position_id
520: AND NVL(job_id, l_job_id) = l_job_id
521: AND NVL(organization_id,l_organization_id) = l_organization_id

Line 554: FROM pa_role_profiles

550: l_description,
551: l_profile_start_date,
552: l_profile_end_date,
553: l_profile_type_code
554: FROM pa_role_profiles
555: WHERE profile_id = l_profile_id;
556:
557: -- resource_start_date will always be prior to profile_start_date
558: -- Need to check end_date of the new resource profile

Line 568: PA_ROLE_PROFILES_PKG.Insert_Row1

564: END IF;
565:
566: --dbms_output.put_line ('l_end_date: ' || l_end_date);
567:
568: PA_ROLE_PROFILES_PKG.Insert_Row1
569: ( p_profile_name => l_profile_name,
570: p_description => l_description,
571: p_effective_start_date => p_resource_start_date,
572: p_effective_end_date => l_end_date,

Line 587: PA_ROLE_PROFILES_PKG.Insert_Row2

583: FROM pa_role_profile_lines
584: WHERE profile_id = l_profile_id;
585:
586: FOR i IN 1..l_role_id_tbl.count LOOP
587: PA_ROLE_PROFILES_PKG.Insert_Row2
588: ( p_profile_id => l_res_profile_id,
589: p_project_role_id => l_role_id_tbl(i),
590: p_role_weighting => l_weighting_tbl(i),
591: x_return_status => l_return_status);

Line 597: END PA_ROLE_PROFILES_PUB;

593: END IF;
594:
595: END Create_Profile_for_Resource;
596:
597: END PA_ROLE_PROFILES_PUB;