DBA Data[Home] [Help]

APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_PS_UNIT_OFR_OPT

Line 47: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

43: p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
44: p_message OUT NOCOPY VARCHAR2
45: ) ;
46:
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 ,

Line 50: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,

46:
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

Line 53: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%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: ) ;
56:
57: PROCEDURE wf_inform_stud ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,

Line 69: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

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 ,
70: p_org_id IN NUMBER
71: );
72:
73: PROCEDURE wf_send_mail_adm ( p_person_id_list IN VARCHAR2 ,

Line 74: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

70: p_org_id IN NUMBER
71: );
72:
73: PROCEDURE wf_send_mail_adm ( p_person_id_list IN VARCHAR2 ,
74: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
75: p_org_id IN NUMBER
76: );
77:
78: FUNCTION Enrp_Resequence_Wlst ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

Line 78: FUNCTION Enrp_Resequence_Wlst ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,

74: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
75: p_org_id IN NUMBER
76: );
77:
78: FUNCTION Enrp_Resequence_Wlst ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
79: p_modified_pos_tab IN t_modified_pos_tab
80: ) RETURN BOOLEAN;
81:
82: PROCEDURE check_stud_count ( itemtype IN VARCHAR2,