[Home] [Help] [Dependency Information]
Object Name: | HZ_CONTACT_PREF_OBJ |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
ACTION_TYPE | VARCHAR2 | (30) | |
COMMON_OBJ_ID | VARCHAR2 | (255) | |
CONTACT_PREFERENCE_ID | NUMBER |
|
|
PARENT_OBJECT_TYPE | VARCHAR2 | (30) | |
PARENT_OBJECT_ID | NUMBER |
|
|
CONTACT_TYPE | VARCHAR2 | (30) | |
PREFERENCE_CODE | VARCHAR2 | (30) | |
PREFERENCE_TOPIC_TYPE | VARCHAR2 | (30) | |
PREFERENCE_TOPIC_TYPE_ID | NUMBER |
|
|
PREFERENCE_TOPIC_TYPE_CODE | VARCHAR2 | (30) | |
PREFERENCE_START_DATE | DATE |
|
|
PREFERENCE_END_DATE | DATE |
|
|
PREFERENCE_START_TIME_HR | NUMBER |
|
|
PREFERENCE_END_TIME_HR | NUMBER |
|
|
PREFERENCE_START_TIME_MI | NUMBER |
|
|
PREFERENCE_END_TIME_MI | NUMBER |
|
|
MAX_NO_OF_INTERACTIONS | NUMBER |
|
|
MAX_NO_OF_INTERACT_UOM_CODE | VARCHAR2 | (30) | |
REQUESTED_BY | VARCHAR2 | (30) | |
REASON_CODE | VARCHAR2 | (30) | |
STATUS | VARCHAR2 | (1) | |
PROGRAM_UPDATE_DATE | DATE |
|
|
CREATED_BY_MODULE | VARCHAR2 | (150) | |
CREATED_BY_NAME | VARCHAR2 | (100) | |
CREATION_DATE | DATE |
|
|
LAST_UPDATE_DATE | DATE |
|
|
LAST_UPDATED_BY_NAME | VARCHAR2 | (100) |
Name | Parameters | Result |
---|---|---|
CREATE_OBJECT |
P_CONTACT_PREFERENCE_ID(NUMBER) P_CONTACT_TYPE(VARCHAR2) P_PREFERENCE_CODE(VARCHAR2) P_PREFERENCE_TOPIC_TYPE(VARCHAR2) P_PREFERENCE_TOPIC_TYPE_ID(NUMBER) P_PREFERENCE_TOPIC_TYPE_CODE(VARCHAR2) P_PREFERENCE_START_DATE(DATE) P_PREFERENCE_END_DATE(DATE) P_PREFERENCE_START_TIME_HR(NUMBER) P_PREFERENCE_END_TIME_HR(NUMBER) P_PREFERENCE_START_TIME_MI(NUMBER) P_PREFERENCE_END_TIME_MI(NUMBER) P_MAX_NO_OF_INTERACTIONS(NUMBER) P_MAX_NO_OF_INTERACT_UOM_CODE(VARCHAR2) P_REQUESTED_BY(VARCHAR2) P_REASON_CODE(VARCHAR2) P_STATUS(VARCHAR2) |
HZ_CONTACT_PREF_OBJ |
|
|
|