DBA Data[Home] [Help]

APPS.PA_ROLE_PROFILES_PUB dependencies on PA_ROLE_PROFILES_PKG

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 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 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);