APPS.IGS_AS_TRNCMT_LGCY_PUB dependencies on IGS_PE_PERSON

Line 244: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,

240:
241: -------------------------------------------------------------------------------
242: FUNCTION derive_trncmt_data(
243: p_lgcy_trncmt_rec IN OUT NOCOPY lgcy_trncmt_rec_type,
244: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
245: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
246: p_load_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
247: p_uoo_id OUT NOCOPY igs_ps_unit_ofr_opt_all.uoo_id%TYPE
248: )RETURN BOOLEAN

Line 358: p_person_id IN igs_pe_person.person_id%TYPE,

354: END derive_trncmt_data;
355:
356: -------------------------------------------------------------------------------
357: FUNCTION validate_trncmt_db_cons(
358: p_person_id IN igs_pe_person.person_id%TYPE,
359: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
360: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
361: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
362: p_lgcy_trncmt_rec IN lgcy_trncmt_rec_type

Line 389: cp_person_id igs_pe_person.person_id%TYPE,

385: AND spa.person_id = cp_person_id
386: AND pva.course_type = cp_course_type;
387:
388: CURSOR cur_check_career_term(
389: cp_person_id igs_pe_person.person_id%TYPE,
390: cp_course_type igs_ps_ver_all.course_type%TYPE,
391: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
392: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE
393: ) IS

Line 402: cp_person_id igs_pe_person.person_id%TYPE,

398: AND load_cal_type = cp_load_cal_type
399: AND load_ci_sequence_number = cp_load_ci_sequence_number;
400:
401: CURSOR cur_igs_as_su_setatmpt(
402: cp_person_id igs_pe_person.person_id%TYPE,
403: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
404: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE
405: ) IS
406: SELECT 'X'

Line 413: cp_person_id igs_pe_person.person_id%TYPE,

409: AND course_cd = cp_course_cd
410: AND unit_set_cd = cp_unit_set_cd;
411:
412: CURSOR cur_igs_he_en_susa(
413: cp_person_id igs_pe_person.person_id%TYPE,
414: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
415: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE
416: ) IS
417: SELECT 'X'

Line 581: l_person_id igs_pe_person.person_id%TYPE;

577: --Local params
578: l_comment_id igs_as_stu_trn_cmts.comment_id%TYPE;
579: l_load_cal_type igs_ca_inst.cal_type%TYPE;
580: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;
581: l_person_id igs_pe_person.person_id%TYPE;
582: l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
583:
584: l_return_value VARCHAR2(1);
585: WARN_TYPE_ERR EXCEPTION;