[Home] [Help] [Dependency Information]
Object Name: | HZ_CITIZENSHIP_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) | |
CITIZENSHIP_ID | NUMBER |
|
|
PERSON_ID | NUMBER |
|
|
BIRTH_OR_SELECTED | VARCHAR2 | (30) | |
COUNTRY_CODE | VARCHAR2 | (2) | |
DATE_RECOGNIZED | DATE |
|
|
DATE_DISOWNED | DATE |
|
|
END_DATE | DATE |
|
|
DOCUMENT_TYPE | VARCHAR2 | (30) | |
DOCUMENT_REFERENCE | VARCHAR2 | (60) | |
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_CITIZENSHIP_ID(NUMBER) P_BIRTH_OR_SELECTED(VARCHAR2) P_COUNTRY_CODE(VARCHAR2) P_DATE_RECOGNIZED(DATE) P_DATE_DISOWNED(DATE) P_END_DATE(DATE) P_DOCUMENT_TYPE(VARCHAR2) P_DOCUMENT_REFERENCE(VARCHAR2) P_STATUS(VARCHAR2) |
HZ_CITIZENSHIP_OBJ |
|
|
|