22: X_MSG_COUNT OUT NOCOPY NUMBER,
23: X_MSG_DATA OUT NOCOPY VARCHAR2 );
24:
25: /*FOR INSERT IN JTF_RS_ROLE_RELATIONS */
26: --SHOULD BE CALLED from the api jtf_rs_groups_denorm.delete_resource_group_relate
27: -- not being used anymore
28: PROCEDURE INSERT_REP_MGR_PARENT(
29: P_API_VERSION IN NUMBER,
30: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,
97: X_MSG_DATA OUT NOCOPY VARCHAR2 );
98:
99: -- FOR DELETE ON JTF_RS_GROUPS_DENORM
100: -- SHOULD BE CALLED BEFORE THE DENORM RECORD IS ACTUALLY DELETED FROM THE TABLE
101: -- being used after 23 apr 2004
102: PROCEDURE DELETE_GROUP_DENORM(
103: P_API_VERSION IN NUMBER,
102: PROCEDURE DELETE_GROUP_DENORM(
103: P_API_VERSION IN NUMBER,
104: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106: P_DENORM_GRP_ID IN JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE,
107: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
108: X_MSG_COUNT OUT NOCOPY NUMBER,
109: X_MSG_DATA OUT NOCOPY VARCHAR2 );
110:
107: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
108: X_MSG_COUNT OUT NOCOPY NUMBER,
109: X_MSG_DATA OUT NOCOPY VARCHAR2 );
110:
111: --to be called from jtf_rs_groups_denorm_pvt.update_groups
112: PROCEDURE DELETE_REP_MGR (
113: P_API_VERSION IN NUMBER,
114: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112: PROCEDURE DELETE_REP_MGR (
113: P_API_VERSION IN NUMBER,
114: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
117: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
118: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
119: X_MSG_COUNT OUT NOCOPY NUMBER,
120: X_MSG_DATA OUT NOCOPY VARCHAR2);
113: P_API_VERSION IN NUMBER,
114: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
117: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
118: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
119: X_MSG_COUNT OUT NOCOPY NUMBER,
120: X_MSG_DATA OUT NOCOPY VARCHAR2);
121: