APPS.IGS_AD_ADM_REQ dependencies on IGS_TR_TYPE

Line 422: l_target_days igs_tr_type.target_days%TYPE;

418: p_message_name OUT NOCOPY VARCHAR2
419: ) RETURN BOOLEAN AS
420:
421: l_message_name VARCHAR2(30);
422: l_target_days igs_tr_type.target_days%TYPE;
423: l_originator_person_id hz_parties.party_id%type;
424:
425: CURSOR trk_comp_dt_cur IS
426: SELECT

Line 459: igs_tr_type tt

455: ar.rowid, ar.tracking_id, itt.tracking_type
456: FROM
457: igs_ad_aplins_admreq ar,
458: igs_tr_item itt,
459: igs_tr_type tt
460: WHERE
461: ar.person_id = p_person_id AND
462: ar.admission_appl_number = p_admission_appl_number AND
463: ar.course_cd = p_program_code AND

Line 497: FROM igs_tr_type ty

493: process_rules_rec process_rules_cur%ROWTYPE;
494:
495: CURSOR process_apc_cur IS
496: SELECT ty.tracking_type
497: FROM igs_tr_type ty
498: WHERE ty.s_tracking_type = p_requirements_type
499: AND ty.closed_ind = 'N'
500: AND EXISTS ( SELECT 'X'
501: FROM igs_ad_appl aa,

Line 518: CURSOR check_duplicate_cur (cp_tracking_type igs_tr_type.tracking_type%TYPE) IS

514:
515:
516: process_apc_rec process_apc_cur%ROWTYPE;
517:
518: CURSOR check_duplicate_cur (cp_tracking_type igs_tr_type.tracking_type%TYPE) IS
519: SELECT ar.tracking_id
520: FROM igs_ad_aplins_admreq ar
521: WHERE ar.person_id = p_person_id
522: AND ar.admission_appl_number = p_admission_appl_number

Line 527: igs_tr_type tt

523: AND ar.course_cd = p_program_code
524: AND ar.sequence_number = p_sequence_number
525: AND EXISTS ( SELECT 'X'
526: FROM igs_tr_item itt,
527: igs_tr_type tt
528: WHERE itt.tracking_id = ar.tracking_id
529: AND itt.tracking_type = tt.tracking_type
530: AND tt.s_tracking_type = p_requirements_type
531: AND tt.tracking_type = cp_tracking_type);