DBA Data[Home] [Help]

APPS.JTF_RS_ROLES_PUB dependencies on JTF_RS_ROLES_B

Line 54: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

50: PROCEDURE create_rs_resource_roles (
51: P_API_VERSION IN NUMBER,
52: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
55: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
56: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
57: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
58: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',

Line 55: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

51: P_API_VERSION IN NUMBER,
52: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
55: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
56: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
57: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
58: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
59: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',

Line 58: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',

54: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
55: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
56: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
57: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
58: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
59: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
60: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
61: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
62: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',

Line 59: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',

55: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
56: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
57: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
58: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
59: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
60: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
61: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
62: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
63: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',

Line 60: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',

56: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
57: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
58: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
59: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
60: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
61: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
62: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
63: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 61: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',

57: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
58: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
59: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
60: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
61: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
62: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
63: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
65: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 62: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',

58: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
59: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
60: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
61: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
62: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
63: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
65: X_MSG_COUNT OUT NOCOPY NUMBER,
66: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 63: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',

59: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
60: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
61: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
62: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
63: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
65: X_MSG_COUNT OUT NOCOPY NUMBER,
66: X_MSG_DATA OUT NOCOPY VARCHAR2,
67: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE

Line 67: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE

63: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
65: X_MSG_COUNT OUT NOCOPY NUMBER,
66: X_MSG_DATA OUT NOCOPY VARCHAR2,
67: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
68: );
69:
70: --PROCEDURE to update the resource roles based on input values passed by calling routines
71:

Line 100: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

96: PROCEDURE update_rs_resource_roles (
97: P_API_VERSION IN NUMBER,
98: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
101: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
102: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
103: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
104: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 101: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

97: P_API_VERSION IN NUMBER,
98: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
101: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
102: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
103: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
104: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
105: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 102: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

98: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
101: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
102: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
103: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
104: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
105: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
106: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 105: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

101: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
102: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
103: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
104: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
105: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
106: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
107: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
108: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
109: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 106: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

102: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
103: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
104: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
105: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
106: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
107: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
108: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
109: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
110: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 107: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

103: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
104: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
105: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
106: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
107: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
108: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
109: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
110: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
111: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,

Line 108: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

104: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
105: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
106: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
107: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
108: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
109: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
110: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
111: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
112: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 109: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

105: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
106: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
107: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
108: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
109: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
110: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
111: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
112: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 110: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

106: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
107: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
108: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
109: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
110: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
111: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
112: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113: X_MSG_COUNT OUT NOCOPY NUMBER,
114: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 111: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,

107: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
108: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
109: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
110: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
111: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
112: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113: X_MSG_COUNT OUT NOCOPY NUMBER,
114: X_MSG_DATA OUT NOCOPY VARCHAR2
115: );

Line 138: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

134: PROCEDURE delete_rs_resource_roles (
135: P_API_VERSION IN NUMBER,
136: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
138: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
139: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
140: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
141: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
142: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 139: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

135: P_API_VERSION IN NUMBER,
136: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
138: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
139: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
140: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
141: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
142: X_MSG_COUNT OUT NOCOPY NUMBER,
143: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 140: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,

136: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
138: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
139: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
140: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
141: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
142: X_MSG_COUNT OUT NOCOPY NUMBER,
143: X_MSG_DATA OUT NOCOPY VARCHAR2
144: );