eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUPS_PVT dependencies on JTF_RS_GROUPS_VL

Line 25: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,

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

Line 26: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,

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

Line 27: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,

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

Line 28: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,

24: P_COMMIT IN VARCHAR2,
25: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
26: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,

Line 29: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

25: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
26: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,

Line 30: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,

26: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,

Line 31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,

27: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,

Line 32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,

28: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,

Line 33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,

29: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,

Line 34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,

30: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,

Line 35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,

31: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,

Line 36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,

32: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,

Line 37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,

33: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,

Line 38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,

34: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,

Line 39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,

35: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,

Line 40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,

36: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,

Line 41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,

37: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,

Line 42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,

38: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,

Line 43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,

39: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,

Line 44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,

40: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 45: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,

41: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 46: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,

42: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,
50: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 47: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,

43: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,
50: X_MSG_DATA OUT NOCOPY VARCHAR2,
51: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

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

47: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,
50: X_MSG_DATA OUT NOCOPY VARCHAR2,
51: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
52: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
53: ) IS
54:
55: l_api_version CONSTANT NUMBER := 1.0;

Line 52: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE

48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,
50: X_MSG_DATA OUT NOCOPY VARCHAR2,
51: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
52: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
53: ) IS
54:
55: l_api_version CONSTANT NUMBER := 1.0;
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';

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

54:
55: l_api_version CONSTANT NUMBER := 1.0;
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
57: l_rowid ROWID;
58: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
59: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
60: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
61: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);

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

55: l_api_version CONSTANT NUMBER := 1.0;
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
57: l_rowid ROWID;
58: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
59: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
60: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
61: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);

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

56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_GROUP';
57: l_rowid ROWID;
58: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
59: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
60: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
61: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
64: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;

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

57: l_rowid ROWID;
58: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
59: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
60: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
61: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
64: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
65: l_group_id jtf_rs_groups_vl.group_id%TYPE;

Line 62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);

58: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
59: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
60: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
61: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
64: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
65: l_group_id jtf_rs_groups_vl.group_id%TYPE;
66: l_group_number jtf_rs_groups_vl.group_number%TYPE;

Line 63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);

59: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
60: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
61: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
64: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
65: l_group_id jtf_rs_groups_vl.group_id%TYPE;
66: l_group_number jtf_rs_groups_vl.group_number%TYPE;
67: l_check_char VARCHAR2(1);

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

60: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
61: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
64: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
65: l_group_id jtf_rs_groups_vl.group_id%TYPE;
66: l_group_number jtf_rs_groups_vl.group_number%TYPE;
67: l_check_char VARCHAR2(1);
68: l_check_dup_id VARCHAR2(1);

Line 65: l_group_id jtf_rs_groups_vl.group_id%TYPE;

61: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
64: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
65: l_group_id jtf_rs_groups_vl.group_id%TYPE;
66: l_group_number jtf_rs_groups_vl.group_number%TYPE;
67: l_check_char VARCHAR2(1);
68: l_check_dup_id VARCHAR2(1);
69: l_bind_data_id NUMBER;

Line 66: l_group_number jtf_rs_groups_vl.group_number%TYPE;

62: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
63: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
64: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
65: l_group_id jtf_rs_groups_vl.group_id%TYPE;
66: l_group_number jtf_rs_groups_vl.group_number%TYPE;
67: l_check_char VARCHAR2(1);
68: l_check_dup_id VARCHAR2(1);
69: l_bind_data_id NUMBER;
70: l_return_status VARCHAR2(1);

Line 79: CURSOR c_dup_group_id (l_group_id IN jtf_rs_groups_vl.group_id%type) IS

75: SELECT 'Y'
76: FROM jtf_rs_groups_b
77: WHERE ROWID = l_rowid;
78:
79: CURSOR c_dup_group_id (l_group_id IN jtf_rs_groups_vl.group_id%type) IS
80: SELECT 'X'
81: FROM jtf_rs_groups_vl
82: WHERE group_id = l_group_id;
83:

Line 81: FROM jtf_rs_groups_vl

