APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PER_PERSON_TYPES

Line 287: per_person_types ptype

283: cursor get_person_type
284: is
285: select person_id
286: from per_people_f per,
287: per_person_types ptype
288: where per.person_id = p_person_id
289: and per.person_type_id = ptype.person_type_id
290: and (ptype.system_person_type = 'EMP'
291: OR ptype.system_person_type = 'EMP_APL');

Line 1415: P_SYSTEM_TYPE IN PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE,

1411: P_ASSIGNMENT_END_DATE IN DATE,
1412: P_START_DATE IN DATE,
1413: P_DEFAULT_OU IN NUMBER,
1414: P_CALENDAR_ID IN NUMBER,
1415: P_SYSTEM_TYPE IN PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE,
1416: P_USER_TYPE IN PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE,
1417: P_RES_EXISTS IN VARCHAR2,
1418: P_COUNT IN NUMBER,
1419: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

Line 1416: P_USER_TYPE IN PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE,

1412: P_START_DATE IN DATE,
1413: P_DEFAULT_OU IN NUMBER,
1414: P_CALENDAR_ID IN NUMBER,
1415: P_SYSTEM_TYPE IN PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE,
1416: P_USER_TYPE IN PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE,
1417: P_RES_EXISTS IN VARCHAR2,
1418: P_COUNT IN NUMBER,
1419: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1420: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895

Line 1981: l_system_type PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE;

1977: l_assignment_end_date DATE;
1978: l_start_date DATE;
1979: l_default_OU NUMBER;
1980: l_calendar_id NUMBER;
1981: l_system_type PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE;
1982: l_user_type PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE;
1983: l_res_exists VARCHAR2(20);
1984: l_exists VARCHAR2(1) := 'N';
1985: l_exp_org VARCHAR2(10);

Line 1982: l_user_type PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE;

1978: l_start_date DATE;
1979: l_default_OU NUMBER;
1980: l_calendar_id NUMBER;
1981: l_system_type PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE;
1982: l_user_type PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE;
1983: l_res_exists VARCHAR2(20);
1984: l_exists VARCHAR2(1) := 'N';
1985: l_exp_org VARCHAR2(10);
1986: l_job_utilization VARCHAR2(1) := 'N';