DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HRDPV_CREATE_CONTACT

Object Details
Object Name: HRDPV_CREATE_CONTACT
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes
BATCH_LINE_ID NUMBER (15) Yes
API_MODULE_ID NUMBER (15) Yes
LINE_STATUS VARCHAR2 (1) Yes
USER_SEQUENCE NUMBER (15)
LINK_VALUE NUMBER (15)
BUSINESS_GROUP_NAME VARCHAR2 (240)
P_START_DATE VARCHAR2 (2000)
P_CONTACT_TYPE VARCHAR2 (2000)
P_CTR_COMMENTS VARCHAR2 (2000)
P_PRIMARY_CONTACT_FLAG VARCHAR2 (2000)
P_DATE_START VARCHAR2 (2000)
P_DATE_END VARCHAR2 (2000)
P_RLTD_PER_RSDS_W_DSGNTR_FLAG VARCHAR2 (2000)
P_PERSONAL_FLAG VARCHAR2 (2000)
P_SEQUENCE_NUMBER VARCHAR2 (2000)
P_CONT_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
P_CONT_ATTRIBUTE1 VARCHAR2 (2000)
P_CONT_ATTRIBUTE2 VARCHAR2 (2000)
P_CONT_ATTRIBUTE3 VARCHAR2 (2000)
P_CONT_ATTRIBUTE4 VARCHAR2 (2000)
P_CONT_ATTRIBUTE5 VARCHAR2 (2000)
P_CONT_ATTRIBUTE6 VARCHAR2 (2000)
P_CONT_ATTRIBUTE7 VARCHAR2 (2000)
P_CONT_ATTRIBUTE8 VARCHAR2 (2000)
P_CONT_ATTRIBUTE9 VARCHAR2 (2000)
P_CONT_ATTRIBUTE10 VARCHAR2 (2000)
P_CONT_ATTRIBUTE11 VARCHAR2 (2000)
P_CONT_ATTRIBUTE12 VARCHAR2 (2000)
P_CONT_ATTRIBUTE13 VARCHAR2 (2000)
P_CONT_ATTRIBUTE14 VARCHAR2 (2000)
P_CONT_ATTRIBUTE15 VARCHAR2 (2000)
P_CONT_ATTRIBUTE16 VARCHAR2 (2000)
P_CONT_ATTRIBUTE17 VARCHAR2 (2000)
P_CONT_ATTRIBUTE18 VARCHAR2 (2000)
P_CONT_ATTRIBUTE19 VARCHAR2 (2000)
P_CONT_ATTRIBUTE20 VARCHAR2 (2000)
P_CONT_INFORMATION_CATEGORY VARCHAR2 (2000)
P_CONT_INFORMATION1 VARCHAR2 (2000)
P_CONT_INFORMATION2 VARCHAR2 (2000)
P_CONT_INFORMATION3 VARCHAR2 (2000)
P_CONT_INFORMATION4 VARCHAR2 (2000)
P_CONT_INFORMATION5 VARCHAR2 (2000)
P_CONT_INFORMATION6 VARCHAR2 (2000)
P_CONT_INFORMATION7 VARCHAR2 (2000)
P_CONT_INFORMATION8 VARCHAR2 (2000)
P_CONT_INFORMATION9 VARCHAR2 (2000)
P_CONT_INFORMATION10 VARCHAR2 (2000)
P_CONT_INFORMATION11 VARCHAR2 (2000)
P_CONT_INFORMATION12 VARCHAR2 (2000)
P_CONT_INFORMATION13 VARCHAR2 (2000)
P_CONT_INFORMATION14 VARCHAR2 (2000)
P_CONT_INFORMATION15 VARCHAR2 (2000)
P_CONT_INFORMATION16 VARCHAR2 (2000)
P_CONT_INFORMATION17 VARCHAR2 (2000)
P_CONT_INFORMATION18 VARCHAR2 (2000)
P_CONT_INFORMATION19 VARCHAR2 (2000)
P_CONT_INFORMATION20 VARCHAR2 (2000)
P_THIRD_PARTY_PAY_FLAG VARCHAR2 (2000)
P_BONDHOLDER_FLAG VARCHAR2 (2000)
P_DEPENDENT_FLAG VARCHAR2 (2000)
P_BENEFICIARY_FLAG VARCHAR2 (2000)
P_LAST_NAME VARCHAR2 (2000)
P_SEX VARCHAR2 (2000)
P_PER_COMMENTS VARCHAR2 (2000)
P_DATE_OF_BIRTH VARCHAR2 (2000)
P_EMAIL_ADDRESS VARCHAR2 (2000)
P_FIRST_NAME VARCHAR2 (2000)
P_KNOWN_AS VARCHAR2 (2000)
P_MARITAL_STATUS VARCHAR2 (2000)
P_MIDDLE_NAMES VARCHAR2 (2000)
P_NATIONALITY VARCHAR2 (2000)
P_NATIONAL_IDENTIFIER VARCHAR2 (2000)
P_PREVIOUS_LAST_NAME VARCHAR2 (2000)
P_REGISTERED_DISABLED_FLAG VARCHAR2 (2000)
P_TITLE VARCHAR2 (2000)
P_WORK_TELEPHONE VARCHAR2 (2000)
P_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
P_ATTRIBUTE1 VARCHAR2 (2000)
P_ATTRIBUTE2 VARCHAR2 (2000)
P_ATTRIBUTE3 VARCHAR2 (2000)
P_ATTRIBUTE4 VARCHAR2 (2000)
P_ATTRIBUTE5 VARCHAR2 (2000)
P_ATTRIBUTE6 VARCHAR2 (2000)
P_ATTRIBUTE7 VARCHAR2 (2000)
P_ATTRIBUTE8 VARCHAR2 (2000)
P_ATTRIBUTE9 VARCHAR2 (2000)
P_ATTRIBUTE10 VARCHAR2 (2000)
P_ATTRIBUTE11 VARCHAR2 (2000)
P_ATTRIBUTE12 VARCHAR2 (2000)
P_ATTRIBUTE13 VARCHAR2 (2000)
P_ATTRIBUTE14 VARCHAR2 (2000)
P_ATTRIBUTE15 VARCHAR2 (2000)
P_ATTRIBUTE16 VARCHAR2 (2000)
P_ATTRIBUTE17 VARCHAR2 (2000)
P_ATTRIBUTE18 VARCHAR2 (2000)
P_ATTRIBUTE19 VARCHAR2 (2000)
P_ATTRIBUTE20 VARCHAR2 (2000)
P_ATTRIBUTE21 VARCHAR2 (2000)
P_ATTRIBUTE22 VARCHAR2 (2000)
P_ATTRIBUTE23 VARCHAR2 (2000)
P_ATTRIBUTE24 VARCHAR2 (2000)
P_ATTRIBUTE25 VARCHAR2 (2000)
P_ATTRIBUTE26 VARCHAR2 (2000)
P_ATTRIBUTE27 VARCHAR2 (2000)
P_ATTRIBUTE28 VARCHAR2 (2000)
P_ATTRIBUTE29 VARCHAR2 (2000)
P_ATTRIBUTE30 VARCHAR2 (2000)
P_PER_INFORMATION_CATEGORY VARCHAR2 (2000)
P_PER_INFORMATION1 VARCHAR2 (2000)
P_PER_INFORMATION2 VARCHAR2 (2000)
P_PER_INFORMATION3 VARCHAR2 (2000)
P_PER_INFORMATION4 VARCHAR2 (2000)
P_PER_INFORMATION5 VARCHAR2 (2000)
P_PER_INFORMATION6 VARCHAR2 (2000)
P_PER_INFORMATION7 VARCHAR2 (2000)
P_PER_INFORMATION8 VARCHAR2 (2000)
P_PER_INFORMATION9 VARCHAR2 (2000)
P_PER_INFORMATION10 VARCHAR2 (2000)
P_PER_INFORMATION11 VARCHAR2 (2000)
P_PER_INFORMATION12 VARCHAR2 (2000)
P_PER_INFORMATION13 VARCHAR2 (2000)
P_PER_INFORMATION14 VARCHAR2 (2000)
P_PER_INFORMATION15 VARCHAR2 (2000)
P_PER_INFORMATION16 VARCHAR2 (2000)
P_PER_INFORMATION17 VARCHAR2 (2000)
P_PER_INFORMATION18 VARCHAR2 (2000)
P_PER_INFORMATION19 VARCHAR2 (2000)
P_PER_INFORMATION20 VARCHAR2 (2000)
P_PER_INFORMATION21 VARCHAR2 (2000)
P_PER_INFORMATION22 VARCHAR2 (2000)
P_PER_INFORMATION23 VARCHAR2 (2000)
P_PER_INFORMATION24 VARCHAR2 (2000)
P_PER_INFORMATION25 VARCHAR2 (2000)
P_PER_INFORMATION26 VARCHAR2 (2000)
P_PER_INFORMATION27 VARCHAR2 (2000)
P_PER_INFORMATION28 VARCHAR2 (2000)
P_PER_INFORMATION29 VARCHAR2 (2000)
P_PER_INFORMATION30 VARCHAR2 (2000)
P_CORRESPONDENCE_LANGUAGE VARCHAR2 (2000)
P_HONORS VARCHAR2 (2000)
P_PRE_NAME_ADJUNCT VARCHAR2 (2000)
P_SUFFIX VARCHAR2 (2000)
P_CREATE_MIRROR_FLAG VARCHAR2 (2000)
P_MIRROR_TYPE VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE_CAT VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE1 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE2 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE3 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE4 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE5 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE6 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE7 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE8 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE9 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE10 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE11 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE12 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE13 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE14 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE15 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE16 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE17 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE18 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE19 VARCHAR2 (2000)
P_MIRROR_CONT_ATTRIBUTE20 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION_CAT VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION1 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION2 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION3 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION4 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION5 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION6 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION7 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION8 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION9 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION10 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION11 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION12 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION13 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION14 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION15 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION16 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION17 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION18 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION19 VARCHAR2 (2000)
P_MIRROR_CONT_INFORMATION20 VARCHAR2 (2000)
P_CONTACT_RELATIONSHIP_ID VARCHAR2 (2000)
P_CTR_OBJECT_VERSION_NUMBER VARCHAR2 (2000)
P_PER_PERSON_USER_KEY VARCHAR2 (2000)
P_PER_OBJECT_VERSION_NUMBER VARCHAR2 (2000)
P_PER_EFFECTIVE_START_DATE VARCHAR2 (2000)
P_PER_EFFECTIVE_END_DATE VARCHAR2 (2000)
P_FULL_NAME VARCHAR2 (2000)
P_PER_COMMENT_ID VARCHAR2 (2000)
P_NAME_COMBINATION_WARNING VARCHAR2 (2000)
P_ORIG_HIRE_WARNING VARCHAR2 (2000)
P_PERSON_USER_KEY VARCHAR2 (2000)
P_CONTACT_PERSON_USER_KEY VARCHAR2 (2000)
P_START_LIFE_REASON VARCHAR2 (2000)
P_END_LIFE_REASON VARCHAR2 (2000)
P_USER_PERSON_TYPE VARCHAR2 (2000)
P_LANGUAGE_CODE VARCHAR2 (2000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      BATCH_LINE_ID
,      API_MODULE_ID
,      LINE_STATUS
,      USER_SEQUENCE
,      LINK_VALUE
,      BUSINESS_GROUP_NAME
,      P_START_DATE
,      P_CONTACT_TYPE
,      P_CTR_COMMENTS
,      P_PRIMARY_CONTACT_FLAG
,      P_DATE_START
,      P_DATE_END
,      P_RLTD_PER_RSDS_W_DSGNTR_FLAG
,      P_PERSONAL_FLAG
,      P_SEQUENCE_NUMBER
,      P_CONT_ATTRIBUTE_CATEGORY
,      P_CONT_ATTRIBUTE1
,      P_CONT_ATTRIBUTE2
,      P_CONT_ATTRIBUTE3
,      P_CONT_ATTRIBUTE4
,      P_CONT_ATTRIBUTE5
,      P_CONT_ATTRIBUTE6
,      P_CONT_ATTRIBUTE7
,      P_CONT_ATTRIBUTE8
,      P_CONT_ATTRIBUTE9
,      P_CONT_ATTRIBUTE10
,      P_CONT_ATTRIBUTE11
,      P_CONT_ATTRIBUTE12
,      P_CONT_ATTRIBUTE13
,      P_CONT_ATTRIBUTE14
,      P_CONT_ATTRIBUTE15
,      P_CONT_ATTRIBUTE16
,      P_CONT_ATTRIBUTE17
,      P_CONT_ATTRIBUTE18
,      P_CONT_ATTRIBUTE19
,      P_CONT_ATTRIBUTE20
,      P_CONT_INFORMATION_CATEGORY
,      P_CONT_INFORMATION1
,      P_CONT_INFORMATION2
,      P_CONT_INFORMATION3
,      P_CONT_INFORMATION4
,      P_CONT_INFORMATION5
,      P_CONT_INFORMATION6
,      P_CONT_INFORMATION7
,      P_CONT_INFORMATION8
,      P_CONT_INFORMATION9
,      P_CONT_INFORMATION10
,      P_CONT_INFORMATION11
,      P_CONT_INFORMATION12
,      P_CONT_INFORMATION13
,      P_CONT_INFORMATION14
,      P_CONT_INFORMATION15
,      P_CONT_INFORMATION16
,      P_CONT_INFORMATION17
,      P_CONT_INFORMATION18
,      P_CONT_INFORMATION19
,      P_CONT_INFORMATION20
,      P_THIRD_PARTY_PAY_FLAG
,      P_BONDHOLDER_FLAG
,      P_DEPENDENT_FLAG
,      P_BENEFICIARY_FLAG
,      P_LAST_NAME
,      P_SEX
,      P_PER_COMMENTS
,      P_DATE_OF_BIRTH
,      P_EMAIL_ADDRESS
,      P_FIRST_NAME
,      P_KNOWN_AS
,      P_MARITAL_STATUS
,      P_MIDDLE_NAMES
,      P_NATIONALITY
,      P_NATIONAL_IDENTIFIER
,      P_PREVIOUS_LAST_NAME
,      P_REGISTERED_DISABLED_FLAG
,      P_TITLE
,      P_WORK_TELEPHONE
,      P_ATTRIBUTE_CATEGORY
,      P_ATTRIBUTE1
,      P_ATTRIBUTE2
,      P_ATTRIBUTE3
,      P_ATTRIBUTE4
,      P_ATTRIBUTE5
,      P_ATTRIBUTE6
,      P_ATTRIBUTE7
,      P_ATTRIBUTE8
,      P_ATTRIBUTE9
,      P_ATTRIBUTE10
,      P_ATTRIBUTE11
,      P_ATTRIBUTE12
,      P_ATTRIBUTE13
,      P_ATTRIBUTE14
,      P_ATTRIBUTE15
,      P_ATTRIBUTE16
,      P_ATTRIBUTE17
,      P_ATTRIBUTE18
,      P_ATTRIBUTE19
,      P_ATTRIBUTE20
,      P_ATTRIBUTE21
,      P_ATTRIBUTE22
,      P_ATTRIBUTE23
,      P_ATTRIBUTE24
,      P_ATTRIBUTE25
,      P_ATTRIBUTE26
,      P_ATTRIBUTE27
,      P_ATTRIBUTE28
,      P_ATTRIBUTE29
,      P_ATTRIBUTE30
,      P_PER_INFORMATION_CATEGORY
,      P_PER_INFORMATION1
,      P_PER_INFORMATION2
,      P_PER_INFORMATION3
,      P_PER_INFORMATION4
,      P_PER_INFORMATION5
,      P_PER_INFORMATION6
,      P_PER_INFORMATION7
,      P_PER_INFORMATION8
,      P_PER_INFORMATION9
,      P_PER_INFORMATION10
,      P_PER_INFORMATION11
,      P_PER_INFORMATION12
,      P_PER_INFORMATION13
,      P_PER_INFORMATION14
,      P_PER_INFORMATION15
,      P_PER_INFORMATION16
,      P_PER_INFORMATION17
,      P_PER_INFORMATION18
,      P_PER_INFORMATION19
,      P_PER_INFORMATION20
,      P_PER_INFORMATION21
,      P_PER_INFORMATION22
,      P_PER_INFORMATION23
,      P_PER_INFORMATION24
,      P_PER_INFORMATION25
,      P_PER_INFORMATION26
,      P_PER_INFORMATION27
,      P_PER_INFORMATION28
,      P_PER_INFORMATION29
,      P_PER_INFORMATION30
,      P_CORRESPONDENCE_LANGUAGE
,      P_HONORS
,      P_PRE_NAME_ADJUNCT
,      P_SUFFIX
,      P_CREATE_MIRROR_FLAG
,      P_MIRROR_TYPE
,      P_MIRROR_CONT_ATTRIBUTE_CAT
,      P_MIRROR_CONT_ATTRIBUTE1
,      P_MIRROR_CONT_ATTRIBUTE2
,      P_MIRROR_CONT_ATTRIBUTE3
,      P_MIRROR_CONT_ATTRIBUTE4
,      P_MIRROR_CONT_ATTRIBUTE5
,      P_MIRROR_CONT_ATTRIBUTE6
,      P_MIRROR_CONT_ATTRIBUTE7
,      P_MIRROR_CONT_ATTRIBUTE8
,      P_MIRROR_CONT_ATTRIBUTE9
,      P_MIRROR_CONT_ATTRIBUTE10
,      P_MIRROR_CONT_ATTRIBUTE11
,      P_MIRROR_CONT_ATTRIBUTE12
,      P_MIRROR_CONT_ATTRIBUTE13
,      P_MIRROR_CONT_ATTRIBUTE14
,      P_MIRROR_CONT_ATTRIBUTE15
,      P_MIRROR_CONT_ATTRIBUTE16
,      P_MIRROR_CONT_ATTRIBUTE17
,      P_MIRROR_CONT_ATTRIBUTE18
,      P_MIRROR_CONT_ATTRIBUTE19
,      P_MIRROR_CONT_ATTRIBUTE20
,      P_MIRROR_CONT_INFORMATION_CAT
,      P_MIRROR_CONT_INFORMATION1
,      P_MIRROR_CONT_INFORMATION2
,      P_MIRROR_CONT_INFORMATION3
,      P_MIRROR_CONT_INFORMATION4
,      P_MIRROR_CONT_INFORMATION5
,      P_MIRROR_CONT_INFORMATION6
,      P_MIRROR_CONT_INFORMATION7
,      P_MIRROR_CONT_INFORMATION8
,      P_MIRROR_CONT_INFORMATION9
,      P_MIRROR_CONT_INFORMATION10
,      P_MIRROR_CONT_INFORMATION11
,      P_MIRROR_CONT_INFORMATION12
,      P_MIRROR_CONT_INFORMATION13
,      P_MIRROR_CONT_INFORMATION14
,      P_MIRROR_CONT_INFORMATION15
,      P_MIRROR_CONT_INFORMATION16
,      P_MIRROR_CONT_INFORMATION17
,      P_MIRROR_CONT_INFORMATION18
,      P_MIRROR_CONT_INFORMATION19
,      P_MIRROR_CONT_INFORMATION20
,      P_CONTACT_RELATIONSHIP_ID
,      P_CTR_OBJECT_VERSION_NUMBER
,      P_PER_PERSON_USER_KEY
,      P_PER_OBJECT_VERSION_NUMBER
,      P_PER_EFFECTIVE_START_DATE
,      P_PER_EFFECTIVE_END_DATE
,      P_FULL_NAME
,      P_PER_COMMENT_ID
,      P_NAME_COMBINATION_WARNING
,      P_ORIG_HIRE_WARNING
,      P_PERSON_USER_KEY
,      P_CONTACT_PERSON_USER_KEY
,      P_START_LIFE_REASON
,      P_END_LIFE_REASON
,      P_USER_PERSON_TYPE
,      P_LANGUAGE_CODE
FROM APPS.HRDPV_CREATE_CONTACT;

Dependencies

[top of page]

APPS.HRDPV_CREATE_CONTACT references the following:

SchemaAPPS
SynonymHR_PUMP_BATCH_LINES
APPS.HRDPV_CREATE_CONTACT is referenced by following:

SchemaAPPS
Package BodyPQP_HROSS_INTEGRATION - show dependent code
Package BodyPQP_PERASGADD_RIW - show dependent code