DBA Data[Home] [Help]

APPS.IGS_AS_GRD_ATT_BE_PKG dependencies on IGS_AS_CHN_GRD_REQ

Line 12: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,

8: PROCEDURE Wf_Inform_Admin_CG
9: ( p_person_id IN VARCHAR2,
10: p_person_number IN hz_parties.party_number%TYPE,
11: p_person_name IN hz_parties.party_name%TYPE,
12: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
13: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
14: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
15: p_title IN igs_ps_unit_ver_all.title%TYPE,
16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,

Line 13: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,

9: ( p_person_id IN VARCHAR2,
10: p_person_number IN hz_parties.party_number%TYPE,
11: p_person_name IN hz_parties.party_name%TYPE,
12: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
13: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
14: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
15: p_title IN igs_ps_unit_ver_all.title%TYPE,
16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,

Line 14: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,

10: p_person_number IN hz_parties.party_number%TYPE,
11: p_person_name IN hz_parties.party_name%TYPE,
12: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
13: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
14: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
15: p_title IN igs_ps_unit_ver_all.title%TYPE,
16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
18: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,

Line 16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,

12: p_course_cd IN igs_as_chn_grd_req.course_cd%TYPE,
13: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
14: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
15: p_title IN igs_ps_unit_ver_all.title%TYPE,
16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
18: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
19: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
20: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,

Line 17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,

13: p_unit_cd IN igs_as_chn_grd_req.unit_cd%TYPE,
14: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
15: p_title IN igs_ps_unit_ver_all.title%TYPE,
16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
18: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
19: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
20: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
21: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,

Line 18: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,

14: p_unit_section IN igs_as_chn_grd_req.unit_class%TYPE,
15: p_title IN igs_ps_unit_ver_all.title%TYPE,
16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
18: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
19: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
20: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
21: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
22: p_requester_name IN VARCHAR2,

Line 19: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,

15: p_title IN igs_ps_unit_ver_all.title%TYPE,
16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
18: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
19: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
20: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
21: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
22: p_requester_name IN VARCHAR2,
23: p_requester_number IN VARCHAR2,

Line 20: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,

16: p_grading_schema IN igs_as_chn_grd_req.current_grading_schema_cd%TYPE,
17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
18: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
19: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
20: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
21: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
22: p_requester_name IN VARCHAR2,
23: p_requester_number IN VARCHAR2,
24: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,

Line 21: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,

17: p_current_mark IN igs_as_chn_grd_req.current_mark%TYPE,
18: p_current_grade IN igs_as_chn_grd_req.current_grade%TYPE,
19: p_change_mark IN igs_as_chn_grd_req.change_mark%TYPE,
20: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
21: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
22: p_requester_name IN VARCHAR2,
23: p_requester_number IN VARCHAR2,
24: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
25: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,

Line 24: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,

20: p_change_grade IN igs_as_chn_grd_req.change_grade%TYPE,
21: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
22: p_requester_name IN VARCHAR2,
23: p_requester_number IN VARCHAR2,
24: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
25: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
26: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
27: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
28: p_start_dt IN DATE,

Line 25: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,

21: p_requester_id IN igs_as_chn_grd_req.requester_id%TYPE,
22: p_requester_name IN VARCHAR2,
23: p_requester_number IN VARCHAR2,
24: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
25: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
26: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
27: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
28: p_start_dt IN DATE,
29: p_end_dt IN DATE,

Line 26: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,

22: p_requester_name IN VARCHAR2,
23: p_requester_number IN VARCHAR2,
24: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
25: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
26: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
27: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
28: p_start_dt IN DATE,
29: p_end_dt IN DATE,
30: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,

Line 27: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,

23: p_requester_number IN VARCHAR2,
24: p_request_date IN igs_as_chn_grd_req.request_date%TYPE,
25: p_requester_comments IN igs_as_chn_grd_req.requester_comments%TYPE,
26: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
27: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
28: p_start_dt IN DATE,
29: p_end_dt IN DATE,
30: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
31: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,

Line 30: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,

26: p_teach_cal_type IN igs_as_chn_grd_req.teach_cal_type%TYPE,
27: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
28: p_start_dt IN DATE,
29: p_end_dt IN DATE,
30: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
31: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,
32: p_grade_ver_num IN igs_as_chn_grd_req.current_gs_version_number%TYPE,
33: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
34: p_grading_period_cd IN igs_as_su_stmptout.grading_period_cd%TYPE

Line 31: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,

27: p_teach_ci_seq_num IN igs_as_chn_grd_req.teach_ci_sequence_number%TYPE,
28: p_start_dt IN DATE,
29: p_end_dt IN DATE,
30: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
31: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,
32: p_grade_ver_num IN igs_as_chn_grd_req.current_gs_version_number%TYPE,
33: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
34: p_grading_period_cd IN igs_as_su_stmptout.grading_period_cd%TYPE
35: )

Line 32: p_grade_ver_num IN igs_as_chn_grd_req.current_gs_version_number%TYPE,

28: p_start_dt IN DATE,
29: p_end_dt IN DATE,
30: p_load_cal_type IN igs_as_chn_grd_req.load_cal_type%TYPE,
31: p_load_seq_num IN igs_as_chn_grd_req.load_ci_sequence_number%TYPE,
32: p_grade_ver_num IN igs_as_chn_grd_req.current_gs_version_number%TYPE,
33: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
34: p_grading_period_cd IN igs_as_su_stmptout.grading_period_cd%TYPE
35: )
36: IS