APPS.IGS_AD_IMP_004 dependencies on HZ_PARTIES

Line 318: p_person_id hz_parties.party_id%TYPE,

314: WHERE person_id = appl_Rec.person_id
315: AND admission_Appl_number = appl_rec.update_adm_appl_number;
316:
317: CURSOR dup_applinst_cur(applinst_rec applinst_cur%ROWTYPE,
318: p_person_id hz_parties.party_id%TYPE,
319: p_admission_appl_number IGS_AD_APPL.admission_Appl_number%TYPE
320: ) IS
321: SELECT
322: acai.rowid,acai.*

Line 740: p_person_id hz_parties.party_id%TYPE,

736:
737: END update_application_details;
738: --Declaration of create_single_appl_instance
739: PROCEDURE create_single_appl_instance(p_applinst_rec applinst_cur%ROWTYPE,
740: p_person_id hz_parties.party_id%TYPE,
741: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,
742: p_appl_rec appl_cur%ROWTYPE,
743: p_Status OUT NOCOPY VARCHAR2) ;
744:

Line 746: p_person_id hz_parties.party_id%TYPE,

742: p_appl_rec appl_cur%ROWTYPE,
743: p_Status OUT NOCOPY VARCHAR2) ;
744:
745: PROCEDURE create_application_instance(p_interface_appl_id IGS_AD_APL_INT.interface_appl_id%TYPE,
746: p_person_id hz_parties.party_id%TYPE,
747: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,
748: p_appl_rec appl_cur%ROWTYPE,
749: p_Status_instance OUT NOCOPY VARCHAR2) IS
750: --------------------------------------------------------------------------

Line 789: p_person_id hz_parties.party_id%TYPE,

785: END create_application_instance;
786:
787:
788: PROCEDURE create_single_appl_instance(p_applinst_rec applinst_cur%ROWTYPE,
789: p_person_id hz_parties.party_id%TYPE,
790: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,
791: p_appl_rec appl_cur%ROWTYPE,
792: p_Status OUT NOCOPY VARCHAR2) IS
793: --------------------------------------------------------------------------