DBA Data[Home] [Help]

APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_CA_INST

Line 51: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,

47: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
48: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
49: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
50: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
51: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
52: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,
53: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,
54: p_message OUT NOCOPY VARCHAR2
55: ) ;

Line 64: p_load_cal_type IN igs_ca_inst.cal_type%TYPE DEFAULT NULL,

60: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
61: p_org_id IN NUMBER,
62: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
63: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
64: p_load_cal_type IN igs_ca_inst.cal_type%TYPE DEFAULT NULL,
65: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE DEFAULT NULL
66: );
67:
68: PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_id%TYPE ,

Line 65: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE DEFAULT NULL

61: p_org_id IN NUMBER,
62: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
63: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
64: p_load_cal_type IN igs_ca_inst.cal_type%TYPE DEFAULT NULL,
65: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE DEFAULT NULL
66: );
67:
68: PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_id%TYPE ,
69: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,