APPS.IGF_SL_CL_ORIG_ACK dependencies on HZ_PARTY_SITE_USES

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

Line 5235: l_n_party_site_use_id hz_party_site_uses.party_site_use_id%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;
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;

Line 5366: p_v_string => ' Invoking igs_pe_party_site_use_pkg.hz_party_site_uses_ak'

5362: l_d_profile_last_upd_dt := NULL;
5363: l_n_party_site_ovn := NULL;
5364:
5365: log_to_fnd(p_v_module => 'create_person_addr_record',
5366: p_v_string => ' Invoking igs_pe_party_site_use_pkg.hz_party_site_uses_ak'
5367: );
5368:
5369: igs_pe_party_site_use_pkg.hz_party_site_uses_ak (
5370: p_action => 'INSERT',

Line 5369: igs_pe_party_site_use_pkg.hz_party_site_uses_ak (

5365: log_to_fnd(p_v_module => 'create_person_addr_record',
5366: p_v_string => ' Invoking igs_pe_party_site_use_pkg.hz_party_site_uses_ak'
5367: );
5368:
5369: igs_pe_party_site_use_pkg.hz_party_site_uses_ak (
5370: p_action => 'INSERT',
5371: p_rowid => l_v_rowid,
5372: p_party_site_use_id => l_n_party_site_use_id,
5373: p_party_site_id => l_n_party_site_id,

Line 5386: p_v_string => ' igs_pe_party_site_use_pkg.hz_party_site_uses_ak failed '

5382: );
5383:
5384: IF l_v_return_status <> 'S' THEN
5385: log_to_fnd(p_v_module => 'create_person_addr_record',
5386: p_v_string => ' igs_pe_party_site_use_pkg.hz_party_site_uses_ak failed '
5387: );
5388: RETURN FALSE;
5389: END IF;
5390: log_to_fnd(p_v_module => 'create_person_addr_record',

Line 5391: p_v_string => ' igs_pe_party_site_use_pkg.hz_party_site_uses_ak successfully executed'

5387: );
5388: RETURN FALSE;
5389: END IF;
5390: log_to_fnd(p_v_module => 'create_person_addr_record',
5391: p_v_string => ' igs_pe_party_site_use_pkg.hz_party_site_uses_ak successfully executed'
5392: );
5393: RETURN TRUE;
5394: END create_person_addr_record;
5395: