DBA Data[Home] [Help]

APPS.IGS_AD_IMP_008 dependencies on HZ_CONTACT_POINT_V2PUB

Line 20: TO HZ_CONTACT_POINT_V2PUB for create

16: 100 records .New variable l_processed_records added
17: rrengara 16-DEC-2002 Bug 2693734, 2696082, 2694051, 2692214 fixes
18: gmuralid 26-NOV-2002 BUG 2466674 -- V2API uptake
19: Changed reference of HZ_CONTACT_POINT_PUB
20: TO HZ_CONTACT_POINT_V2PUB for create
21: and update of contact points
22:
23: gmuralid 27-NOV-2002 BUG 2676422 -- commented created_by_module := 'IGS' in update
24: call of contact point

Line 1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

1663: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
1664: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
1665: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
1666:
1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1669: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1670: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1671: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;

Line 1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

1664: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
1665: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
1666:
1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1669: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1670: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1671: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1672: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;

Line 1669: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

1665: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
1666:
1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1669: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1670: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1671: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1672: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
1673: l_last_update_date DATE;

Line 1670: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;

1666:
1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1669: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1670: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1671: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1672: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
1673: l_last_update_date DATE;
1674: l_check VARCHAR2(30);

Line 1671: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;

1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1669: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1670: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1671: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1672: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
1673: l_last_update_date DATE;
1674: l_check VARCHAR2(30);
1675:

Line 1672: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;

1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1669: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1670: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1671: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1672: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
1673: l_last_update_date DATE;
1674: l_check VARCHAR2(30);
1675:
1676: tmp_var1 VARCHAR2(2000);

Line 1686: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;

1682: l_msg_count NUMBER;
1683: l_msg_data VARCHAR2(2000);
1684: l_Status igs_ad_relations_int.status%TYPE;
1685: l_Error_Code igs_ad_relations_int.error_code%TYPE;
1686: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1689: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1690: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;

Line 1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;

1683: l_msg_data VARCHAR2(2000);
1684: l_Status igs_ad_relations_int.status%TYPE;
1685: l_Error_Code igs_ad_relations_int.error_code%TYPE;
1686: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1689: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1690: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1691: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;

Line 1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

1684: l_Status igs_ad_relations_int.status%TYPE;
1685: l_Error_Code igs_ad_relations_int.error_code%TYPE;
1686: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1689: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1690: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1691: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
1692: ln_Error_Code NUMBER;

Line 1689: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;

1685: l_Error_Code igs_ad_relations_int.error_code%TYPE;
1686: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1689: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1690: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1691: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
1692: ln_Error_Code NUMBER;
1693: l_last_update_date DATE;

Line 1690: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;

1686: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1689: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1690: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1691: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
1692: ln_Error_Code NUMBER;
1693: l_last_update_date DATE;
1694:

Line 1691: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;

1687: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1688: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
1689: l_telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
1690: l_web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
1691: l_edi_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type;
1692: ln_Error_Code NUMBER;
1693: l_last_update_date DATE;
1694:
1695: tmp_var1 VARCHAR2(2000);

Line 1739: HZ_CONTACT_POINT_V2PUB.create_contact_point(

1735: phone_rec.phone_area_code := p_rel_con_rec.phone_area_code;
1736: phone_rec.phone_number := p_rel_con_rec.phone_number;
1737: phone_rec.phone_extension := p_rel_con_rec.phone_extension;
1738: END IF;
1739: HZ_CONTACT_POINT_V2PUB.create_contact_point(
1740: p_init_msg_list => FND_API.G_FALSE,
1741: p_contact_point_rec => contact_point_rec,
1742: p_edi_rec => l_edi_rec,
1743: p_email_rec => email_rec,

Line 2120: HZ_CONTACT_POINT_V2PUB.update_contact_point(

2116: FETCH get_obj_version INTO l_obj_ver;
2117: CLOSE get_obj_version;
2118:
2119: --Usage of API HZ_CONTACT_POINT_PUB.update_contact_points
2120: HZ_CONTACT_POINT_V2PUB.update_contact_point(
2121: p_init_msg_list => FND_API.G_FALSE,
2122: p_contact_point_rec => contact_point_rec,
2123: p_email_rec => email_rec ,
2124: p_phone_rec => phone_rec,

Line 2217: HZ_CONTACT_POINT_V2PUB.update_contact_point(

2213:
2214: --Usage of API HZ_CONTACT_POINT_PUB.update_contact_points
2215: BEGIN --ssomani added BEGIN - EXCEPTION - END Block 15 March 2001
2216:
2217: HZ_CONTACT_POINT_V2PUB.update_contact_point(
2218: p_init_msg_list => FND_API.G_FALSE,
2219: p_contact_point_rec => contact_point_rec,
2220: p_email_rec => email_rec ,
2221: p_phone_rec => phone_rec,