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_NUM_TBL_TYPE

Line 22: p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

18: p_profile_name IN VARCHAR2,
19: p_description IN VARCHAR2,
20: p_effective_start_date IN DATE,
21: p_effective_end_date IN DATE DEFAULT NULL,
22: p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
23: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
24: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
25: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
26: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 24: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

20: p_effective_start_date IN DATE,
21: p_effective_end_date IN DATE DEFAULT NULL,
22: p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
23: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
24: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
25: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
26: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
27: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
28:

Line 34: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

30: l_organization_id NUMBER;
31: l_job_id NUMBER;
32: l_position_id NUMBER;
33: l_profile_id NUMBER;
34: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
35: l_exists VARCHAR2(1) := 'N';
36: l_error_msg_code VARCHAR2(500);
37: l_return_status VARCHAR2(1);
38: l_prev_profile_id NUMBER := NULL;

Line 244: p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

240: p_profile_name IN VARCHAR2,
241: p_description IN VARCHAR2,
242: p_effective_start_date IN DATE,
243: p_effective_end_date IN DATE DEFAULT NULL,
244: p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
245: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
246: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
247: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
248: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 246: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

242: p_effective_start_date IN DATE,
243: p_effective_end_date IN DATE DEFAULT NULL,
244: p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
245: p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
246: p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
247: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
248: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
249: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
250:

Line 255: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

251: l_business_group_id NUMBER;
252: l_organization_id NUMBER;
253: l_job_id NUMBER;
254: l_position_id NUMBER;
255: l_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
256: l_exists VARCHAR2(1) := 'N';
257: l_error_msg_code VARCHAR2(500);
258: l_return_status VARCHAR2(1);
259: l_prev_profile_id NUMBER := NULL;