[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 |
SYS
STANDARD
- show dependent code
APPS
HZ_CITIZENSHIP_OBJ
HZ_CITIZENSHIP_OBJ_TBL
HZ_EXTRACT_PERSON_BO_PVT
- show dependent code
HZ_PERSON_BO_PUB
- show dependent code
|
|
|
|