APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_CA_INST_ALL

Line 31: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE, -- Teach calander Type

27: FUNCTION get_anon_id (
28: p_person_id IN hz_parties.party_id%TYPE, -- Person ID
29: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE, -- Course Code
30: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE, -- Unit Code
31: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE, -- Teach calander Type
32: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE, -- Teach Sequence Number
33: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE, -- Unit Ofering Option ID
34: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE, -- Assessment ID
35: p_unit_grading_ind IN VARCHAR2 -- Unit Grading Indicator

Line 32: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE, -- Teach Sequence Number

28: p_person_id IN hz_parties.party_id%TYPE, -- Person ID
29: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE, -- Course Code
30: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE, -- Unit Code
31: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE, -- Teach calander Type
32: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE, -- Teach Sequence Number
33: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE, -- Unit Ofering Option ID
34: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE, -- Assessment ID
35: p_unit_grading_ind IN VARCHAR2 -- Unit Grading Indicator
36: )RETURN VARCHAR2;

Line 41: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE, -- Teach calander Type

37:
38:
39: FUNCTION get_person_id (
40: p_anonymous_id IN igs_as_anon_id_ps.anonymous_id%TYPE, -- Anonymous ID
41: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE, -- Teach calander Type
42: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE -- Teach Sequence Number
43: ) RETURN NUMBER;
44:
45:

Line 42: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE -- Teach Sequence Number

38:
39: FUNCTION get_person_id (
40: p_anonymous_id IN igs_as_anon_id_ps.anonymous_id%TYPE, -- Anonymous ID
41: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE, -- Teach calander Type
42: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE -- Teach Sequence Number
43: ) RETURN NUMBER;
44:
45:
46: FUNCTION user_anon_id (

Line 52: p_teach_cal_type igs_ca_inst_all.cal_type%TYPE,

48: p_method igs_as_anon_method.METHOD%TYPE,
49: p_person_id hz_parties.party_id%TYPE,
50: p_course_cd igs_en_su_attempt_all.course_cd%TYPE,
51: p_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
52: p_teach_cal_type igs_ca_inst_all.cal_type%TYPE,
53: p_teach_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
54: p_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
55: p_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE,
56: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 53: p_teach_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

49: p_person_id hz_parties.party_id%TYPE,
50: p_course_cd igs_en_su_attempt_all.course_cd%TYPE,
51: p_unit_cd igs_en_su_attempt_all.unit_cd%TYPE,
52: p_teach_cal_type igs_ca_inst_all.cal_type%TYPE,
53: p_teach_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
54: p_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
55: p_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE,
56: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
57: p_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE

Line 56: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,

52: p_teach_cal_type igs_ca_inst_all.cal_type%TYPE,
53: p_teach_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
54: p_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
55: p_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE,
56: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
57: p_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE
58: ) RETURN VARCHAR2;
59:
60: END igs_as_anon_grd_pkg;

Line 57: p_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE

53: p_teach_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
54: p_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
55: p_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE,
56: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
57: p_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE
58: ) RETURN VARCHAR2;
59:
60: END igs_as_anon_grd_pkg;