APPS.IGF_AP_ASSUMPTION_REJECT_EDITS dependencies on IGF_AP_ISIR_MATCHED

Line 17: CURSOR get_corr_record ( cp_base_id igf_ap_isir_matched.base_id%TYPE ) IS

13: /* DO NOT DELETE the code commented here
14: It is likely to be pulled in in a forthcoming CCR
15: -- CURSOR to be used for fetching the Correction ISIR for the Student
16: -- ( For edits 2008, 2012, 2025, 2041, 2046, 2060, 2062 )
17: CURSOR get_corr_record ( cp_base_id igf_ap_isir_matched.base_id%TYPE ) IS
18: SELECT *
19: FROM igf_ap_isir_matched isir
20: WHERE isir.base_id = cp_base_id
21: AND isir.system_record_type = 'CORRECTION' ;

Line 19: FROM igf_ap_isir_matched isir

15: -- CURSOR to be used for fetching the Correction ISIR for the Student
16: -- ( For edits 2008, 2012, 2025, 2041, 2046, 2060, 2062 )
17: CURSOR get_corr_record ( cp_base_id igf_ap_isir_matched.base_id%TYPE ) IS
18: SELECT *
19: FROM igf_ap_isir_matched isir
20: WHERE isir.base_id = cp_base_id
21: AND isir.system_record_type = 'CORRECTION' ;
22:
23: corr_rec get_corr_record%ROWTYPE ;

Line 28: p_isir_rec IN OUT NOCOPY igf_ap_isir_matched%ROWTYPE ,

24: */
25:
26:
27: PROCEDURE assume_values (
28: p_isir_rec IN OUT NOCOPY igf_ap_isir_matched%ROWTYPE ,
29: l_sys_batch_yr IN VARCHAR2
30: ) AS
31: /***************************************************************
32: Created By : masehgal

Line 74: l_prior_date igf_ap_isir_matched_all.date_of_birth%TYPE ;

70: -- p_isir_rec.stud_dob_before_date (1)
71: -- p_isir_rec.date_of_birth (2)
72: -- p_isir_rec.a_date_of_birth
73:
74: l_prior_date igf_ap_isir_matched_all.date_of_birth%TYPE ;
75:
76: BEGIN
77: l_prior_date := igf_ap_efc_subf.efc_cutoff_date ( l_sys_batch_yr ) ;
78: -- EDIT 1001

Line 1675: PROCEDURE reject_edits ( p_isir_rec IN OUT NOCOPY igf_ap_isir_matched%ROWTYPE ,

1671: APP_EXCEPTION.RAISE_EXCEPTION;
1672: END assume_values ;
1673:
1674:
1675: PROCEDURE reject_edits ( p_isir_rec IN OUT NOCOPY igf_ap_isir_matched%ROWTYPE ,
1676: p_sys_batch_yr IN VARCHAR2 ,
1677: p_reject_codes OUT NOCOPY VARCHAR2 ) AS
1678: /***************************************************************
1679: Created By : masehgal