DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_AUD_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 18: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,

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,
22: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 19: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,

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,
22: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,

Line 20: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

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,
22: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
24: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 21: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

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,
22: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
24: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
25: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 22: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

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,
22: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
24: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
25: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 23: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%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,
22: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
24: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
25: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26: X_MSG_COUNT OUT NOCOPY NUMBER,
27: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 24: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%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,
22: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
24: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
25: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26: X_MSG_COUNT OUT NOCOPY NUMBER,
27: X_MSG_DATA OUT NOCOPY VARCHAR2 );
28:

Line 35: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,

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,
39: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 36: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,

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,
39: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,

Line 37: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

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,
39: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
41: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 38: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

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,
39: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
41: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 39: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

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,
39: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
41: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 40: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%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,
39: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
41: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 41: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%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,
39: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
41: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2);
45: