APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_INST_CPHN_INT

Line 533: PROCEDURE process_contact_phones( p_interface_cont_id IN igs_or_inst_cphn_int.interface_inst_cont_phone_id%TYPE,

529: RAISE SKIP_CONTACT;
530: END associate_persontype;
531:
532: --Process the Contact Phones
533: PROCEDURE process_contact_phones( p_interface_cont_id IN igs_or_inst_cphn_int.interface_inst_cont_phone_id%TYPE,
534: p_rel_party_id IN igs_or_contacts_v.rel_party_id%TYPE)
535: /*
536: || Change History
537: ||

Line 554: l_val_fail_err_cd igs_or_inst_cphn_int.error_code%TYPE;

550: l_ret_status VARCHAR2(1);
551: l_last_update_date DATE;
552: l_orig_sys_ref VARCHAR2(10);
553: SKIP_PHONE EXCEPTION;
554: l_val_fail_err_cd igs_or_inst_cphn_int.error_code%TYPE;
555: l_ovn hz_contact_points.object_version_number%TYPE;
556:
557:
558: --Cursor to fetch the Phone information from Phone Interface Table for the Interface Identifier

Line 559: CURSOR cur_get_int_phones(cp_interface_cont_id igs_or_inst_cphn_int.interface_inst_cont_phone_id%TYPE,

555: l_ovn hz_contact_points.object_version_number%TYPE;
556:
557:
558: --Cursor to fetch the Phone information from Phone Interface Table for the Interface Identifier
559: CURSOR cur_get_int_phones(cp_interface_cont_id igs_or_inst_cphn_int.interface_inst_cont_phone_id%TYPE,
560: cp_status igs_or_inst_cphn_int.status%TYPE) IS
561: SELECT *
562: FROM igs_or_inst_cphn_int
563: WHERE interface_cont_id =cp_interface_cont_id

Line 560: cp_status igs_or_inst_cphn_int.status%TYPE) IS

556:
557:
558: --Cursor to fetch the Phone information from Phone Interface Table for the Interface Identifier
559: CURSOR cur_get_int_phones(cp_interface_cont_id igs_or_inst_cphn_int.interface_inst_cont_phone_id%TYPE,
560: cp_status igs_or_inst_cphn_int.status%TYPE) IS
561: SELECT *
562: FROM igs_or_inst_cphn_int
563: WHERE interface_cont_id =cp_interface_cont_id
564: AND status =cp_status;

Line 562: FROM igs_or_inst_cphn_int

558: --Cursor to fetch the Phone information from Phone Interface Table for the Interface Identifier
559: CURSOR cur_get_int_phones(cp_interface_cont_id igs_or_inst_cphn_int.interface_inst_cont_phone_id%TYPE,
560: cp_status igs_or_inst_cphn_int.status%TYPE) IS
561: SELECT *
562: FROM igs_or_inst_cphn_int
563: WHERE interface_cont_id =cp_interface_cont_id
564: AND status =cp_status;
565:
566: int_phones_rec cur_get_int_phones%ROWTYPE;

Line 569: CURSOR c_val_phone(p_type igs_or_inst_cphn_int.type%TYPE,

565:
566: int_phones_rec cur_get_int_phones%ROWTYPE;
567:
568: --cursor for validating data before importing phones (tray)
569: CURSOR c_val_phone(p_type igs_or_inst_cphn_int.type%TYPE,
570: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
571: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
572: SELECT 'X'
573: FROM fnd_lookup_values

Line 583: CURSOR country_validate (p_country_code IGS_OR_INST_CPHN_INT.COUNTRY_CODE%TYPE)IS

579: AND language = userenv('LANG');
580:
581: c_val_phone_rec c_val_phone%rowtype;
582:
583: CURSOR country_validate (p_country_code IGS_OR_INST_CPHN_INT.COUNTRY_CODE%TYPE)IS
584: SELECT phone_country_code
585: FROM fnd_territories_vl ter, hz_phone_country_codes hzc
586: WHERE ter.territory_code = hzc.territory_code
587: AND hzc.phone_country_code = p_country_code ;

Line 592: PROCEDURE update_int_phones(p_int_phones_rec igs_or_inst_cphn_int%ROWTYPE,

588:
589: country_validate_rec country_validate%ROWTYPE;
590:
591: --Procedure to update the Phones Interface Table
592: PROCEDURE update_int_phones(p_int_phones_rec igs_or_inst_cphn_int%ROWTYPE,
593: p_err_cd igs_or_inst_cphn_int.error_code%TYPE,
594: p_err_text igs_or_inst_cphn_int.error_text%TYPE
595: )
596: AS

Line 593: p_err_cd igs_or_inst_cphn_int.error_code%TYPE,

589: country_validate_rec country_validate%ROWTYPE;
590:
591: --Procedure to update the Phones Interface Table
592: PROCEDURE update_int_phones(p_int_phones_rec igs_or_inst_cphn_int%ROWTYPE,
593: p_err_cd igs_or_inst_cphn_int.error_code%TYPE,
594: p_err_text igs_or_inst_cphn_int.error_text%TYPE
595: )
596: AS
597:

Line 594: p_err_text igs_or_inst_cphn_int.error_text%TYPE

590:
591: --Procedure to update the Phones Interface Table
592: PROCEDURE update_int_phones(p_int_phones_rec igs_or_inst_cphn_int%ROWTYPE,
593: p_err_cd igs_or_inst_cphn_int.error_code%TYPE,
594: p_err_text igs_or_inst_cphn_int.error_text%TYPE
595: )
596: AS
597:
598: BEGIN

Line 601: UPDATE igs_or_inst_cphn_int

597:
598: BEGIN
599:
600: --Since there is no Table Handler Direct Update on Table
601: UPDATE igs_or_inst_cphn_int
602: SET status = p_int_phones_rec.status,
603: error_code = p_err_cd,
604: error_text = p_err_text
605: WHERE interface_inst_cont_phone_id = p_int_phones_rec.interface_inst_cont_phone_id;