DBA Data[Home] [Help]

APPS.IGS_AD_SS_PERSON_PKG dependencies on IGS_PE_TYP_INSTANCES

Line 580: ln_type_instance_id IGS_PE_TYP_INSTANCES.TYPE_INSTANCE_ID%TYPE;

576: FROM hz_parties p
577: WHERE p.party_id = x_person_id;
578: lv_rowid VARCHAR2(30);
579: lv_rowid1 VARCHAR2(30);
580: ln_type_instance_id IGS_PE_TYP_INSTANCES.TYPE_INSTANCE_ID%TYPE;
581: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
582: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
583: CURSOR c_pe_rowid (cp_person_id IGS_PE_PERSON.PERSON_ID%TYPE,
584: cp_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE) IS

Line 747: Igs_Pe_Typ_Instances_Pkg.INSERT_ROW (

743: X_MODE => NVL(x_mode,'R')
744: );
745: END IF;
746:
747: Igs_Pe_Typ_Instances_Pkg.INSERT_ROW (
748: X_ROWID => lv_rowid1,
749: x_PERSON_ID => X_PERSON_ID,-- new_references.PERSON_ID,
750: x_COURSE_CD => NULL,
751: x_TYPE_INSTANCE_ID => ln_TYPE_INSTANCE_ID,