DBA Data[Home] [Help]

APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 49: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

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.
53: PARTY_ID%TYPE DEFAULT NULL,

Line 52: P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.

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:
56: PROCEDURE CHECK_OU(

Line 64: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE,

60: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
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,

Line 103: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE,

99: PROCEDURE CREATE_RESOURCE(
100: P_COMMIT IN VARCHAR2,
101: P_VALIDATE_ONLY IN VARCHAR2,
102: P_INTERNAL IN VARCHAR2,
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,

Line 108: P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PARTY_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,
112: P_REFRESH IN VARCHAR2,