DBA Data[Home] [Help]

APPS.JTF_RS_DYNAMIC_GROUPS_PVT dependencies on FND_API

Line 20: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

16: based on input values passed by calling routines. */
17:
18: PROCEDURE create_dynamic_groups
19: (P_API_VERSION IN NUMBER,
20: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
23: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
24: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,

Line 21: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

17:
18: PROCEDURE create_dynamic_groups
19: (P_API_VERSION IN NUMBER,
20: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE,
23: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT NULL,
24: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,

Line 57: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

53: based on input values passed by calling routines. */
54:
55: PROCEDURE update_dynamic_groups
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_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
60: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

54:
55: PROCEDURE update_dynamic_groups
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_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
60: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

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_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
60: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
60: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,

59: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
60: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,

Line 64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

60: P_GROUP_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

61: P_GROUP_NAME IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,

62: P_GROUP_DESC IN JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

64: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

65: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

66: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

67: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

68: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

69: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

70: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

71: P_ATTRIBUTE4 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

72: P_ATTRIBUTE5 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

73: P_ATTRIBUTE6 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

74: P_ATTRIBUTE7 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

75: P_ATTRIBUTE8 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

76: P_ATTRIBUTE9 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 81: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

77: P_ATTRIBUTE10 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 82: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

78: P_ATTRIBUTE11 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,
86: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 83: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

79: P_ATTRIBUTE12 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,
86: X_MSG_DATA OUT NOCOPY VARCHAR2
87: );

Line 94: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

90: /* Procedure to delete the Dynamic Groups. */
91:
92: PROCEDURE delete_dynamic_groups
93: (P_API_VERSION IN NUMBER,
94: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
97: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 95: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

91:
92: PROCEDURE delete_dynamic_groups
93: (P_API_VERSION IN NUMBER,
94: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96: P_GROUP_ID IN JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
97: P_OBJECT_VERSION_NUMBER IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
99: X_MSG_COUNT OUT NOCOPY NUMBER,