APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_PE_TYP_INSTANCES

Line 14: npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkg

10: Change History :
11: ENH Bug No : 1872994
12: ENH Desc : Modelling and Forcasting DLD- Institutions Build
13: Who When What
14: npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkg
15: calls modified for the new employment
16: category column added in the table
17: masehgal 19-Aug-2002 # 2502020 Removed validation for Phone Number already existing in OSS while importing institutions
18: Removed Commented Code

Line 310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;

306: l_party_last_update_date DATE;
307: l_org_cont_last_update_date DATE;
308: l_org_contact_id igs_or_contacts_v.org_contact_id%TYPE;
309: l_or_cont_id igs_or_contacts_v.org_contact_id%TYPE;
310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;
311: l_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;
313: l_contact_number igs_or_contacts_v.contact_number%TYPE;
314: l_cont_dml_operation VARCHAR2(10);

Line 311: l_instance_id igs_pe_typ_instances.type_instance_id%TYPE;

307: l_org_cont_last_update_date DATE;
308: l_org_contact_id igs_or_contacts_v.org_contact_id%TYPE;
309: l_or_cont_id igs_or_contacts_v.org_contact_id%TYPE;
310: l_org_id igs_pe_typ_instances_all.org_id%TYPE;
311: l_instance_id igs_pe_typ_instances.type_instance_id%TYPE;
312: l_contact_point_id igs_or_contacts_v.org_contact_id%TYPE;
313: l_contact_number igs_or_contacts_v.contact_number%TYPE;
314: l_cont_dml_operation VARCHAR2(10);
315: l_lst_update_date DATE;

Line 441: l_person_type igs_pe_typ_instances.person_type_code%TYPE;

437: PROCEDURE associate_persontype(p_interface_contacts_id igs_or_inst_con_int.interface_contacts_id%TYPE,
438: p_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE
439: ) IS
440:
441: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
442:
443: --Cursor to fetch person type
444: CURSOR cur_person_type(cp_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE) IS
445: SELECT person_type_code

Line 446: FROM igs_pe_typ_instances_all

442:
443: --Cursor to fetch person type
444: CURSOR cur_person_type(cp_contact_party_id igs_or_inst_con_int.contact_party_id%TYPE) IS
445: SELECT person_type_code
446: FROM igs_pe_typ_instances_all
447: WHERE person_id = cp_contact_party_id AND
448: SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
449:
450: p_status VARCHAR2(1);

Line 468: igs_pe_typ_instances_pkg.insert_row

464: l_type_rowid:=NULL;
465: l_instance_id:=NULL;
466:
467: --Create the person type for this contact id
468: igs_pe_typ_instances_pkg.insert_row
469: (
470: x_rowid => l_type_rowid,
471: x_person_id => p_contact_party_id,
472: x_course_cd => NULL,