49: * @rep:businessevent oracle.apps.jtf.jres.rolerelate.create
50: */
51: PROCEDURE create_resource_role_relate
52: (P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
56: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
57: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
50: */
51: PROCEDURE create_resource_role_relate
52: (P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
56: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
57: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
58: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
86: * @rep:businessevent oracle.apps.jtf.jres.rolerelate.update
87: */
88: PROCEDURE update_resource_role_relate
89: (P_API_VERSION IN NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
87: */
88: PROCEDURE update_resource_role_relate
89: (P_API_VERSION IN NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
95: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
89: (P_API_VERSION IN NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
95: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
96: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
97: X_MSG_COUNT OUT NOCOPY NUMBER,
90: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
93: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
95: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
96: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
97: X_MSG_COUNT OUT NOCOPY NUMBER,
98: X_MSG_DATA OUT NOCOPY VARCHAR2
118: * @rep:businessevent oracle.apps.jtf.jres.rolerelate.delete
119: */
120: PROCEDURE delete_resource_role_relate
121: (P_API_VERSION IN NUMBER,
122: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
125: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
126: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
119: */
120: PROCEDURE delete_resource_role_relate
121: (P_API_VERSION IN NUMBER,
122: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
125: P_OBJECT_VERSION_NUM IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
126: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
127: X_MSG_COUNT OUT NOCOPY NUMBER,