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_MEMBERS_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1: PACKAGE jtf_rs_group_members_pvt AUTHID CURRENT_USER AS

1: PACKAGE jtf_rs_group_members_pvt AUTHID CURRENT_USER AS
2: /* $Header: jtfrsvms.pls 120.0 2005/05/11 08:23:09 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that caller will invoke.

Line 28: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

24: PROCEDURE assign_value_to_global
25: (P_API_VERSION IN NUMBER,
26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
29: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
30: X_MSG_COUNT OUT NOCOPY NUMBER,
31: X_MSG_DATA OUT NOCOPY VARCHAR2
32: );

Line 41: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

37: PROCEDURE create_resource_group_members
38: (P_API_VERSION IN NUMBER,
39: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
42: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
43: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 42: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

38: (P_API_VERSION IN NUMBER,
39: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
42: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
43: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 43: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,

39: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
42: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
43: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,

40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
42: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
43: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,

41: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
42: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
43: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,

42: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
43: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,

43: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT NULL,
44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,

44: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT NULL,
45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,

45: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT NULL,
46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,

46: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT NULL,
47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,

47: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT NULL,
48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,

48: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT NULL,
49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
56: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,

49: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT NULL,
50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
56: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
57: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,

50: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT NULL,
51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
56: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
57: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
58: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,

51: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT NULL,
52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
56: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
57: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
58: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 56: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,

52: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT NULL,
53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
56: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
57: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
58: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 57: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,

53: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT NULL,
54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
56: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
57: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
58: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 58: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

54: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT NULL,
55: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT NULL,
56: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT NULL,
57: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT NULL,
58: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,
62: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE

Line 62: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE

58: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,
62: X_GROUP_MEMBER_ID OUT NOCOPY JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE
63: );
64:
65: /* Procedure to update the resource group members. */
66:

Line 71: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,

67: PROCEDURE update_resource_group_members
68: (P_API_VERSION IN NUMBER,
69: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
72: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
73: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 72: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

68: (P_API_VERSION IN NUMBER,
69: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
72: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
73: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 73: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

69: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
72: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
73: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

70: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
72: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
73: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

71: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
72: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
73: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

72: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
73: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

73: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

74: P_PERSON_ID IN JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

75: P_DELETE_FLAG IN JTF_RS_GROUP_MEMBERS.DELETE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

76: P_ATTRIBUTE1 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

77: P_ATTRIBUTE2 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

78: P_ATTRIBUTE3 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

79: P_ATTRIBUTE4 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

80: P_ATTRIBUTE5 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

81: P_ATTRIBUTE6 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

82: P_ATTRIBUTE7 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
90: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

83: P_ATTRIBUTE8 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
90: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
91: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

84: P_ATTRIBUTE9 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
90: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
91: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
92: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

Line 89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

85: P_ATTRIBUTE10 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
90: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
91: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
92: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 90: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

86: P_ATTRIBUTE11 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
90: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
91: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
92: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 91: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

87: P_ATTRIBUTE12 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
90: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
91: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
92: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.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

Line 92: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

88: P_ATTRIBUTE13 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
89: P_ATTRIBUTE14 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
90: P_ATTRIBUTE15 IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
91: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUP_MEMBERS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
92: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_MEMBERS.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
96: );

Line 105: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

101: PROCEDURE delete_resource_group_members
102: (P_API_VERSION IN NUMBER,
103: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
106: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
107: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
108: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
109: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 106: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

102: (P_API_VERSION IN NUMBER,
103: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
106: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
107: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
108: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
109: X_MSG_COUNT OUT NOCOPY NUMBER,
110: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 107: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

103: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
106: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
107: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
108: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
109: X_MSG_COUNT OUT NOCOPY NUMBER,
110: X_MSG_DATA OUT NOCOPY VARCHAR2
111: );

Line 119: P_OLD_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

115: PROCEDURE execute_sales_hook
116: (P_API_VERSION IN NUMBER,
117: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
118: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
119: P_OLD_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
120: P_NEW_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
121: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
122: P_OLD_START_DATE IN DATE,
123: P_OLD_END_DATE IN DATE,

Line 120: P_NEW_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

116: (P_API_VERSION IN NUMBER,
117: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
118: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
119: P_OLD_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
120: P_NEW_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
121: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
122: P_OLD_START_DATE IN DATE,
123: P_OLD_END_DATE IN DATE,
124: P_NEW_START_DATE IN DATE,

Line 128: END jtf_rs_group_members_pvt;

124: P_NEW_START_DATE IN DATE,
125: P_NEW_END_DATE IN DATE,
126: X_RETURN_STATUS OUT NOCOPY VARCHAR2
127: );
128: END jtf_rs_group_members_pvt;