DBA Data[Home] [Help]

APPS.IGF_SL_CL_ORIG_ACK dependencies on HZ_LOCATIONS

Line 5013: l_n_location_ovn hz_locations.object_version_number%TYPE;

5009: l_v_rowid ROWID;
5010: l_n_person_id hz_parties.party_id%TYPE;
5011: l_v_person_number hz_parties.party_number%TYPE;
5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
5013: l_n_location_ovn hz_locations.object_version_number%TYPE;
5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
5016: l_v_person_first_name hz_parties.person_first_name%TYPE;
5017: l_v_person_last_name hz_parties.person_last_name%TYPE;

Line 5229: l_n_location_ovn hz_locations.object_version_number%TYPE;

5225: l_n_msg_count NUMBER ;
5226: l_v_msg_data VARCHAR2(1000);
5227: l_v_return_status VARCHAR2(10);
5228: l_n_party_site_id igs_pe_person_addr.party_site_id%TYPE;
5229: l_n_location_ovn hz_locations.object_version_number%TYPE;
5230: l_n_party_site_ovn igs_pe_person_addr.party_site_ovn%TYPE;
5231: l_d_last_update_date DATE;
5232: l_n_person_id hz_parties.party_id%TYPE;
5233: l_v_person_number hz_parties.party_number%TYPE;

Line 5543: l_n_location_ovn hz_locations.object_version_number%TYPE;

5539: l_n_msg_count NUMBER ;
5540: l_v_msg_data VARCHAR2(1000);
5541: l_v_return_status VARCHAR2(10);
5542: l_d_last_update_date DATE;
5543: l_n_location_ovn hz_locations.object_version_number%TYPE;
5544: l_n_relationship_id hz_relationships.relationship_id%TYPE;
5545: l_n_party_id hz_parties.party_id%TYPE;
5546: l_v_party_number hz_parties.party_number%TYPE;
5547: