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_R_PROJECT_RESOURCES_PVT dependencies on PA_RESOURCES

Line 45: P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,

41: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE) ;
42:
43: PROCEDURE INSERT_INTO_PA(
44: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,
45: P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
46: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
47: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
48: P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
49: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

Line 46: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895

42:
43: PROCEDURE INSERT_INTO_PA(
44: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,
45: P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
46: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
47: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
48: P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
49: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
50: PERSON_ID%TYPE DEFAULT NULL,

Line 47: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,

43: PROCEDURE INSERT_INTO_PA(
44: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,
45: P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
46: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
47: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
48: P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
49: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
50: PERSON_ID%TYPE DEFAULT NULL,
51: P_NAME IN PA_RESOURCES.NAME%TYPE,

Line 48: P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,

44: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,
45: P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
46: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
47: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
48: P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
49: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
50: PERSON_ID%TYPE DEFAULT NULL,
51: P_NAME IN PA_RESOURCES.NAME%TYPE,
52: P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

Line 51: P_NAME IN PA_RESOURCES.NAME%TYPE,

47: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
48: P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
49: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
50: PERSON_ID%TYPE DEFAULT NULL,
51: P_NAME IN PA_RESOURCES.NAME%TYPE,
52: P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
53: PARTY_ID%TYPE DEFAULT NULL,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
55:

Line 57: P_DEFAULT_OU IN PA_RESOURCES_DENORM.RESOURCE_ORG_ID%TYPE,

53: PARTY_ID%TYPE DEFAULT NULL,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
55:
56: PROCEDURE CHECK_OU(
57: P_DEFAULT_OU IN PA_RESOURCES_DENORM.RESOURCE_ORG_ID%TYPE,
58: P_EXP_ORG IN VARCHAR2,
59: X_EXP_OU OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
61:

Line 65: P_NAME IN PA_RESOURCES.NAME%TYPE,

61:
62:
63: PROCEDURE CREATE_INTERNAL_RESOURCE(
64: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE,
65: P_NAME IN PA_RESOURCES.NAME%TYPE,
66: P_ORGANIZATION_ID IN PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE,
67: P_ASSIGNMENT_START_DATE IN DATE,
68: P_ASSIGNMENT_END_DATE IN DATE,
69: P_START_DATE IN DATE,

Line 77: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895

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,
81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,

Line 123: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE); --File.Sql.39 bug 4440895

119: P_ORG_STR_VERSION_ID IN NUMBER DEFAULT NULL,
120: P_START_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
121: -- End of parameters added for PJR Resource Pull Enhancements - Bug 5130414
122: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
123: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE); --File.Sql.39 bug 4440895
124:
125: PROCEDURE create_future_crm_resource
126: (itemtype IN VARCHAR2
127: , itemkey IN VARCHAR2