12:
13: /*FOR INSERT */
14: PROCEDURE INSERT_GROUP_RELATE(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
19: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
20: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
13: /*FOR INSERT */
14: PROCEDURE INSERT_GROUP_RELATE(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
19: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
20: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
21: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
29:
30: /*FOR UPDATE */
31: PROCEDURE UPDATE_GROUP_RELATE(
32: P_API_VERSION IN NUMBER,
33: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
36: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
37: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
30: /*FOR UPDATE */
31: PROCEDURE UPDATE_GROUP_RELATE(
32: P_API_VERSION IN NUMBER,
33: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
36: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
37: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
38: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
47: --FOR DELETE
48:
49: PROCEDURE DELETE_GROUP_RELATE(
50: P_API_VERSION IN NUMBER,
51: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: P_GROUP_RELATE_ID IN NUMBER,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: X_MSG_COUNT OUT NOCOPY NUMBER,
48:
49: PROCEDURE DELETE_GROUP_RELATE(
50: P_API_VERSION IN NUMBER,
51: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: P_GROUP_RELATE_ID IN NUMBER,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: X_MSG_COUNT OUT NOCOPY NUMBER,
56: X_MSG_DATA OUT NOCOPY VARCHAR2 );