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

Line 621: FROM igs_pe_person_id_typ pit_2,

617: igs_ca_inst ci,
618: igf_ap_fa_base_rec facon,
619: (SELECT api_person_id,
620: pe_person_id
621: FROM igs_pe_person_id_typ pit_2,
622: igs_pe_alt_pers_id api_2
623: WHERE api_2.person_id_type = pit_2.person_id_type
624: AND pit_2.s_person_id_type = 'SSN'
625: AND SYSDATE BETWEEN api_2.start_dt AND NVL (api_2.end_dt,SYSDATE)) pit,

Line 4824: ,igs_pe_person_id_typ pit

4820: ,api_person_id_uf prsn_ssn --unformatted ssn value
4821: ,hz.person_first_name firstname
4822: ,hz.person_last_name lastname
4823: FROM igs_pe_alt_pers_id api
4824: ,igs_pe_person_id_typ pit
4825: ,hz_parties hz
4826: WHERE api.person_id_type = pit.person_id_type
4827: AND pit.s_person_id_type = 'SSN'
4828: AND hz.party_id = api.pe_person_id

Line 5002: FROM igs_pe_person_id_typ

4998: --Who When What
4999: ------------------------------------------------------------------
5000: CURSOR c_person_id_type( cp_v_pers_id_type VARCHAR2 ) IS
5001: SELECT person_id_type
5002: FROM igs_pe_person_id_typ
5003: WHERE s_person_id_type = cp_v_pers_id_type ;
5004:
5005:
5006: l_n_msg_count NUMBER ;

Line 5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;

5008: l_v_return_status VARCHAR2(10);
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;

Line 5019: l_d_date_of_birth igs_pe_person.birth_dt%TYPE;

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;
5018: l_v_person_middle_name hz_parties.person_middle_name%TYPE;
5019: l_d_date_of_birth igs_pe_person.birth_dt%TYPE;
5020: l_b_ret_status BOOLEAN;
5021: BEGIN
5022:
5023: log_to_fnd(p_v_module => 'create_person_record',

Line 5082: p_v_string => ' Invoking igs_pe_person_pkg.insert_row '

5078: l_v_person_number := NULL;
5079: l_n_location_ovn := NULL;
5080:
5081: log_to_fnd(p_v_module => 'create_person_record',
5082: p_v_string => ' Invoking igs_pe_person_pkg.insert_row '
5083: );
5084:
5085: igs_pe_person_pkg.insert_row
5086: (

Line 5085: igs_pe_person_pkg.insert_row

5081: log_to_fnd(p_v_module => 'create_person_record',
5082: p_v_string => ' Invoking igs_pe_person_pkg.insert_row '
5083: );
5084:
5085: igs_pe_person_pkg.insert_row
5086: (
5087: x_msg_count => l_n_msg_count,
5088: x_msg_data => l_v_msg_data,
5089: x_return_status => l_v_return_status,

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,