APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 13: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

9: G_program_id NUMBER := fnd_global.conc_program_id;
10: G_application_id NUMBER := fnd_global.prog_appl_id;
11:
12: PROCEDURE INSERT_INTO_CRM(
13: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
14: P_PERSON_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
15: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
16: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
17: P_ASSIGNMENT_START_DATE IN DATE,

Line 14: P_PERSON_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,

10: G_application_id NUMBER := fnd_global.prog_appl_id;
11:
12: PROCEDURE INSERT_INTO_CRM(
13: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
14: P_PERSON_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
15: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
16: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
17: P_ASSIGNMENT_START_DATE IN DATE,
18: P_ASSIGNMENT_END_DATE IN DATE,

Line 15: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,

11:
12: PROCEDURE INSERT_INTO_CRM(
13: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
14: P_PERSON_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
15: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
16: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
17: P_ASSIGNMENT_START_DATE IN DATE,
18: P_ASSIGNMENT_END_DATE IN DATE,
19: P_CALENDAR_ID IN NUMBER,

Line 16: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

12: PROCEDURE INSERT_INTO_CRM(
13: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
14: P_PERSON_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
15: P_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
16: P_START_DATE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
17: P_ASSIGNMENT_START_DATE IN DATE,
18: P_ASSIGNMENT_END_DATE IN DATE,
19: P_CALENDAR_ID IN NUMBER,
20: P_COUNT IN NUMBER,

Line 21: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895

17: P_ASSIGNMENT_START_DATE IN DATE,
18: P_ASSIGNMENT_END_DATE IN DATE,
19: P_CALENDAR_ID IN NUMBER,
20: P_COUNT IN NUMBER,
21: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
22: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
24: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,

Line 76: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

72: P_SYSTEM_TYPE IN PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE,
73: P_USER_TYPE IN PER_PERSON_TYPES.USER_PERSON_TYPE%TYPE,
74: P_RES_EXISTS IN VARCHAR2,
75: P_COUNT IN NUMBER,
76: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
77: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
78: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
80: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,

Line 107: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

103: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE,
104: P_INDIVIDUAL IN VARCHAR2,
105: P_CHECK_RESOURCE IN VARCHAR2,
106: P_SCHEDULED_MEMBER_FLAG IN VARCHAR2,
107: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
108: P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PARTY_ID%TYPE,
109: P_FROM_EMP_NUM IN VARCHAR2,
110: P_TO_EMP_NUM IN VARCHAR2,
111: P_ORGANIZATION_ID IN NUMBER,