eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_INT_RECONSIDER dependencies on HZ_PARTIES

Line 6: p_person_id HZ_PARTIES.party_id%TYPE,

2: /* $Header: IGSADD6B.pls 120.3 2006/05/26 07:17:44 pfotedar noship $ */
3:
4: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
5: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
6: p_person_id HZ_PARTIES.party_id%TYPE,
7: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
8: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
9: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,
10: p_start_dt DATE)

Line 419: FUNCTION copy_application_child_records (p_person_id HZ_PARTIES.party_id%TYPE,

415:
416: END copy_candidacy_records;
417:
418:
419: FUNCTION copy_application_child_records (p_person_id HZ_PARTIES.party_id%TYPE,
420: p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
421: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
422: p_nominated_course_cd IGS_AD_PS_APPL_INST_ALL.nominated_course_cd%TYPE,
423: p_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE)

Line 428: CURSOR c_othinst_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

424: RETURN BOOLEAN IS
425:
426: -- other institutitons
427:
428: CURSOR c_othinst_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
429: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
430: IS
431: SELECT
432: other_inst_id,

Line 447: CURSOR c_perstat_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

443: admission_appl_number = cp_admission_appl_number;
444:
445:
446: -- personal statements
447: CURSOR c_perstat_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
448: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
449: IS
450: SELECT
451: appl_perstat_id,

Line 464: CURSOR c_acadint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

460: admission_appl_number = cp_admission_appl_number;
461:
462:
463: -- academic interests
464: CURSOR c_acadint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
465: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
466: IS
467: SELECT
468: acad_interest_id ,

Line 479: CURSOR c_appint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

475: person_id = cp_person_id and
476: admission_appl_number = cp_admission_appl_number;
477:
478: --applicant intent
479: CURSOR c_appint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
480: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
481: IS
482: SELECT
483: app_intent_id,

Line 516: CURSOR c_splint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

512: admission_appl_number = cp_admission_appl_number;
513:
514:
515: -- Special Interests
516: CURSOR c_splint_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
517: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
518: IS
519: SELECT
520: spl_interest_id ,

Line 531: CURSOR c_spltal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

527: person_id = cp_person_id and
528: admission_appl_number = cp_admission_appl_number;
529:
530: --spl talents
531: CURSOR c_spltal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
532: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
533: IS
534: SELECT
535: spl_talent_id ,

Line 546: CURSOR c_fee_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

542: person_id = cp_person_id and
543: admission_appl_number = cp_admission_appl_number;
544:
545: -- Fees
546: CURSOR c_fee_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
547: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE
548: )IS
549: SELECT
550: app_req_id ,

Line 756: p_person_id HZ_PARTIES.party_id%TYPE,

752: END copy_application_child_records;
753:
754: FUNCTION copy_instance_child_records (p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
755: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_person_id HZ_PARTIES.party_id%TYPE,
757: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
758: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
759: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
760: p_start_dt DATE)

Line 776: CURSOR c_unitsets_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

772: Who When What
773: *******************************************************************************/
774: -------------------------Cursor Declarations-------------------------------------------------------------------
775: -- Unitsets
776: CURSOR c_unitsets_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
777: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
778: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
779: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
780: IS

Line 801: CURSOR c_edugoal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

797:
798:
799:
800: -- education goals
801: CURSOR c_edugoal_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
802: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
803: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
804: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
805: IS

Line 830: CURSOR c_splcns_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

826: -- So cursor to select the values from the old applicaiton has been removed
827:
828:
829: -- special consideration
830: CURSOR c_splcns_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
831: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
832: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
833: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
834: IS

Line 852: CURSOR c_tracking_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

848: admission_appl_number = cp_admission_appl_number;
849:
850:
851: -- Trackings
852: CURSOR c_tracking_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
853: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
854: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
855: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
856: IS

Line 873: CURSOR c_pgmapp_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

869: sequence_number = cp_sequence_number and
870: admission_appl_number = cp_admission_appl_number;
871:
872: -- program approval
873: CURSOR c_pgmapp_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
874: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
875: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
876: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
877: IS

Line 899: CURSOR c_test_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

895: sequence_number = cp_sequence_number and
896: admission_appl_number = cp_admission_appl_number;
897:
898: -- Test Scores
899: CURSOR c_test_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
900: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
901: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
902: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
903: IS

Line 942: CURSOR c_notes_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

938: admission_appl_number = cp_admission_appl_number;
939:
940:
941: -- notes
942: CURSOR c_notes_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
943: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
944: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
945: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
946: IS

Line 963: CURSOR c_evaluators_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

959: nominated_course_cd = cp_nominated_course_cd and
960: sequence_number = cp_sequence_number and
961: admission_appl_number = cp_admission_appl_number;
962:
963: CURSOR c_evaluators_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
964: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
965: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
966: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
967:

Line 994: CURSOR c_applrep_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

990: sequence_number = cp_sequence_number and
991: admission_appl_number = cp_admission_appl_number;
992:
993:
994: CURSOR c_applrep_cur(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
995: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
996: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
997: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE )
998:

Line 1030: CURSOR c_appl_qual_code(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,

1026: AND lkup.lookup_type = 'SYS_FEE_STATUS'
1027: AND ccl.system_status = 'WAIVED'
1028: AND ccl.system_default = 'Y';
1029:
1030: CURSOR c_appl_qual_code(cp_person_id HZ_PARTIES.PARTY_ID%TYPE,
1031: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1032: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1033: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) IS
1034: SELECT qual.*