DBA Data[Home] [Help]

APPS.IGS_DA_TRNS_IMP dependencies on IGS_AD_TERM_UNITDTLS

Line 8: unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE,

4:
5: transcript_id igs_ad_transcript.transcript_id%TYPE,
6: education_id igs_ad_transcript.education_id%TYPE,
7: term_details_id igs_ad_term_details.term_details_id%TYPE,
8: unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE,
9:
10: term_type igs_ad_transcript.term_type%TYPE,
11: term igs_ad_term_details.term%TYPE,
12: start_date igs_ad_term_details.start_date%TYPE,

Line 14: unit igs_ad_term_unitdtls.unit%TYPE,

10: term_type igs_ad_transcript.term_type%TYPE,
11: term igs_ad_term_details.term%TYPE,
12: start_date igs_ad_term_details.start_date%TYPE,
13: end_date igs_ad_term_details.end_date%TYPE,
14: unit igs_ad_term_unitdtls.unit%TYPE,
15: person_id hz_education.party_id%TYPE,
16: unit_name igs_ad_term_unitdtls.unit_name%TYPE,
17: cp_attempted igs_ad_term_unitdtls.cp_attempted%TYPE,
18: cp_earned igs_ad_term_unitdtls.cp_earned%TYPE,

Line 16: unit_name igs_ad_term_unitdtls.unit_name%TYPE,

12: start_date igs_ad_term_details.start_date%TYPE,
13: end_date igs_ad_term_details.end_date%TYPE,
14: unit igs_ad_term_unitdtls.unit%TYPE,
15: person_id hz_education.party_id%TYPE,
16: unit_name igs_ad_term_unitdtls.unit_name%TYPE,
17: cp_attempted igs_ad_term_unitdtls.cp_attempted%TYPE,
18: cp_earned igs_ad_term_unitdtls.cp_earned%TYPE,
19: grade igs_ad_term_unitdtls.grade%TYPE,
20: unit_grade_points igs_ad_term_unitdtls.unit_grade_points%TYPE,

Line 17: cp_attempted igs_ad_term_unitdtls.cp_attempted%TYPE,

13: end_date igs_ad_term_details.end_date%TYPE,
14: unit igs_ad_term_unitdtls.unit%TYPE,
15: person_id hz_education.party_id%TYPE,
16: unit_name igs_ad_term_unitdtls.unit_name%TYPE,
17: cp_attempted igs_ad_term_unitdtls.cp_attempted%TYPE,
18: cp_earned igs_ad_term_unitdtls.cp_earned%TYPE,
19: grade igs_ad_term_unitdtls.grade%TYPE,
20: unit_grade_points igs_ad_term_unitdtls.unit_grade_points%TYPE,
21: prev_institution_code igs_ad_acad_history_v.institution_code%TYPE

Line 18: cp_earned igs_ad_term_unitdtls.cp_earned%TYPE,

14: unit igs_ad_term_unitdtls.unit%TYPE,
15: person_id hz_education.party_id%TYPE,
16: unit_name igs_ad_term_unitdtls.unit_name%TYPE,
17: cp_attempted igs_ad_term_unitdtls.cp_attempted%TYPE,
18: cp_earned igs_ad_term_unitdtls.cp_earned%TYPE,
19: grade igs_ad_term_unitdtls.grade%TYPE,
20: unit_grade_points igs_ad_term_unitdtls.unit_grade_points%TYPE,
21: prev_institution_code igs_ad_acad_history_v.institution_code%TYPE
22: );

Line 19: grade igs_ad_term_unitdtls.grade%TYPE,

15: person_id hz_education.party_id%TYPE,
16: unit_name igs_ad_term_unitdtls.unit_name%TYPE,
17: cp_attempted igs_ad_term_unitdtls.cp_attempted%TYPE,
18: cp_earned igs_ad_term_unitdtls.cp_earned%TYPE,
19: grade igs_ad_term_unitdtls.grade%TYPE,
20: unit_grade_points igs_ad_term_unitdtls.unit_grade_points%TYPE,
21: prev_institution_code igs_ad_acad_history_v.institution_code%TYPE
22: );
23:

Line 20: unit_grade_points igs_ad_term_unitdtls.unit_grade_points%TYPE,

16: unit_name igs_ad_term_unitdtls.unit_name%TYPE,
17: cp_attempted igs_ad_term_unitdtls.cp_attempted%TYPE,
18: cp_earned igs_ad_term_unitdtls.cp_earned%TYPE,
19: grade igs_ad_term_unitdtls.grade%TYPE,
20: unit_grade_points igs_ad_term_unitdtls.unit_grade_points%TYPE,
21: prev_institution_code igs_ad_acad_history_v.institution_code%TYPE
22: );
23:
24: -- This function is called to create a new / update an existing academic history record and

Line 38: p_unit_name IN igs_ad_term_unitdtls.unit_name%TYPE,

34: p_start_date IN VARCHAR2,
35: p_end_date IN VARCHAR2,
36: p_source_course_subject IN VARCHAR2,
37: p_source_course_num IN VARCHAR2,
38: p_unit_name IN igs_ad_term_unitdtls.unit_name%TYPE,
39: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
40: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
41: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
42: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,

Line 41: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,

37: p_source_course_num IN VARCHAR2,
38: p_unit_name IN igs_ad_term_unitdtls.unit_name%TYPE,
39: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
40: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
41: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
42: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
43: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
44: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
45: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE

Line 42: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,

38: p_unit_name IN igs_ad_term_unitdtls.unit_name%TYPE,
39: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
40: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
41: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
42: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
43: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
44: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
45: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
46: );

Line 43: p_grade IN igs_ad_term_unitdtls.grade%TYPE,

39: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
40: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
41: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
42: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
43: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
44: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
45: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
46: );
47:

Line 44: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,

40: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
41: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
42: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
43: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
44: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
45: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
46: );
47:
48: -- This function is called to create a new / update an existing advanced standing record

Line 45: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE

41: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
42: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
43: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
44: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
45: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
46: );
47:
48: -- This function is called to create a new / update an existing advanced standing record
49:

Line 52: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,

48: -- This function is called to create a new / update an existing advanced standing record
49:
50: PROCEDURE create_adv_stnd_unit (
51: p_batch_id IN igs_da_rqst.batch_id%TYPE,
52: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
53: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
54: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
55: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
56: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,