DBA Data[Home] [Help]

APPS.IGS_AD_IMP_004 dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE

846: l_expected_completion_perd IGS_AD_PS_APPL_INST.expected_completion_perd%TYPE;
847:
848: l_finaid_apply_date igs_ad_ps_appl_inst.finaid_apply_date%TYPE;
849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE
851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE
852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE
853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS
854:

Line 851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE

847:
848: l_finaid_apply_date igs_ad_ps_appl_inst.finaid_apply_date%TYPE;
849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE
851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE
852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE
853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS
854:
855: l_rowid VARCHAR2(25);

Line 852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE

848: l_finaid_apply_date igs_ad_ps_appl_inst.finaid_apply_date%TYPE;
849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE
851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE
852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE
853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS
854:
855: l_rowid VARCHAR2(25);
856: l_org_id NUMBER(15);

Line 853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS

849: l_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
850: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE
851: ,p_nominated_course_cd IN igs_pe_typ_instances_all.nominated_course_cd%TYPE
852: ,p_person_id IN igs_pe_typ_instances_all.person_id%TYPE
853: ,p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE ) AS
854:
855: l_rowid VARCHAR2(25);
856: l_org_id NUMBER(15);
857: l_type_instance_id NUMBER;