3:
4:
5: TYPE SUBSCRIPTION_INFO IS RECORD
6: (
7: NAME JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_NAME%TYPE := FND_API.G_MISS_CHAR,
8: KEY JTF_UM_SUBSCRIPTIONS_B.SUBSCRIPTION_KEY%TYPE := FND_API.G_MISS_CHAR,
9: DESCRIPTION JTF_UM_SUBSCRIPTIONS_TL.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
10: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
4:
5: TYPE SUBSCRIPTION_INFO IS RECORD
6: (
7: NAME JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_NAME%TYPE := FND_API.G_MISS_CHAR,
8: KEY JTF_UM_SUBSCRIPTIONS_B.SUBSCRIPTION_KEY%TYPE := FND_API.G_MISS_CHAR,
9: DESCRIPTION JTF_UM_SUBSCRIPTIONS_TL.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
10: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
5: TYPE SUBSCRIPTION_INFO IS RECORD
6: (
7: NAME JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_NAME%TYPE := FND_API.G_MISS_CHAR,
8: KEY JTF_UM_SUBSCRIPTIONS_B.SUBSCRIPTION_KEY%TYPE := FND_API.G_MISS_CHAR,
9: DESCRIPTION JTF_UM_SUBSCRIPTIONS_TL.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
10: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
6: (
7: NAME JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_NAME%TYPE := FND_API.G_MISS_CHAR,
8: KEY JTF_UM_SUBSCRIPTIONS_B.SUBSCRIPTION_KEY%TYPE := FND_API.G_MISS_CHAR,
9: DESCRIPTION JTF_UM_SUBSCRIPTIONS_TL.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
10: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
7: NAME JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_NAME%TYPE := FND_API.G_MISS_CHAR,
8: KEY JTF_UM_SUBSCRIPTIONS_B.SUBSCRIPTION_KEY%TYPE := FND_API.G_MISS_CHAR,
9: DESCRIPTION JTF_UM_SUBSCRIPTIONS_TL.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
10: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
8: KEY JTF_UM_SUBSCRIPTIONS_B.SUBSCRIPTION_KEY%TYPE := FND_API.G_MISS_CHAR,
9: DESCRIPTION JTF_UM_SUBSCRIPTIONS_TL.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
10: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
9: DESCRIPTION JTF_UM_SUBSCRIPTIONS_TL.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
10: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
10: DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18: IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
11: ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18: IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
19: SUBSCRIPTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
12: DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18: IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
19: SUBSCRIPTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: TEMPLATE_HANDLER JTF_UM_TEMPLATES_B.TEMPLATE_HANDLER%TYPE := FND_API.G_MISS_CHAR,
13: CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18: IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
19: SUBSCRIPTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: TEMPLATE_HANDLER JTF_UM_TEMPLATES_B.TEMPLATE_HANDLER%TYPE := FND_API.G_MISS_CHAR,
21: PAGE_NAME JTF_UM_TEMPLATES_B.PAGE_NAME%TYPE := FND_API.G_MISS_CHAR
14: APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18: IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
19: SUBSCRIPTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: TEMPLATE_HANDLER JTF_UM_TEMPLATES_B.TEMPLATE_HANDLER%TYPE := FND_API.G_MISS_CHAR,
21: PAGE_NAME JTF_UM_TEMPLATES_B.PAGE_NAME%TYPE := FND_API.G_MISS_CHAR
22: );
15: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18: IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
19: SUBSCRIPTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: TEMPLATE_HANDLER JTF_UM_TEMPLATES_B.TEMPLATE_HANDLER%TYPE := FND_API.G_MISS_CHAR,
21: PAGE_NAME JTF_UM_TEMPLATES_B.PAGE_NAME%TYPE := FND_API.G_MISS_CHAR
22: );
23:
16: SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18: IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
19: SUBSCRIPTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: TEMPLATE_HANDLER JTF_UM_TEMPLATES_B.TEMPLATE_HANDLER%TYPE := FND_API.G_MISS_CHAR,
21: PAGE_NAME JTF_UM_TEMPLATES_B.PAGE_NAME%TYPE := FND_API.G_MISS_CHAR
22: );
23:
24: TYPE SUBSCRIPTION_ID_REC IS RECORD
17: APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18: IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
19: SUBSCRIPTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: TEMPLATE_HANDLER JTF_UM_TEMPLATES_B.TEMPLATE_HANDLER%TYPE := FND_API.G_MISS_CHAR,
21: PAGE_NAME JTF_UM_TEMPLATES_B.PAGE_NAME%TYPE := FND_API.G_MISS_CHAR
22: );
23:
24: TYPE SUBSCRIPTION_ID_REC IS RECORD
25: (
22: );
23:
24: TYPE SUBSCRIPTION_ID_REC IS RECORD
25: (
26: SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM
27: );
28:
29: TYPE SUBSCRIPTION_INFO_TABLE IS TABLE OF SUBSCRIPTION_INFO INDEX BY BINARY_INTEGER;
30: