9: /* Vertical 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: );
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: );
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: );
22:
23:
24: /* Vertical Industry Procedure for post processing in case of
25: create resource group */
26:
27: PROCEDURE create_resource_group_post
28: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
29: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
30: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
31: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
25: create resource group */
26:
27: PROCEDURE create_resource_group_post
28: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
29: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
30: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
31: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
26:
27: PROCEDURE create_resource_group_post
28: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
29: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
30: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
31: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
27: PROCEDURE create_resource_group_post
28: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
29: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
30: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
31: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
35: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
28: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
29: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
30: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
31: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
35: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
36: X_RETURN_STATUS OUT NOCOPY VARCHAR2
29: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
30: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
31: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
35: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
36: X_RETURN_STATUS OUT NOCOPY VARCHAR2
37: );
30: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
31: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
35: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
36: X_RETURN_STATUS OUT NOCOPY VARCHAR2
37: );
38:
31: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
33: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
34: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
35: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
36: X_RETURN_STATUS OUT NOCOPY VARCHAR2
37: );
38:
39:
40: /* Vertical Industry Procedure for pre processing in case of
41: update resource group */
42:
43: PROCEDURE update_resource_group_pre
44: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
45: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
46: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
47: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
41: update resource group */
42:
43: PROCEDURE update_resource_group_pre
44: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
45: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
46: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
47: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
49: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
42:
43: PROCEDURE update_resource_group_pre
44: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
45: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
46: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
47: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
49: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
50: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
43: PROCEDURE update_resource_group_pre
44: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
45: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
46: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
47: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
49: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
50: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
51: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
44: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
45: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
46: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
47: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
49: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
50: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
51: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
52: X_RETURN_STATUS OUT NOCOPY VARCHAR2
45: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
46: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
47: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
49: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
50: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
51: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
52: X_RETURN_STATUS OUT NOCOPY VARCHAR2
53: );
46: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
47: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
49: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
50: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
51: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
52: X_RETURN_STATUS OUT NOCOPY VARCHAR2
53: );
54:
47: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
49: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
50: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
51: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
52: X_RETURN_STATUS OUT NOCOPY VARCHAR2
53: );
54:
55:
56: /* Vertical Industry Procedure for post processing in case of
57: update resource group */
58:
59: PROCEDURE update_resource_group_post
60: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
61: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
63: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
57: update resource group */
58:
59: PROCEDURE update_resource_group_post
60: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
61: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
63: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
65: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
58:
59: PROCEDURE update_resource_group_post
60: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
61: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
63: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
65: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
66: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
59: PROCEDURE update_resource_group_post
60: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
61: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
63: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
65: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
66: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
67: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
60: (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
61: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
63: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
65: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
66: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
67: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
68: X_RETURN_STATUS OUT NOCOPY VARCHAR2
61: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
62: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
63: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
65: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
66: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
67: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
68: X_RETURN_STATUS OUT NOCOPY VARCHAR2
69: );
62: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
63: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
65: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
66: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
67: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
68: X_RETURN_STATUS OUT NOCOPY VARCHAR2
69: );
70:
63: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
65: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
66: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
67: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
68: X_RETURN_STATUS OUT NOCOPY VARCHAR2
69: );
70:
71: