APPS.PA_ROLE_PROFILES_PUB dependencies on PA_ROLE_PROFILE_LINES

Line 207: -- pa_role_profile_lines table does not need sequence

203: p_role_weighting => p_weighting_tbl(i),
204: x_return_status => l_return_status);
205: END LOOP;
206:
207: -- pa_role_profile_lines table does not need sequence
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;

Line 423: -- Delete all roles in the pa_role_profile_lines table

419: p_job_id => l_job_id,
420: p_position_id => l_position_id,
421: x_return_status => l_return_status);
422:
423: -- Delete all roles in the pa_role_profile_lines table
424: DELETE FROM pa_role_profile_lines
425: WHERE profile_id = p_profile_id;
426:
427: -- Insert roles into the pa_role_profile_lines table

Line 424: DELETE FROM pa_role_profile_lines

420: p_position_id => l_position_id,
421: x_return_status => l_return_status);
422:
423: -- Delete all roles in the pa_role_profile_lines table
424: DELETE FROM pa_role_profile_lines
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

Line 427: -- Insert roles into the pa_role_profile_lines table

423: -- Delete all roles in the pa_role_profile_lines table
424: DELETE FROM pa_role_profile_lines
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),

Line 436: -- pa_role_profile_lines table does not need sequence

432: p_role_weighting => p_weighting_tbl(i),
433: x_return_status => l_return_status);
434: END LOOP;
435:
436: -- pa_role_profile_lines table does not need sequence
437:
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;

Line 469: DELETE FROM pa_role_profile_lines

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;
471: EXCEPTION
472: WHEN OTHERS THEN
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 583: FROM pa_role_profile_lines

579: SELECT project_role_id,
580: role_weighting
581: BULK COLLECT INTO l_role_id_tbl,
582: l_weighting_tbl
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