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,
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,
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,
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,
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,
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,
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,
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: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
39: ) IS
40:
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: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
39: ) IS
40:
41: l_api_version CONSTANT NUMBER := 1.0;
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: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
39: ) IS
40:
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
39: ) IS
40:
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
43: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
44: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
45: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
46: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
47: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
40:
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
43: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
44: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
45: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
46: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
47: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
48: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
43: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
44: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
45: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
46: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
47: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
48: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
49: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
43: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
44: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
45: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
46: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
47: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
48: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
49: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
50: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
43: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
44: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
45: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
46: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
47: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
48: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
49: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
50: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
51: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
44: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
45: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
46: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
47: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
48: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
49: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
50: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
51: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
52: current_record INTEGER;
45: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
46: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
47: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
48: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
49: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
50: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
51: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
52: current_record INTEGER;
53:
47: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
48: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
49: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
50: l_group_member_id jtf_rs_group_members.group_member_id%TYPE;
51: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
52: current_record INTEGER;
53:
54:
55: BEGIN
241: PROCEDURE create_resource_group_migrate
242: (P_API_VERSION IN NUMBER,
243: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
244: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
245: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
246: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
247: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
248: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
242: (P_API_VERSION IN NUMBER,
243: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
244: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
245: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
246: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
247: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
248: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
243: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
244: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
245: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
246: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
247: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
248: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
244: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
245: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
246: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
247: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
248: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
245: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
246: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
247: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
248: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
246: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
247: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
248: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
247: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
248: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
248: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
249: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
250: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
251: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
252: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
253: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
254: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
255: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
256: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
257: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
265: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
258: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
265: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
266: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
259: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
265: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
266: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
267: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
260: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
265: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
266: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
267: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
268: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
261: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
265: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
266: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
267: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
268: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
269: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
262: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
265: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
266: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
267: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
268: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
269: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
270: X_MSG_COUNT OUT NOCOPY NUMBER,
263: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
265: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
266: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
267: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
268: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
269: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
270: X_MSG_COUNT OUT NOCOPY NUMBER,
271: X_MSG_DATA OUT NOCOPY VARCHAR2,
264: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
265: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
266: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
267: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
268: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
269: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
270: X_MSG_COUNT OUT NOCOPY NUMBER,
271: X_MSG_DATA OUT NOCOPY VARCHAR2,
272: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
268: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
269: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
270: X_MSG_COUNT OUT NOCOPY NUMBER,
271: X_MSG_DATA OUT NOCOPY VARCHAR2,
272: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
273: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
274: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
275: ) IS
276:
269: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
270: X_MSG_COUNT OUT NOCOPY NUMBER,
271: X_MSG_DATA OUT NOCOPY VARCHAR2,
272: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
273: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
274: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
275: ) IS
276:
277: BEGIN
270: X_MSG_COUNT OUT NOCOPY NUMBER,
271: X_MSG_DATA OUT NOCOPY VARCHAR2,
272: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
273: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
274: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
275: ) IS
276:
277: BEGIN
278:
323: PROCEDURE update_resource_group
324: (P_API_VERSION IN NUMBER,
325: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
326: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
327: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
328: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
329: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
330: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
324: (P_API_VERSION IN NUMBER,
325: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
326: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
327: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
328: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
329: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
330: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
325: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
326: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
327: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
328: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
329: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
330: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
333: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
326: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
327: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
328: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
329: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
330: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
333: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
334: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
327: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
328: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
329: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
330: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
333: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
334: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
335: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
328: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
329: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
330: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
333: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
334: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
335: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
336: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
329: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
330: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
333: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
334: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
335: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
336: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
337: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
330: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
333: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
334: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
335: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
336: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
337: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
338: X_MSG_COUNT OUT NOCOPY NUMBER,
331: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
333: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
334: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
335: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
336: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
337: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
338: X_MSG_COUNT OUT NOCOPY NUMBER,
339: X_MSG_DATA OUT NOCOPY VARCHAR2,
332: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
333: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
334: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
335: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
336: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
337: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
338: X_MSG_COUNT OUT NOCOPY NUMBER,
339: X_MSG_DATA OUT NOCOPY VARCHAR2,
340: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM
336: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
337: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
338: X_MSG_COUNT OUT NOCOPY NUMBER,
339: X_MSG_DATA OUT NOCOPY VARCHAR2,
340: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM
341: ) IS
342:
343: l_api_version CONSTANT NUMBER := 1.0;
344: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
341: ) IS
342:
343: l_api_version CONSTANT NUMBER := 1.0;
344: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
345: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
346: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
347: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
348: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
342:
343: l_api_version CONSTANT NUMBER := 1.0;
344: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
345: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
346: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
347: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
348: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
343: l_api_version CONSTANT NUMBER := 1.0;
344: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
345: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
346: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
347: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
348: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
344: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
345: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
346: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
347: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
348: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
352: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
345: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
346: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
347: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
348: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
352: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
353: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
346: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
347: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
348: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
352: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
353: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
354: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
347: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
348: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
352: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
353: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
354: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
355: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
348: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
352: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
353: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
354: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
355: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
356:
349: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
352: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
353: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
354: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
355: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
356:
357: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;
350: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
352: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
353: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
354: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
355: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
356:
357: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;
358:
351: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := p_start_date_active;
352: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := p_end_date_active;
353: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
354: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
355: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
356:
357: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;
358:
359: BEGIN
353: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
354: l_object_version_num jtf_rs_groups_vl.object_version_number%TYPE := p_object_version_num;
355: l_time_zone jtf_rs_groups_vl.time_zone%TYPE := p_time_zone;
356:
357: l_group_id_out jtf_rs_groups_vl.group_id%TYPE;
358:
359: BEGIN
360:
361: