eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_ORIG_ACK dependencies on IGS_PE_PERSON_ADDR

Line 5224: l_n_location_id igs_pe_person_addr.location_id%TYPE;

5220: --Who When What
5221: --rajagupt 29-Jun-06 bug #5348743, Added check to handle lv_return_status of warning type
5222: ------------------------------------------------------------------
5223: l_v_rowid ROWID;
5224: l_n_location_id igs_pe_person_addr.location_id%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;

Line 5228: l_n_party_site_id igs_pe_person_addr.party_site_id%TYPE;

5224: l_n_location_id igs_pe_person_addr.location_id%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;

Line 5230: l_n_party_site_ovn igs_pe_person_addr.party_site_ovn%TYPE;

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;
5234: l_v_party_site_use hz_party_site_uses.site_use_type%TYPE;

Line 5238: l_v_permt_addr1 igs_pe_person_addr.addr_line_1%TYPE;

5234: l_v_party_site_use hz_party_site_uses.site_use_type%TYPE;
5235: l_n_party_site_use_id hz_party_site_uses.party_site_use_id%TYPE;
5236: l_d_site_use_last_upd_dt DATE;
5237: l_d_profile_last_upd_dt DATE;
5238: l_v_permt_addr1 igs_pe_person_addr.addr_line_1%TYPE;
5239: l_v_permt_addr2 igs_pe_person_addr.addr_line_2%TYPE;
5240: l_v_permt_city hz_parties.city%TYPE;
5241: l_v_permt_state hz_parties.state%TYPE;
5242: l_v_postal_code igs_pe_person_addr.postal_code%TYPE;

Line 5239: l_v_permt_addr2 igs_pe_person_addr.addr_line_2%TYPE;

5235: l_n_party_site_use_id hz_party_site_uses.party_site_use_id%TYPE;
5236: l_d_site_use_last_upd_dt DATE;
5237: l_d_profile_last_upd_dt DATE;
5238: l_v_permt_addr1 igs_pe_person_addr.addr_line_1%TYPE;
5239: l_v_permt_addr2 igs_pe_person_addr.addr_line_2%TYPE;
5240: l_v_permt_city hz_parties.city%TYPE;
5241: l_v_permt_state hz_parties.state%TYPE;
5242: l_v_postal_code igs_pe_person_addr.postal_code%TYPE;
5243: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;

Line 5242: l_v_postal_code igs_pe_person_addr.postal_code%TYPE;

5238: l_v_permt_addr1 igs_pe_person_addr.addr_line_1%TYPE;
5239: l_v_permt_addr2 igs_pe_person_addr.addr_line_2%TYPE;
5240: l_v_permt_city hz_parties.city%TYPE;
5241: l_v_permt_state hz_parties.state%TYPE;
5242: l_v_postal_code igs_pe_person_addr.postal_code%TYPE;
5243: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5244: BEGIN
5245: log_to_fnd(p_v_module => 'create_person_addr_record',
5246: p_v_string => ' p_rec_resp_r1.b_ssn : ' || p_rec_resp_r1.b_ssn ||

Line 5285: igs_pe_person_addr_pkg.insert_row

5281: l_v_return_status := NULL;
5282: l_d_last_update_date := NULL;
5283: l_v_msg_data := NULL;
5284:
5285: igs_pe_person_addr_pkg.insert_row
5286: (
5287: p_action => 'R',
5288: p_rowid => l_v_rowid,
5289: p_location_id => l_n_location_id,