DBA Data[Home] [Help]

APPS.ARH_PHON_PKG dependencies on HZ_CONTACT_POINT_V2PUB

Line 343: email_rec hz_contact_point_v2pub.email_rec_type;

339: -- web_rec hz_contact_point_pub.web_rec_type;
340: -- cpoint_rec hz_contact_point_pub.contact_points_rec_type;
341: -- cust_point_rec hz_customer_accounts_pub.cust_contact_pt_rec_type;
342: --
343: email_rec hz_contact_point_v2pub.email_rec_type;
344: edi_rec hz_contact_point_v2pub.edi_rec_type;
345: phone_rec hz_contact_point_v2pub.phone_rec_type;
346: telex_rec hz_contact_point_v2pub.telex_rec_type;
347: web_rec hz_contact_point_v2pub.web_rec_type;

Line 344: edi_rec hz_contact_point_v2pub.edi_rec_type;

340: -- cpoint_rec hz_contact_point_pub.contact_points_rec_type;
341: -- cust_point_rec hz_customer_accounts_pub.cust_contact_pt_rec_type;
342: --
343: email_rec hz_contact_point_v2pub.email_rec_type;
344: edi_rec hz_contact_point_v2pub.edi_rec_type;
345: phone_rec hz_contact_point_v2pub.phone_rec_type;
346: telex_rec hz_contact_point_v2pub.telex_rec_type;
347: web_rec hz_contact_point_v2pub.web_rec_type;
348: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

Line 345: phone_rec hz_contact_point_v2pub.phone_rec_type;

341: -- cust_point_rec hz_customer_accounts_pub.cust_contact_pt_rec_type;
342: --
343: email_rec hz_contact_point_v2pub.email_rec_type;
344: edi_rec hz_contact_point_v2pub.edi_rec_type;
345: phone_rec hz_contact_point_v2pub.phone_rec_type;
346: telex_rec hz_contact_point_v2pub.telex_rec_type;
347: web_rec hz_contact_point_v2pub.web_rec_type;
348: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
349: --

Line 346: telex_rec hz_contact_point_v2pub.telex_rec_type;

342: --
343: email_rec hz_contact_point_v2pub.email_rec_type;
344: edi_rec hz_contact_point_v2pub.edi_rec_type;
345: phone_rec hz_contact_point_v2pub.phone_rec_type;
346: telex_rec hz_contact_point_v2pub.telex_rec_type;
347: web_rec hz_contact_point_v2pub.web_rec_type;
348: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
349: --
350: x_cust_acct_profile_amt_id NUMBER;

Line 347: web_rec hz_contact_point_v2pub.web_rec_type;

343: email_rec hz_contact_point_v2pub.email_rec_type;
344: edi_rec hz_contact_point_v2pub.edi_rec_type;
345: phone_rec hz_contact_point_v2pub.phone_rec_type;
346: telex_rec hz_contact_point_v2pub.telex_rec_type;
347: web_rec hz_contact_point_v2pub.web_rec_type;
348: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
349: --
350: x_cust_acct_profile_amt_id NUMBER;
351: x_owner_table VARCHAR2(30);

Line 348: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

344: edi_rec hz_contact_point_v2pub.edi_rec_type;
345: phone_rec hz_contact_point_v2pub.phone_rec_type;
346: telex_rec hz_contact_point_v2pub.telex_rec_type;
347: web_rec hz_contact_point_v2pub.web_rec_type;
348: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
349: --
350: x_cust_acct_profile_amt_id NUMBER;
351: x_owner_table VARCHAR2(30);
352: x_owner_table_id NUMBER;

Line 475: HZ_CONTACT_POINT_V2PUB.create_contact_point (

471: email_rec.email_address := x_email_address;
472: cpoint_rec.contact_point_type := x_phone_type;
473: END IF;
474: -- call V2 API.
475: HZ_CONTACT_POINT_V2PUB.create_contact_point (
476: p_contact_point_rec => cpoint_rec,
477: p_edi_rec => edi_rec,
478: p_email_rec => email_rec,
479: p_phone_rec => phone_rec,

Line 554: email_rec hz_contact_point_v2pub.email_rec_type;

550: ) IS
551:
552: l_type VARCHAR2(4);
553: l_id NUMBER(15);
554: email_rec hz_contact_point_v2pub.email_rec_type;
555: edi_rec hz_contact_point_v2pub.edi_rec_type;
556: phone_rec hz_contact_point_v2pub.phone_rec_type;
557: telex_rec hz_contact_point_v2pub.telex_rec_type;
558: web_rec hz_contact_point_v2pub.web_rec_type;

Line 555: edi_rec hz_contact_point_v2pub.edi_rec_type;

551:
552: l_type VARCHAR2(4);
553: l_id NUMBER(15);
554: email_rec hz_contact_point_v2pub.email_rec_type;
555: edi_rec hz_contact_point_v2pub.edi_rec_type;
556: phone_rec hz_contact_point_v2pub.phone_rec_type;
557: telex_rec hz_contact_point_v2pub.telex_rec_type;
558: web_rec hz_contact_point_v2pub.web_rec_type;
559: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

Line 556: phone_rec hz_contact_point_v2pub.phone_rec_type;

552: l_type VARCHAR2(4);
553: l_id NUMBER(15);
554: email_rec hz_contact_point_v2pub.email_rec_type;
555: edi_rec hz_contact_point_v2pub.edi_rec_type;
556: phone_rec hz_contact_point_v2pub.phone_rec_type;
557: telex_rec hz_contact_point_v2pub.telex_rec_type;
558: web_rec hz_contact_point_v2pub.web_rec_type;
559: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
560: tmp_var VARCHAR2(2000);

Line 557: telex_rec hz_contact_point_v2pub.telex_rec_type;

553: l_id NUMBER(15);
554: email_rec hz_contact_point_v2pub.email_rec_type;
555: edi_rec hz_contact_point_v2pub.edi_rec_type;
556: phone_rec hz_contact_point_v2pub.phone_rec_type;
557: telex_rec hz_contact_point_v2pub.telex_rec_type;
558: web_rec hz_contact_point_v2pub.web_rec_type;
559: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
560: tmp_var VARCHAR2(2000);
561: i NUMBER;

Line 558: web_rec hz_contact_point_v2pub.web_rec_type;

554: email_rec hz_contact_point_v2pub.email_rec_type;
555: edi_rec hz_contact_point_v2pub.edi_rec_type;
556: phone_rec hz_contact_point_v2pub.phone_rec_type;
557: telex_rec hz_contact_point_v2pub.telex_rec_type;
558: web_rec hz_contact_point_v2pub.web_rec_type;
559: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
560: tmp_var VARCHAR2(2000);
561: i NUMBER;
562: tmp_var1 VARCHAR2(2000);

Line 559: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

555: edi_rec hz_contact_point_v2pub.edi_rec_type;
556: phone_rec hz_contact_point_v2pub.phone_rec_type;
557: telex_rec hz_contact_point_v2pub.telex_rec_type;
558: web_rec hz_contact_point_v2pub.web_rec_type;
559: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
560: tmp_var VARCHAR2(2000);
561: i NUMBER;
562: tmp_var1 VARCHAR2(2000);
563: l_update_date DATE;

Line 656: HZ_CONTACT_POINT_V2PUB.update_contact_point (

652: return;
653: END IF;
654:
655:
656: HZ_CONTACT_POINT_V2PUB.update_contact_point (
657: p_contact_point_rec => cpoint_rec,
658: p_edi_rec => edi_rec,
659: p_email_rec => email_rec,
660: p_phone_rec => phone_rec,