eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUP_RELATE_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 26: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

22: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
25: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
25: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

24: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
25: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,

25: P_RELATED_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
26: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,

26: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

27: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

28: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

29: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

30: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

31: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

32: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

33: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,

34: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,

35: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,

36: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,

37: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 42: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,

38: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 43: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,

39: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

40: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE

Line 48: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE

44: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE
49: );
50:
51:
52: /* Procedure to update the resource group relation

Line 59: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

55: PROCEDURE update_resource_group_relate
56: (P_API_VERSION IN NUMBER,
57: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
60: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
61: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
63: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 60: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

56: (P_API_VERSION IN NUMBER,
57: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
60: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
61: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
63: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 61: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

57: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
60: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
61: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
63: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 91: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

87: PROCEDURE delete_resource_group_relate
88: (P_API_VERSION IN NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
92: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94: X_MSG_COUNT OUT NOCOPY NUMBER,
95: X_MSG_DATA OUT NOCOPY VARCHAR2