The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER,
x_attribute21 IN VARCHAR2,
x_attribute22 IN VARCHAR2,
x_attribute23 IN VARCHAR2,
x_attribute24 IN VARCHAR2
) AS
/*************************************************************
Created By : sjalasut
Date Created By :
Purpose : Admissions Self Service redesign
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
***************************************************************/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_AD_SS_PERSON_V
WHERE row_id = x_rowid;
IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
CLOSE cur_old_ref_values;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
SELECT 1
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'HZ_GENDER'
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 222
AND SECURITY_GROUP_ID(+) = 0
AND ENABLED_FLAG = 'Y'
AND LOOKUP_CODE = cp_lookup_code;
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
mmkumar 19-JUL-2005 Passed NULL for x_oss_org_unit_cd in insert_row
***************************************************************/
CURSOR cur_rowid IS
SELECT p.ROWID row_id
FROM hz_parties p
WHERE p.party_id = x_person_id;
SELECT rowid
FROM igs_pe_hz_parties
WHERE party_id = x_person_id;
IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(
X_ROWID => pehz_rowid,
X_PARTY_ID => X_PERSON_ID,
X_DECEASED_IND => NULL,
X_ARCHIVE_EXCLUSION_IND => NULL,
X_ARCHIVE_DT => NULL,
X_PURGE_EXCLUSION_IND => NULL,
X_PURGE_DT => NULL,
X_ORACLE_USERNAME => NULL,
X_PROOF_OF_INS => NULL,
X_PROOF_OF_IMMU => NULL,
X_LEVEL_OF_QUAL => NULL,
X_MILITARY_SERVICE_REG => NULL,
X_VETERAN => NULL,
X_INSTITUTION_CD => NULL,
X_OI_LOCAL_INSTITUTION_IND => NULL,
X_OI_OS_IND => NULL,
X_OI_GOVT_INSTITUTION_CD => NULL,
X_OI_INST_CONTROL_TYPE => NULL,
X_OI_INSTITUTION_TYPE => NULL,
X_OI_INSTITUTION_STATUS => NULL,
X_OU_START_DT => NULL,
X_OU_END_DT => NULL,
X_OU_MEMBER_TYPE => NULL,
X_OU_ORG_STATUS => NULL,
X_OU_ORG_TYPE => NULL,
X_INST_ORG_IND => NULL,
X_birth_city => NULL,
X_birth_country => NULL,
x_oss_org_unit_cd => NULL, --mmkumar, party number impact
X_felony_convicted_flag => NULL,
X_MODE => 'R'
);
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_attribute21 IN VARCHAR2,
x_attribute22 IN VARCHAR2,
x_attribute23 IN VARCHAR2,
x_attribute24 IN VARCHAR2
) AS
/*************************************************************
Created By : sjalasut
Date Created By :
Purpose :Admissions Self Service redesign
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
***************************************************************/
BEGIN
Set_Column_Values (
p_action,
x_rowid,
x_person_id,
x_person_number,
x_surname,
x_middle_name,
x_given_names,
x_sex,
x_DECLARED_ETHNICITY,
x_MARITAL_STATUS,
x_MARITAL_STATUS_DATE,
x_title,
x_staff_member_ind,
x_deceased_ind,
x_suffix,
x_pre_name_adjunct,
x_archive_exclusion_ind,
x_archive_dt,
x_purge_exclusion_ind,
x_purge_dt,
x_deceased_date,
x_proof_of_ins,
x_proof_of_immu,
x_birth_dt,
x_PLACE_OF_BIRTH,
x_salutation,
x_oracle_username,
x_preferred_given_name,
x_email_addr,
x_level_of_qual_id,
x_military_service_reg,
x_veteran,
x_hz_parties_ovn,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
x_attribute16,
x_attribute17,
x_attribute18,
x_attribute19,
x_attribute20,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_attribute21,
x_attribute22,
x_attribute23,
x_attribute24
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF Get_PK_For_Validation (
new_references.person_id ) THEN
Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
Check_Parent_Existance; -- if procedure present
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
NULL;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF Get_PK_For_Validation (
new_references.person_id ) THEN
Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
NULL;
ELSIF (p_action = 'VALIDATE_DELETE') THEN
NULL;
PROCEDURE INSERT_ROW (
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ROWID IN OUT NOCOPY VARCHAR2,
x_PERSON_ID IN OUT NOCOPY NUMBER,
x_PERSON_NUMBER IN OUT NOCOPY VARCHAR2,
x_SURNAME IN VARCHAR2,
x_middle_name IN VARCHAR2,
x_GIVEN_NAMES IN VARCHAR2,
x_SEX IN VARCHAR2,
x_DECLARED_ETHNICITY IN VARCHAR2,
x_MARITAL_STATUS IN VARCHAR2,
x_MARITAL_STATUS_DATE IN VARCHAR2,
x_TITLE IN VARCHAR2,
x_STAFF_MEMBER_IND IN VARCHAR2,
x_DECEASED_IND IN VARCHAR2,
x_SUFFIX IN VARCHAR2,
x_pre_name_adjunct IN VARCHAR2,
x_ARCHIVE_EXCLUSION_IND IN VARCHAR2,
x_ARCHIVE_DT IN DATE,
x_PURGE_EXCLUSION_IND IN VARCHAR2,
x_PURGE_DT IN DATE,
x_DECEASED_DATE IN DATE,
x_PROOF_OF_INS IN VARCHAR2,
x_PROOF_OF_IMMU IN VARCHAR2,
x_BIRTH_DT IN DATE,
x_PLACE_OF_BIRTH IN VARCHAR2,
x_SALUTATION IN VARCHAR2,
x_ORACLE_USERNAME IN VARCHAR2,
x_PREFERRED_GIVEN_NAME IN VARCHAR2,
x_EMAIL_ADDR IN VARCHAR2,
x_LEVEL_OF_QUAL_ID IN NUMBER,
x_MILITARY_SERVICE_REG IN VARCHAR2,
x_VETERAN IN VARCHAR2,
X_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,
x_ATTRIBUTE_CATEGORY IN VARCHAR2,
x_ATTRIBUTE1 IN VARCHAR2,
x_ATTRIBUTE2 IN VARCHAR2,
x_ATTRIBUTE3 IN VARCHAR2,
x_ATTRIBUTE4 IN VARCHAR2,
x_ATTRIBUTE5 IN VARCHAR2,
x_ATTRIBUTE6 IN VARCHAR2,
x_ATTRIBUTE7 IN VARCHAR2,
x_ATTRIBUTE8 IN VARCHAR2,
x_ATTRIBUTE9 IN VARCHAR2,
x_ATTRIBUTE10 IN VARCHAR2,
x_ATTRIBUTE11 IN VARCHAR2,
x_ATTRIBUTE12 IN VARCHAR2,
x_ATTRIBUTE13 IN VARCHAR2,
x_ATTRIBUTE14 IN VARCHAR2,
x_ATTRIBUTE15 IN VARCHAR2,
x_ATTRIBUTE16 IN VARCHAR2,
x_ATTRIBUTE17 IN VARCHAR2,
x_ATTRIBUTE18 IN VARCHAR2,
x_ATTRIBUTE19 IN VARCHAR2,
x_ATTRIBUTE20 IN VARCHAR2,
x_PERSON_ID_TYPE IN VARCHAR2,
x_API_PERSON_ID IN VARCHAR2,
X_MODE IN VARCHAR2 ,
x_ATTRIBUTE21 IN VARCHAR2,
x_ATTRIBUTE22 IN VARCHAR2,
x_ATTRIBUTE23 IN VARCHAR2,
x_ATTRIBUTE24 IN VARCHAR2
) AS
/*************************************************************
Created By :sjalasut
Date Created By :
Purpose :Admissions Self Service redesign
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
mmkumar 19-JUL-2005 Passed NULL for x_oss_org_unit_cd in insert_row
***************************************************************/
CURSOR C IS
SELECT p.ROWID row_id
FROM hz_parties p
WHERE p.party_id = x_person_id;
SELECT rowid
FROM HZ_PARTIES
WHERE party_id = cp_person_id
AND party_number = cp_person_number;
SELECT pt.person_type_code
FROM igs_pe_person_types pt
WHERE pt.system_type = 'OTHER';
p_action=>'INSERT',
x_rowid=>X_ROWID,
x_person_id=>X_PERSON_ID,
x_person_number => X_PERSON_NUMBER,
x_surname=>X_SURNAME,
x_middle_name=>X_middle_name,
x_given_names=>X_GIVEN_NAMES,
x_sex=>X_SEX,
x_declared_ethnicity => X_declared_ethnicity,
x_marital_status => X_marital_status,
x_marital_status_date => X_marital_status_date,
x_title=>X_TITLE,
x_staff_member_ind=>NVL(X_STAFF_MEMBER_IND,'N' ),
x_deceased_ind=>NVL(X_DECEASED_IND,'N' ),
x_suffix=>X_SUFFIX,
x_pre_name_adjunct=>X_pre_name_adjunct,
x_archive_exclusion_ind=>NVL(X_ARCHIVE_EXCLUSION_IND,'N' ),
x_archive_dt=>X_ARCHIVE_DT,
x_purge_exclusion_ind=>NVL(X_PURGE_EXCLUSION_IND,'N' ),
x_purge_dt=>X_PURGE_DT,
x_deceased_date=>X_DECEASED_DATE,
x_proof_of_ins=>X_PROOF_OF_INS,
x_proof_of_immu=>X_PROOF_OF_IMMU,
x_birth_dt=>X_BIRTH_DT,
x_PLACE_OF_BIRTH => x_PLACE_OF_BIRTH,
x_salutation=>X_SALUTATION,
x_oracle_username=>X_ORACLE_USERNAME,
x_preferred_given_name=>X_PREFERRED_GIVEN_NAME,
x_email_addr=>X_EMAIL_ADDR,
x_level_of_qual_id =>X_LEVEL_OF_QUAL_ID,
x_military_service_reg=>X_MILITARY_SERVICE_REG,
x_veteran=>X_VETERAN,
x_hz_parties_ovn => X_HZ_PARTIES_OVN,
x_attribute_category=>X_ATTRIBUTE_CATEGORY,
x_attribute1=>X_ATTRIBUTE1,
x_attribute2=>X_ATTRIBUTE2,
x_attribute3=>X_ATTRIBUTE3,
x_attribute4=>X_ATTRIBUTE4,
x_attribute5=>X_ATTRIBUTE5,
x_attribute6=>X_ATTRIBUTE6,
x_attribute7=>X_ATTRIBUTE7,
x_attribute8=>X_ATTRIBUTE8,
x_attribute9=>X_ATTRIBUTE9,
x_attribute10=>X_ATTRIBUTE10,
x_attribute11=>X_ATTRIBUTE11,
x_attribute12=>X_ATTRIBUTE12,
x_attribute13=>X_ATTRIBUTE13,
x_attribute14=>X_ATTRIBUTE14,
x_attribute15=>X_ATTRIBUTE15,
x_attribute16=>X_ATTRIBUTE16,
x_attribute17=>X_ATTRIBUTE17,
x_attribute18=>X_ATTRIBUTE18,
x_attribute19=>X_ATTRIBUTE19,
x_attribute20=>X_ATTRIBUTE20,
x_attribute21=>X_ATTRIBUTE21,
x_attribute22=>X_ATTRIBUTE22,
x_attribute23=>X_ATTRIBUTE23,
x_attribute24=>X_ATTRIBUTE24
);
IGS_PE_HZ_PARTIES_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_PARTY_ID => X_PERSON_ID,
X_DECEASED_IND => new_references.deceased_ind,
X_ARCHIVE_EXCLUSION_IND => new_references.archive_exclusion_ind,
X_ARCHIVE_DT => new_references.archive_dt,
X_PURGE_EXCLUSION_IND => new_references.purge_exclusion_ind,
X_PURGE_DT => new_references.purge_dt,
X_ORACLE_USERNAME => new_references.oracle_username,
X_PROOF_OF_INS => new_references.proof_of_ins,
X_PROOF_OF_IMMU => new_references.proof_of_immu,
X_LEVEL_OF_QUAL => new_references.level_of_qual,
X_MILITARY_SERVICE_REG => new_references.military_service_reg,
X_VETERAN => new_references.veteran,
X_INSTITUTION_CD => NULL,
X_OI_LOCAL_INSTITUTION_IND => NULL,
X_OI_OS_IND => NULL,
X_OI_GOVT_INSTITUTION_CD => NULL,
X_OI_INST_CONTROL_TYPE => NULL,
X_OI_INSTITUTION_TYPE => NULL,
X_OI_INSTITUTION_STATUS => NULL,
X_OU_START_DT => NULL,
X_OU_END_DT => NULL,
X_OU_MEMBER_TYPE => NULL,
X_OU_ORG_STATUS => NULL,
X_OU_ORG_TYPE => NULL,
X_INST_ORG_IND => NULL,
X_birth_city => NULL,
X_birth_country => NULL,
x_oss_org_unit_cd => NULL, --mmkumar, party number impact
X_felony_convicted_flag => NULL,
X_MODE => NVL(x_mode,'R')
);
IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (
X_ROWID => lv_rowid,
X_PE_PERSON_ID => X_PERSON_ID,
X_API_PERSON_ID => x_api_person_id,
X_PERSON_ID_TYPE => x_person_id_type,
X_START_DT => SYSDATE,
X_END_DT => NULL,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_ATTRIBUTE16 => NULL,
X_ATTRIBUTE17 => NULL,
X_ATTRIBUTE18 => NULL,
X_ATTRIBUTE19 => NULL,
X_ATTRIBUTE20 => NULL,
X_REGION_CD => NULL,
X_MODE => NVL(x_mode,'R')
);
Igs_Pe_Typ_Instances_Pkg.INSERT_ROW (
X_ROWID => lv_rowid1,
x_PERSON_ID => X_PERSON_ID,-- new_references.PERSON_ID,
x_COURSE_CD => NULL,
x_TYPE_INSTANCE_ID => ln_TYPE_INSTANCE_ID,
x_PERSON_TYPE_CODE => lv_Person_Type_Code,
x_CC_VERSION_NUMBER => NULL,
x_FUNNEL_STATUS => NULL,
x_ADMISSION_APPL_NUMBER => NULL,
x_NOMINATED_COURSE_CD => NULL,
x_NCC_VERSION_NUMBER => NULL,
x_SEQUENCE_NUMBER => NULL,
x_START_DATE => SYSDATE,
x_END_DATE => NULL,
x_CREATE_METHOD => 'PERSON_CREATED' ,
x_ENDED_BY => NULL,
x_END_METHOD => NULL,
X_ORG_ID => FND_PROFILE.VALUE('ORG_ID'),
X_MODE => NVL(x_mode,'R'),
X_EMPLMNT_CATEGORY_CODE => null
);
Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
END INSERT_ROW;
PROCEDURE UPDATE_ROW (
X_LAST_UPDATE_DATE IN OUT NOCOPY DATE,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ROWID IN VARCHAR2,
x_PERSON_ID IN NUMBER,
x_PERSON_NUMBER IN OUT NOCOPY VARCHAR2,
x_SURNAME IN VARCHAR2,
x_middle_name IN VARCHAR2,
x_GIVEN_NAMES IN VARCHAR2,
x_SEX IN VARCHAR2,
x_DECLARED_ETHNICITY IN VARCHAR2,
x_MARITAL_STATUS IN VARCHAR2,
x_MARITAL_STATUS_DATE IN VARCHAR2,
x_TITLE IN VARCHAR2,
x_STAFF_MEMBER_IND IN VARCHAR2,
x_DECEASED_IND IN VARCHAR2,
x_SUFFIX IN VARCHAR2,
x_pre_name_adjunct IN VARCHAR2,
x_ARCHIVE_EXCLUSION_IND IN VARCHAR2,
x_ARCHIVE_DT IN DATE,
x_PURGE_EXCLUSION_IND IN VARCHAR2,
x_PURGE_DT IN DATE,
x_DECEASED_DATE IN DATE,
x_PROOF_OF_INS IN VARCHAR2,
x_PROOF_OF_IMMU IN VARCHAR2,
x_BIRTH_DT IN DATE,
x_PLACE_OF_BIRTH IN VARCHAR2,
x_SALUTATION IN VARCHAR2,
x_ORACLE_USERNAME IN VARCHAR2,
x_PREFERRED_GIVEN_NAME IN VARCHAR2,
x_EMAIL_ADDR IN VARCHAR2,
x_LEVEL_OF_QUAL_ID IN NUMBER,
x_MILITARY_SERVICE_REG IN VARCHAR2,
x_VETERAN IN VARCHAR2,
X_HZ_PARTIES_OVN IN OUT NOCOPY NUMBER,
x_ATTRIBUTE_CATEGORY IN VARCHAR2,
x_ATTRIBUTE1 IN VARCHAR2,
x_ATTRIBUTE2 IN VARCHAR2,
x_ATTRIBUTE3 IN VARCHAR2,
x_ATTRIBUTE4 IN VARCHAR2,
x_ATTRIBUTE5 IN VARCHAR2,
x_ATTRIBUTE6 IN VARCHAR2,
x_ATTRIBUTE7 IN VARCHAR2,
x_ATTRIBUTE8 IN VARCHAR2,
x_ATTRIBUTE9 IN VARCHAR2,
x_ATTRIBUTE10 IN VARCHAR2,
x_ATTRIBUTE11 IN VARCHAR2,
x_ATTRIBUTE12 IN VARCHAR2,
x_ATTRIBUTE13 IN VARCHAR2,
x_ATTRIBUTE14 IN VARCHAR2,
x_ATTRIBUTE15 IN VARCHAR2,
x_ATTRIBUTE16 IN VARCHAR2,
x_ATTRIBUTE17 IN VARCHAR2,
x_ATTRIBUTE18 IN VARCHAR2,
x_ATTRIBUTE19 IN VARCHAR2,
x_ATTRIBUTE20 IN VARCHAR2,
x_PERSON_ID_TYPE IN VARCHAR2,
x_API_PERSON_ID IN VARCHAR2,
X_MODE IN VARCHAR2 ,
x_ATTRIBUTE21 IN VARCHAR2,
x_ATTRIBUTE22 IN VARCHAR2,
x_ATTRIBUTE23 IN VARCHAR2,
x_ATTRIBUTE24 IN VARCHAR2
) AS
/*************************************************************
Created By : sjalasut
Date Created By :
Purpose :Admissions Self Service redesign
Know limitations, enhancements or remarks
Change History
Who When What
(reverse chronological order - newest change first)
mmkumar 19-JUL-2005 Passed NULL for x_oss_org_unit_cd in add_row
***************************************************************/
x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
SELECT P_ID.ROWID,P_ID.*
FROM IGS_PE_ALT_PERS_ID P_ID
WHERE pe_person_id = x_person_id AND
person_id_type = x_person_id_type AND
sysdate between start_dt AND NVL(end_dt, sysdate);
SELECT pehz.ROWID, pehz.*
FROM IGS_PE_HZ_PARTIES pehz
WHERE party_id = x_person_id;
p_action=>'UPDATE',
x_rowid=>X_ROWID,
x_person_id=>X_PERSON_ID,
x_person_number =>X_PERSON_NUMBER,
x_surname=>X_SURNAME,
x_middle_name=>X_middle_name,
x_given_names=>X_GIVEN_NAMES,
x_sex=>X_SEX,
x_declared_ethnicity => X_declared_ethnicity,
x_marital_status => X_marital_status,
x_marital_status_date => X_marital_status_date,
x_title=>X_TITLE,
x_staff_member_ind=>NVL(X_STAFF_MEMBER_IND,'N' ),
x_deceased_ind=>NVL(X_DECEASED_IND,'N' ),
x_suffix=>X_SUFFIX,
x_pre_name_adjunct=>X_pre_name_adjunct,
x_archive_exclusion_ind=>NVL(X_ARCHIVE_EXCLUSION_IND,'N' ),
x_archive_dt=>X_ARCHIVE_DT,
x_purge_exclusion_ind=>NVL(X_PURGE_EXCLUSION_IND,'N' ),
x_purge_dt=>X_PURGE_DT,
x_deceased_date=>X_DECEASED_DATE,
x_proof_of_ins=>X_PROOF_OF_INS,
x_proof_of_immu=>X_PROOF_OF_IMMU,
x_birth_dt=>X_BIRTH_DT,
x_PLACE_OF_BIRTH => x_PLACE_OF_BIRTH,
x_salutation=>X_SALUTATION,
x_oracle_username=>X_ORACLE_USERNAME,
x_preferred_given_name=>X_PREFERRED_GIVEN_NAME,
x_email_addr=>X_EMAIL_ADDR,
x_level_of_qual_id =>X_LEVEL_OF_QUAL_ID,
x_military_service_reg=>X_MILITARY_SERVICE_REG,
x_hz_parties_ovn => X_HZ_PARTIES_OVN,
x_veteran=>X_VETERAN,
x_attribute_category=>NVL(X_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR),
x_attribute1=>NVL(X_ATTRIBUTE1,FND_API.G_MISS_CHAR),
x_attribute2=>NVL(X_ATTRIBUTE2,FND_API.G_MISS_CHAR),
x_attribute3=>NVL(X_ATTRIBUTE3,FND_API.G_MISS_CHAR),
x_attribute4=>NVL(X_ATTRIBUTE4,FND_API.G_MISS_CHAR),
x_attribute5=>NVL(X_ATTRIBUTE5,FND_API.G_MISS_CHAR),
x_attribute6=>NVL(X_ATTRIBUTE6,FND_API.G_MISS_CHAR),
x_attribute7=>NVL(X_ATTRIBUTE7,FND_API.G_MISS_CHAR),
x_attribute8=>NVL(X_ATTRIBUTE8,FND_API.G_MISS_CHAR),
x_attribute9=>NVL(X_ATTRIBUTE9,FND_API.G_MISS_CHAR),
x_attribute10=>NVL(X_ATTRIBUTE10,FND_API.G_MISS_CHAR),
x_attribute11=>NVL(X_ATTRIBUTE11,FND_API.G_MISS_CHAR),
x_attribute12=>NVL(X_ATTRIBUTE12,FND_API.G_MISS_CHAR),
x_attribute13=>NVL(X_ATTRIBUTE13,FND_API.G_MISS_CHAR),
x_attribute14=>NVL(X_ATTRIBUTE14,FND_API.G_MISS_CHAR),
x_attribute15=>NVL(X_ATTRIBUTE15,FND_API.G_MISS_CHAR),
x_attribute16=>NVL(X_ATTRIBUTE16,FND_API.G_MISS_CHAR),
x_attribute17=>NVL(X_ATTRIBUTE17,FND_API.G_MISS_CHAR),
x_attribute18=>NVL(X_ATTRIBUTE18,FND_API.G_MISS_CHAR),
x_attribute19=>NVL(X_ATTRIBUTE19,FND_API.G_MISS_CHAR),
x_attribute20=>NVL(X_ATTRIBUTE20,FND_API.G_MISS_CHAR),
x_attribute21=>NVL(X_ATTRIBUTE21,FND_API.G_MISS_CHAR),
x_attribute22=>NVL(X_ATTRIBUTE22,FND_API.G_MISS_CHAR),
x_attribute23=>NVL(X_ATTRIBUTE23,FND_API.G_MISS_CHAR),
x_attribute24=>NVL(X_ATTRIBUTE24,FND_API.G_MISS_CHAR)
);
HZ_PARTY_V2PUB.UPDATE_PERSON (
p_party_object_version_number => x_hz_parties_ovn,
p_person_rec => v_person_rec,
x_profile_id => x_profile_id,
x_return_status =>x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
IGS_PE_ALT_PERS_ID_PKG.UPDATE_ROW (
X_ROWID => tlinfo.ROWID,
X_PE_PERSON_ID => new_references.person_id,
X_API_PERSON_ID => x_api_person_id,
X_PERSON_ID_TYPE => x_person_id_type,
X_START_DT => tlinfo.start_dt,
X_END_DT => tlinfo.end_dt,
X_ATTRIBUTE_CATEGORY => tlinfo.ATTRIBUTE_CATEGORY ,
X_ATTRIBUTE1 => tlinfo.ATTRIBUTE1 ,
X_ATTRIBUTE2 => tlinfo.ATTRIBUTE2 ,
X_ATTRIBUTE3 => tlinfo.ATTRIBUTE3 ,
X_ATTRIBUTE4 => tlinfo.ATTRIBUTE4 ,
X_ATTRIBUTE5 => tlinfo.ATTRIBUTE5 ,
X_ATTRIBUTE6 => tlinfo.ATTRIBUTE6 ,
X_ATTRIBUTE7 => tlinfo.ATTRIBUTE7 ,
X_ATTRIBUTE8 => tlinfo.ATTRIBUTE8 ,
X_ATTRIBUTE9 => tlinfo.ATTRIBUTE9 ,
X_ATTRIBUTE10 => tlinfo.ATTRIBUTE10 ,
X_ATTRIBUTE11 => tlinfo.ATTRIBUTE11 ,
X_ATTRIBUTE12 => tlinfo.ATTRIBUTE12 ,
X_ATTRIBUTE13 => tlinfo.ATTRIBUTE13 ,
X_ATTRIBUTE14 => tlinfo.ATTRIBUTE14 ,
X_ATTRIBUTE15 => tlinfo.ATTRIBUTE15 ,
X_ATTRIBUTE16 => tlinfo.ATTRIBUTE16 ,
X_ATTRIBUTE17 => tlinfo.ATTRIBUTE17 ,
X_ATTRIBUTE18 => tlinfo.ATTRIBUTE18 ,
X_ATTRIBUTE19 => tlinfo.ATTRIBUTE19 ,
X_ATTRIBUTE20 => tlinfo.ATTRIBUTE20 ,
X_REGION_CD => tlinfo.REGION_CD,
X_MODE => NVL(x_mode,'R')
);
IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (
X_ROWID => lv_rowid,
X_PE_PERSON_ID => new_references.person_id ,
X_API_PERSON_ID => x_api_person_id,
X_PERSON_ID_TYPE => x_person_id_type,
X_START_DT => SYSDATE,
X_END_DT => NULL,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_ATTRIBUTE16 => NULL,
X_ATTRIBUTE17 => NULL,
X_ATTRIBUTE18 => NULL,
X_ATTRIBUTE19 => NULL,
X_ATTRIBUTE20 => NULL,
X_REGION_CD => NULL,
X_MODE => NVL(x_mode,'R')
);
END UPDATE_ROW;