9: /* Internal Industry Procedure for pre processing in case of
10: create resource group */
11:
12: PROCEDURE create_resource_group_pre
13: (P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
14: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
10: create resource group */
11:
12: PROCEDURE create_resource_group_pre
13: (P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
14: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
11:
12: PROCEDURE create_resource_group_pre
13: (P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
14: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
19: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
12: PROCEDURE create_resource_group_pre
13: (P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
14: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
19: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
20: X_RETURN_STATUS OUT NOCOPY VARCHAR2
13: (P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
14: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
19: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
20: X_RETURN_STATUS OUT NOCOPY VARCHAR2
21: ) IS
14: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
19: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
20: X_RETURN_STATUS OUT NOCOPY VARCHAR2
21: ) IS
22:
15: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
19: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
20: X_RETURN_STATUS OUT NOCOPY VARCHAR2
21: ) IS
22:
23: BEGIN
30: /* Internal Industry Procedure for post processing in case of
31: create resource group */
32:
33: PROCEDURE create_resource_group_post
34: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
35: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
36: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
31: create resource group */
32:
33: PROCEDURE create_resource_group_post
34: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
35: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
36: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
32:
33: PROCEDURE create_resource_group_post
34: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
35: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
36: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
33: PROCEDURE create_resource_group_post
34: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
35: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
36: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
41: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
34: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
35: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
36: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
41: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
36: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
41: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2
43: ) IS
36: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
41: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2
43: ) IS
44:
37: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
41: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2
43: ) IS
44:
45: BEGIN
52: /* Internal Industry Procedure for pre processing in case of
53: update resource group */
54:
55: PROCEDURE update_resource_group_pre
56: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
57: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
58: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
59: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
60: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
53: update resource group */
54:
55: PROCEDURE update_resource_group_pre
56: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
57: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
58: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
59: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
60: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
54:
55: PROCEDURE update_resource_group_pre
56: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
57: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
58: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
59: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
60: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
55: PROCEDURE update_resource_group_pre
56: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
57: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
58: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
59: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
60: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
63: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
56: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
57: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
58: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
59: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
60: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
63: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2
57: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
58: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
59: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
60: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
63: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2
65: ) IS
58: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
59: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
60: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
63: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2
65: ) IS
66:
59: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
60: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
61: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
62: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
63: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2
65: ) IS
66:
67: BEGIN
74: /* Internal Industry Procedure for post processing in case of
75: update resource group */
76:
77: PROCEDURE update_resource_group_post
78: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
79: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
80: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
81: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
82: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
75: update resource group */
76:
77: PROCEDURE update_resource_group_post
78: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
79: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
80: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
81: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
82: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
83: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
76:
77: PROCEDURE update_resource_group_post
78: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
79: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
80: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
81: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
82: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
83: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
84: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
77: PROCEDURE update_resource_group_post
78: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
79: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
80: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
81: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
82: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
83: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
84: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
85: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
78: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
79: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
80: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
81: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
82: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
83: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
84: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
85: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
86: X_RETURN_STATUS OUT NOCOPY VARCHAR2
79: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
80: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
81: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
82: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
83: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
84: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
85: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
86: X_RETURN_STATUS OUT NOCOPY VARCHAR2
87: ) IS
80: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
81: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
82: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
83: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
84: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
85: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
86: X_RETURN_STATUS OUT NOCOPY VARCHAR2
87: ) IS
88:
81: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
82: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
83: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
84: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
85: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
86: X_RETURN_STATUS OUT NOCOPY VARCHAR2
87: ) IS
88:
89: BEGIN