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_PKG dependencies on PA_ROLE_PROFILE_LINES

Line 81: -- This procedure inserts a row into the pa_role_profile_lines

77: --
78: -- PROCEDURE
79: -- Insert_Row2
80: -- PURPOSE
81: -- This procedure inserts a row into the pa_role_profile_lines
82: -- table.
83:
84: PROCEDURE Insert_Row2
85: ( p_profile_id IN NUMBER,

Line 95: INSERT INTO pa_role_profile_lines

91:
92: BEGIN
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: INSERT INTO pa_role_profile_lines
96: (profile_id,
97: project_role_id,
98: role_weighting,
99: creation_date,

Line 181: * and Role Profile Lines to PA_ROLE_PROFILES and PA_ROLE_PROFILE_LINES

177: ******************************************************************************/
178:
179: /**********************************************************************
180: * This procedure will launch workflow to add a new Resource Role Profile
181: * and Role Profile Lines to PA_ROLE_PROFILES and PA_ROLE_PROFILE_LINES
182: * after proper validation.
183: * This will be called from 'Add Resource Role Profile' page of PJR.
184: **********************************************************************/
185: /*

Line 308: -- Insert Resource Profile Lines to 'PA_ROLE_PROFILE_LINES'

304: profile_id INTO l_profile_id;
305: dbms_output.put_line('after inserting pa_role_profiles, l_profile_id:'||l_profile_id);
306:
307: -------------------------------------------------------------------
308: -- Insert Resource Profile Lines to 'PA_ROLE_PROFILE_LINES'
309: -------------------------------------------------------------------
310: FOR i IN 1..l_role_id_tbl.count LOOP
311: INSERT INTO pa_role_profile_lines
312: (profile_id,

Line 311: INSERT INTO pa_role_profile_lines

307: -------------------------------------------------------------------
308: -- Insert Resource Profile Lines to 'PA_ROLE_PROFILE_LINES'
309: -------------------------------------------------------------------
310: FOR i IN 1..l_role_id_tbl.count LOOP
311: INSERT INTO pa_role_profile_lines
312: (profile_id,
313: project_role_id,
314: role_weighting,
315: creation_date,

Line 360: * and Role Profile Lines in PA_ROLE_PROFILES and PA_ROLE_PROFILE_LINES

356: */
357:
358: /**********************************************************************
359: * This procedure will launch workflow to update the Resource Role Profile
360: * and Role Profile Lines in PA_ROLE_PROFILES and PA_ROLE_PROFILE_LINES
361: * after proper validation.
362: * This will be called from 'Update Resource Role Profile' page of PJR.
363: **********************************************************************/
364: /*

Line 463: -- Insert Resource Profile Lines to 'PA_ROLE_PROFILE_LINES'

459: last_updated_by = FND_GLOBAL.USER_ID
460: WHERE profile_id = p_profile_id;
461:
462: -------------------------------------------------------------------
463: -- Insert Resource Profile Lines to 'PA_ROLE_PROFILE_LINES'
464: -------------------------------------------------------------------
465: -- Delete all roles in the pa_role_profile_lines table before insertion.
466: DELETE FROM pa_role_profile_lines
467: WHERE profile_id = p_profile_id;

Line 465: -- Delete all roles in the pa_role_profile_lines table before insertion.

461:
462: -------------------------------------------------------------------
463: -- Insert Resource Profile Lines to 'PA_ROLE_PROFILE_LINES'
464: -------------------------------------------------------------------
465: -- Delete all roles in the pa_role_profile_lines table before insertion.
466: DELETE FROM pa_role_profile_lines
467: WHERE profile_id = p_profile_id;
468:
469: FOR i IN 1..l_role_id_tbl.count LOOP

Line 466: DELETE FROM pa_role_profile_lines

462: -------------------------------------------------------------------
463: -- Insert Resource Profile Lines to 'PA_ROLE_PROFILE_LINES'
464: -------------------------------------------------------------------
465: -- Delete all roles in the pa_role_profile_lines table before insertion.
466: DELETE FROM pa_role_profile_lines
467: WHERE profile_id = p_profile_id;
468:
469: FOR i IN 1..l_role_id_tbl.count LOOP
470: INSERT INTO pa_role_profile_lines

Line 470: INSERT INTO pa_role_profile_lines

466: DELETE FROM pa_role_profile_lines
467: WHERE profile_id = p_profile_id;
468:
469: FOR i IN 1..l_role_id_tbl.count LOOP
470: INSERT INTO pa_role_profile_lines
471: (profile_id,
472: project_role_id,
473: role_weighting,
474: creation_date,