DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

5885: x_msg_data OUT NOCOPY VARCHAR2,
5886: x_contact_point_id OUT NOCOPY NUMBER)
5887: IS
5888:
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

Line 5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

5886: x_contact_point_id OUT NOCOPY NUMBER)
5887: IS
5888:
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

Line 5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

5887: IS
5888:
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5895:

Line 5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;

5888:
5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5895:
5896: G_ERROR EXCEPTION;

Line 5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

5889: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5895:
5896: G_ERROR EXCEPTION;
5897:

Line 5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

5890: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5891: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5892: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5893: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5894: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5895:
5896: G_ERROR EXCEPTION;
5897:
5898: BEGIN

Line 5943: HZ_CONTACT_POINT_V2PUB.create_contact_point (

5939: --contact creation end
5940:
5941: END IF;
5942:
5943: HZ_CONTACT_POINT_V2PUB.create_contact_point (
5944: p_init_msg_list => p_init_msg_list,
5945: p_contact_point_rec => l_contact_point_rec,
5946: p_email_rec => l_email_rec_type,
5947: p_phone_rec => l_phone_rec_type,

Line 5983: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

5979: x_msg_count OUT NOCOPY NUMBER,
5980: x_msg_data OUT NOCOPY VARCHAR2)
5981: IS
5982: l_object_Version_number NUMBER := 1 ;
5983: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5984: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5985: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5986: G_ERROR EXCEPTION;
5987:

Line 5984: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

5980: x_msg_data OUT NOCOPY VARCHAR2)
5981: IS
5982: l_object_Version_number NUMBER := 1 ;
5983: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5984: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5985: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5986: G_ERROR EXCEPTION;
5987:
5988: CURSOR l_cpoint_csr IS

Line 5985: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

5981: IS
5982: l_object_Version_number NUMBER := 1 ;
5983: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5984: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5985: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5986: G_ERROR EXCEPTION;
5987:
5988: CURSOR l_cpoint_csr IS
5989: SELECT last_update_date, object_version_number, contact_point_type

Line 6027: HZ_CONTACT_POINT_V2PUB.update_contact_point (

6023:
6024: END IF;
6025: l_object_version_number := l_cpoint_rec.object_Version_number;
6026:
6027: HZ_CONTACT_POINT_V2PUB.update_contact_point (
6028: p_init_msg_list => p_init_msg_list,
6029: p_contact_point_rec => l_contact_point_rec,
6030: p_email_rec => l_email_rec_type,
6031: p_phone_rec => l_phone_rec_type,