77: WHERE ROWID = l_rowid;
78:
79: CURSOR c_dup_group_id (l_group_id IN jtf_rs_groups_vl.group_id%type) IS
80: SELECT 'X'
81: FROM jtf_rs_groups_vl
82: WHERE group_id = l_group_id;
83:
84: BEGIN
85:

Line 663: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,

659: PROCEDURE create_resource_group_migrate
660: (P_API_VERSION IN NUMBER,
661: P_INIT_MSG_LIST IN VARCHAR2,
662: P_COMMIT IN VARCHAR2,
663: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
664: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
665: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

Line 664: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,

660: (P_API_VERSION IN NUMBER,
661: P_INIT_MSG_LIST IN VARCHAR2,
662: P_COMMIT IN VARCHAR2,
663: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
664: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
665: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,

Line 665: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,

661: P_INIT_MSG_LIST IN VARCHAR2,
662: P_COMMIT IN VARCHAR2,
663: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
664: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
665: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,

Line 666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,

662: P_COMMIT IN VARCHAR2,
663: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
664: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
665: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,

Line 667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

663: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
664: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
665: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,

Line 668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,

664: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
665: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,

Line 669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,

665: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,

Line 670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,

666: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,

Line 671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,

667: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,

Line 672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,

668: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,

Line 673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,

669: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,

Line 674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,

670: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,

Line 675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,

671: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,

Line 676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,

672: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,

Line 677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,

673: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,

Line 678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,

674: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,

Line 679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,

675: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,

Line 680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,

676: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
684: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,

Line 681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,

677: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
684: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
685: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,

Line 682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,

678: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
684: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
685: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
686: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,

679: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
684: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
685: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
686: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
687: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 684: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,

680: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
684: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
685: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
686: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
687: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
688: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 685: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,

681: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
684: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
685: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
686: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
687: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
688: X_MSG_COUNT OUT NOCOPY NUMBER,
689: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 686: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

682: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
683: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
684: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
685: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
686: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
687: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
688: X_MSG_COUNT OUT NOCOPY NUMBER,
689: X_MSG_DATA OUT NOCOPY VARCHAR2,
690: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

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

686: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
687: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
688: X_MSG_COUNT OUT NOCOPY NUMBER,
689: X_MSG_DATA OUT NOCOPY VARCHAR2,
690: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
691: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
692: ) IS
693:
694: BEGIN

Line 691: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE

687: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
688: X_MSG_COUNT OUT NOCOPY NUMBER,
689: X_MSG_DATA OUT NOCOPY VARCHAR2,
690: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
691: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
692: ) IS
693:
694: BEGIN
695:

Line 741: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

737: PROCEDURE update_resource_group
738: (P_API_VERSION IN NUMBER,
739: P_INIT_MSG_LIST IN VARCHAR2,
740: P_COMMIT IN VARCHAR2,
741: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
742: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
743: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,

Line 742: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,

738: (P_API_VERSION IN NUMBER,
739: P_INIT_MSG_LIST IN VARCHAR2,
740: P_COMMIT IN VARCHAR2,
741: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
742: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
743: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

Line 743: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,

739: P_INIT_MSG_LIST IN VARCHAR2,
740: P_COMMIT IN VARCHAR2,
741: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
742: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
743: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,

Line 744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,

740: P_COMMIT IN VARCHAR2,
741: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
742: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
743: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,

Line 745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,

741: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
742: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
743: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,

Line 746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

742: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
743: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,

Line 747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,

743: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,

Line 748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,

744: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,

Line 749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,

745: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,

Line 750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,

746: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,

Line 751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,

747: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,

Line 752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,

748: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,

Line 753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,

749: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE,
750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,

Line 754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,

750: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE,
751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,

Line 755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,

751: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE,
752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,

Line 756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,

752: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE,
753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,

Line 757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,

753: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE,
754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,

Line 758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,

754: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE,
755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,

Line 759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,

755: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE,
756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
763: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,

Line 760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,

756: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE,
757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
763: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
764: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,

Line 761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,

757: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE,
758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
763: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
764: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
765: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,

Line 762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,

758: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE,
759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
763: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
764: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
765: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
766: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 763: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,

759: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE,
760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
763: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
764: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
765: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
766: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
767: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 764: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,

760: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE,
761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
763: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
764: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
765: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
766: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
767: X_MSG_COUNT OUT NOCOPY NUMBER,
768: X_MSG_DATA OUT NOCOPY VARCHAR2

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

761: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE,
762: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE,
763: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE,
764: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE,
765: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
766: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
767: X_MSG_COUNT OUT NOCOPY NUMBER,
768: X_MSG_DATA OUT NOCOPY VARCHAR2
769: ) IS

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

769: ) IS
770:
771: l_api_version CONSTANT NUMBER := 1.0;
772: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
773: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
774: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
775: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
776: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;

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

