DBA Data[Home] [Help]

APPS.IGS_AD_IMP_008 dependencies on IGS_PE_PERSON_ADDR_PKG

Line 111: || asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed

107: || Who When What
108: || skpandey 21-SEP-2005 Bug: 3663505
109: || Description: Added ATTRIBUTES 21 TO 24 TO STORE ADDITIONAL INFORMATION
110: || pkpatel 15-APR-2002 Bug no.1834307 : Modified the Relationship_Type_C cursor to validate both Relationship_code and relationship_type
111: || asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed
112: || asbala 15-APR-2004 3349171: Incorrect usage of fnd_lookup_values view
113: || (reverse chronological order - newest change first)
114: */
115:

Line 811: IGS_PE_PERSON_ADDR_PKG.UPDATE_ROW(

807: -- cursor to fetch l_last_update_date from hz_locations for a given location_id
808: l_location_ovn := addr_rec.location_ovn;
809: l_party_site_ovn := addr_rec.party_site_ovn;
810:
811: IGS_PE_PERSON_ADDR_PKG.UPDATE_ROW(
812: p_action => NULL,
813: p_rowid => l_row_id,
814: p_location_id => l_location_id ,
815: p_start_dt => nvl(reladdr_rec.start_dt,addr_rec.start_dt) ,

Line 1357: IGS_PE_PERSON_ADDR_PKG.INSERT_ROW (

1353: l_flag_check_status VARCHAR2(1) := 'Y';
1354: l_addr_warning VARCHAR2(1) := 'N';
1355: BEGIN
1356: --Create the person address.
1357: IGS_PE_PERSON_ADDR_PKG.INSERT_ROW (
1358: p_action => NULL,
1359: p_rowid => l_row_id,
1360: p_location_id => l_location_id,
1361: p_start_dt => reladdr_rec.start_dt,