DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PUB dependencies on JTF_RS_GROUPS_VL

Line 26: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,

22: PROCEDURE create_resource_group
23: (P_API_VERSION IN NUMBER,
24: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
27: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
28: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
29: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
30: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

Line 27: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,

23: (P_API_VERSION IN NUMBER,
24: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
27: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
28: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
29: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
30: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 28: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',

24: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
27: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
28: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
29: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
30: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
32: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,

Line 29: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,

25: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
27: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
28: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
29: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
30: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
32: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 30: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

26: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
27: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
28: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
29: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
30: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
32: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 31: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

27: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
28: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
29: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
30: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
32: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 32: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,

28: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
29: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
30: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
32: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 36: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

32: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
37: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
38: ) IS
39:
40: l_api_version CONSTANT NUMBER := 1.0;

Line 37: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE

33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
37: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
38: ) IS
39:
40: l_api_version CONSTANT NUMBER := 1.0;
41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';

Line 42: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;

38: ) IS
39:
40: l_api_version CONSTANT NUMBER := 1.0;
41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
42: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
43: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
44: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;

Line 43: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;

39:
40: l_api_version CONSTANT NUMBER := 1.0;
41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
42: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
43: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
44: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;

Line 44: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');

40: l_api_version CONSTANT NUMBER := 1.0;
41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
42: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
43: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
44: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
48: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;

Line 45: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;

41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
42: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
43: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
44: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
48: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
49: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;

Line 46: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;

42: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
43: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
44: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
48: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
49: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
50: current_record INTEGER;

Line 47: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;

43: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
44: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
48: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
49: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
50: current_record INTEGER;
51:

Line 48: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;

44: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
48: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
49: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
50: current_record INTEGER;
51:
52:

Line 217: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,

213: PROCEDURE create_resource_group_migrate
214: (P_API_VERSION IN NUMBER,
215: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
216: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
218: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
219: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

Line 218: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,

214: (P_API_VERSION IN NUMBER,
215: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
216: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
218: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
219: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 219: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',

215: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
216: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
218: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
219: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,

Line 220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,

216: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
218: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
219: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

217: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
218: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
219: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

218: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
219: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,

219: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

220: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,

221: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,

222: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,

223: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,

224: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,

225: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,

226: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,

227: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,

228: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,

229: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,

230: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
238: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,

231: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
238: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
239: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,

232: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
238: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
239: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
240: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,

233: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
238: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
239: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
240: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
241: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 238: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,

234: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
238: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
239: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
240: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
241: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
242: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 239: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,

235: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
238: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
239: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
240: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
241: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
242: X_MSG_COUNT OUT NOCOPY NUMBER,
243: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 240: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

236: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
237: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
238: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
239: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
240: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
241: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
242: X_MSG_COUNT OUT NOCOPY NUMBER,
243: X_MSG_DATA OUT NOCOPY VARCHAR2,
244: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 244: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

240: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
241: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
242: X_MSG_COUNT OUT NOCOPY NUMBER,
243: X_MSG_DATA OUT NOCOPY VARCHAR2,
244: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
245: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
246: ) IS
247:
248: BEGIN

Line 245: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE

241: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
242: X_MSG_COUNT OUT NOCOPY NUMBER,
243: X_MSG_DATA OUT NOCOPY VARCHAR2,
244: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
245: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
246: ) IS
247:
248: BEGIN
249:

Line 297: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

293: PROCEDURE update_resource_group
294: (P_API_VERSION IN NUMBER,
295: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
296: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
298: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
299: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 298: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,

294: (P_API_VERSION IN NUMBER,
295: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
296: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
298: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
299: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 299: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

295: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
296: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
298: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
299: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

296: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
297: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
298: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
299: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
304: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

297: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
298: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
299: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
304: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
305: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

298: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
299: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
304: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
305: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
306: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,

Line 303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

299: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
304: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
305: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
306: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
307: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 304: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

300: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
304: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
305: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
306: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
307: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
308: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 305: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

301: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
304: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
305: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
306: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
307: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
308: X_MSG_COUNT OUT NOCOPY NUMBER,
309: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 306: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,

302: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
303: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
304: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
305: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
306: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
307: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
308: X_MSG_COUNT OUT NOCOPY NUMBER,
309: X_MSG_DATA OUT NOCOPY VARCHAR2
310: ) IS

Line 314: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;

310: ) IS
311:
312: l_api_version CONSTANT NUMBER := 1.0;
313: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
314: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
315: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
316: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;

Line 315: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;

311:
312: l_api_version CONSTANT NUMBER := 1.0;
313: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
314: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
315: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
316: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;

Line 316: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;

312: l_api_version CONSTANT NUMBER := 1.0;
313: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
314: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
315: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
316: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;

Line 317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;

313: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
314: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
315: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
316: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;

Line 318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;

314: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
315: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
316: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
322: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;

Line 319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;

315: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
316: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
322: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
323: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;

Line 320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;

316: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
322: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
323: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
324:

Line 321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;

317: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
322: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
323: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
324:
325: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;

Line 322: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;

318: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
322: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
323: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
324:
325: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;
326:

Line 323: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;

319: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
320: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
322: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
323: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
324:
325: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;
326:
327: BEGIN

Line 325: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;

321: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
322: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
323: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
324:
325: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;
326:
327: BEGIN
328:
329: