APPS.IGS_PE_USERID_PKG dependencies on HZ_CONTACT_POINTS

Line 174: l_email_address HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

170: l_prefix HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE;
171: l_suffix HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
172: l_gender HZ_PERSON_PROFILES.GENDER%TYPE;
173: l_birth_date DATE;
174: l_email_address HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
175: l_email_format HZ_CONTACT_POINTS.EMAIL_FORMAT%TYPE;
176: l_test_user_name FND_USER.USER_NAME%TYPE;
177: l_number NUMBER;
178: l_init_user_name FND_USER.USER_NAME%TYPE;

Line 175: l_email_format HZ_CONTACT_POINTS.EMAIL_FORMAT%TYPE;

171: l_suffix HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
172: l_gender HZ_PERSON_PROFILES.GENDER%TYPE;
173: l_birth_date DATE;
174: l_email_address HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
175: l_email_format HZ_CONTACT_POINTS.EMAIL_FORMAT%TYPE;
176: l_test_user_name FND_USER.USER_NAME%TYPE;
177: l_number NUMBER;
178: l_init_user_name FND_USER.USER_NAME%TYPE;
179: l_count NUMBER := 0;

Line 837: || The fnd user was updated with the primary email address from hz_contact points

833: || Change History :
834: || Who When What
835: || (reverse chronological order - newest change first)
836: || pkpatel 23-JAN-2003 Bug NO: 2753318
837: || The fnd user was updated with the primary email address from hz_contact points
838: || so that the mail will go to the person's primary email.
839: || gmaheswa 19-Jna-06 4869740: Stubbed
840: */
841: BEGIN

Line 1428: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

1424: l_new_address VARCHAR2(255);
1425: l_rowid VARCHAR2(255);
1426: l_msg_count NUMBER;
1427: l_msg_data VARCHAR2(255);
1428: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
1429: l_date DATE;
1430: l_id_type igs_pe_person_id_typ.person_id_type%TYPE;
1431: l_count NUMBER(9);
1432:

Line 1602: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(

1598: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1599: END IF;
1600:
1601: IF l_new_address IS NULL OR l_email_address <> l_new_address THEN
1602: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
1603: p_action => 'INSERT',
1604: p_rowid => l_rowid ,
1605: p_status => 'A',
1606: p_owner_table_name => 'HZ_PARTIES',

Line 1619: l_debug_str := 'After IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE: l_return_status: '||l_return_status||'***l_msg_data/sqlerrm:'||l_msg_data;

1615: p_contact_point_ovn => l_contact_point_ovn
1616: ) ;
1617: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1618: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic';
1619: l_debug_str := 'After IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE: l_return_status: '||l_return_status||'***l_msg_data/sqlerrm:'||l_msg_data;
1620: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1621: END IF;
1622: END IF;
1623:

Line 2179: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;

2175: FROM igs_pe_person_id_typ
2176: WHERE person_id_type = cp_pers_id_type;
2177:
2178: l_gender FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
2179: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
2180: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
2181: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
2182: l_gender_meaning FND_LOOKUP_VALUES.MEANING%TYPE;
2183: l_person_id_type IGS_PE_PERSON_ID_TYP.DESCRIPTION%TYPE;

Line 2180: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;

2176: WHERE person_id_type = cp_pers_id_type;
2177:
2178: l_gender FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
2179: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
2180: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
2181: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
2182: l_gender_meaning FND_LOOKUP_VALUES.MEANING%TYPE;
2183: l_person_id_type IGS_PE_PERSON_ID_TYP.DESCRIPTION%TYPE;
2184: l_formatted_phone VARCHAR2(100);

Line 2181: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

2177:
2178: l_gender FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
2179: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
2180: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
2181: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
2182: l_gender_meaning FND_LOOKUP_VALUES.MEANING%TYPE;
2183: l_person_id_type IGS_PE_PERSON_ID_TYP.DESCRIPTION%TYPE;
2184: l_formatted_phone VARCHAR2(100);
2185: x_return_status VARCHAR2(1);