770:
771: l_api_version CONSTANT NUMBER := 1.0;
772: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
773: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
774: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
775: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
776: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);

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

771: l_api_version CONSTANT NUMBER := 1.0;
772: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
773: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
774: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
775: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
776: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
779: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);

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

772: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_GROUP';
773: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
774: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
775: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
776: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
779: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
780: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;

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

773: l_group_id jtf_rs_groups_vl.group_id%TYPE := p_group_id;
774: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
775: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
776: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
779: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
780: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
781: l_object_version_num jtf_rs_groups_vl.object_version_number%type := p_object_version_num;

Line 778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);

774: l_group_name jtf_rs_groups_vl.group_name%TYPE := p_group_name;
775: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
776: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
779: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
780: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
781: l_object_version_num jtf_rs_groups_vl.object_version_number%type := p_object_version_num;
782:

Line 779: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);

775: l_group_desc jtf_rs_groups_vl.group_desc%TYPE := p_group_desc;
776: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
779: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
780: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
781: l_object_version_num jtf_rs_groups_vl.object_version_number%type := p_object_version_num;
782:
783: l_max_end_date DATE;

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

776: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE := p_exclusive_flag;
777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
779: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
780: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
781: l_object_version_num jtf_rs_groups_vl.object_version_number%type := p_object_version_num;
782:
783: l_max_end_date DATE;
784: l_min_start_date DATE;

Line 781: l_object_version_num jtf_rs_groups_vl.object_version_number%type := p_object_version_num;

777: l_email_address jtf_rs_groups_vl.email_address%TYPE := p_email_address;
778: l_start_date_active jtf_rs_groups_vl.start_date_active%TYPE := trunc(p_start_date_active);
779: l_end_date_active jtf_rs_groups_vl.end_date_active%TYPE := trunc(p_end_date_active);
780: l_accounting_code jtf_rs_groups_vl.accounting_code%TYPE := p_accounting_code;
781: l_object_version_num jtf_rs_groups_vl.object_version_number%type := p_object_version_num;
782:
783: l_max_end_date DATE;
784: l_min_start_date DATE;
785: l_check_char VARCHAR2(1);

Line 817: FROM jtf_rs_groups_vl

813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
814: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
815: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
816: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
817: FROM jtf_rs_groups_vl
818: WHERE group_id = l_group_id;
819:
820: group_rec c_group_update%ROWTYPE;
821:

Line 933: FROM jtf_rs_groups_vl G1,

929: CURSOR c_exclusive_group_check(
930: l_group_id IN NUMBER )
931: IS
932: SELECT 'Y'
933: FROM jtf_rs_groups_vl G1,
934: jtf_rs_groups_vl G2,
935: jtf_rs_group_members GM1,
936: jtf_rs_group_members GM2,
937: jtf_rs_group_usages GU1,

Line 934: jtf_rs_groups_vl G2,

930: l_group_id IN NUMBER )
931: IS
932: SELECT 'Y'
933: FROM jtf_rs_groups_vl G1,
934: jtf_rs_groups_vl G2,
935: jtf_rs_group_members GM1,
936: jtf_rs_group_members GM2,
937: jtf_rs_group_usages GU1,
938: jtf_rs_group_usages GU2,