[Home] [Help] [Dependency Information]
Object Name: | HZ_PERSON_INTEREST_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) | |
PERSON_INTEREST_ID | NUMBER |
|
|
LEVEL_OF_INTEREST | VARCHAR2 | (30) | |
PERSON_ID | NUMBER |
|
|
LEVEL_OF_PARTICIPATION | VARCHAR2 | (30) | |
INTEREST_TYPE_CODE | VARCHAR2 | (30) | |
COMMENTS | VARCHAR2 | (240) | |
SPORT_INDICATOR | VARCHAR2 | (1) | |
SUB_INTEREST_TYPE_CODE | VARCHAR2 | (30) | |
INTEREST_NAME | VARCHAR2 | (240) | |
TEAM | VARCHAR2 | (240) | |
SINCE | DATE |
|
|
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_PERSON_INTEREST_ID(NUMBER) P_LEVEL_OF_INTEREST(VARCHAR2) P_LEVEL_OF_PARTICIPATION(VARCHAR2) P_INTEREST_TYPE_CODE(VARCHAR2) P_COMMENTS(VARCHAR2) P_SPORT_INDICATOR(VARCHAR2) P_SUB_INTEREST_TYPE_CODE(VARCHAR2) P_INTEREST_NAME(VARCHAR2) P_TEAM(VARCHAR2) P_SINCE(DATE) P_STATUS(VARCHAR2) |
HZ_PERSON_INTEREST_OBJ |
|
|
|