APPS.IGF_AP_EFC_CALC dependencies on IGF_AP_ISIR_MATCHED

Line 21: g_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;

17:
18: EXCEPTION_IN_REJECTS EXCEPTION ;
19: EXCEPTION_IN_SETUP EXCEPTION ;
20:
21: g_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
22: g_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
23: g_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
24: g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
25:

Line 22: g_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;

18: EXCEPTION_IN_REJECTS EXCEPTION ;
19: EXCEPTION_IN_SETUP EXCEPTION ;
20:
21: g_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
22: g_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
23: g_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
24: g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
25:
26: g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;

Line 23: g_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;

19: EXCEPTION_IN_SETUP EXCEPTION ;
20:
21: g_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
22: g_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
23: g_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
24: g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
25:
26: g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
27: g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;

Line 24: g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;

20:
21: g_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
22: g_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
23: g_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
24: g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
25:
26: g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
27: g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
28: g_s_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;

Line 26: g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;

22: g_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
23: g_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
24: g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
25:
26: g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
27: g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
28: g_s_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
29: g_s_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
30:

Line 27: g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;

23: g_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
24: g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
25:
26: g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
27: g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
28: g_s_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
29: g_s_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
30:
31: isir_rec igf_ap_isir_matched%ROWTYPE ;

Line 28: g_s_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;

24: g_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
25:
26: g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
27: g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
28: g_s_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
29: g_s_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
30:
31: isir_rec igf_ap_isir_matched%ROWTYPE ;
32: p_sys_award_year VARCHAR2(30) ;

Line 29: g_s_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;

25:
26: g_s_efc_a_9 igf_ap_isir_matched_all.paid_efc%TYPE ;
27: g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
28: g_s_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
29: g_s_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
30:
31: isir_rec igf_ap_isir_matched%ROWTYPE ;
32: p_sys_award_year VARCHAR2(30) ;
33:

Line 31: isir_rec igf_ap_isir_matched%ROWTYPE ;

27: g_s_efc_a_10 igf_ap_isir_matched_all.paid_efc%TYPE ;
28: g_s_efc_a_11 igf_ap_isir_matched_all.paid_efc%TYPE ;
29: g_s_efc_a_12 igf_ap_isir_matched_all.paid_efc%TYPE ;
30:
31: isir_rec igf_ap_isir_matched%ROWTYPE ;
32: p_sys_award_year VARCHAR2(30) ;
33:
34:
35: FUNCTION get_efc_no_of_months (p_last_end_dt IN DATE, -- end date of the Last Teaching/Load calendar

Line 51: PROCEDURE calculate_efc (p_isir_rec IN OUT NOCOPY igf_ap_isir_matched%ROWTYPE ,

47: || (reverse chronological order - newest change first)
48: */
49:
50:
51: PROCEDURE calculate_efc (p_isir_rec IN OUT NOCOPY igf_ap_isir_matched%ROWTYPE ,
52: p_ignore_warnings IN VARCHAR2 ,
53: p_sys_batch_yr IN VARCHAR2 ,
54: p_return_status OUT NOCOPY VARCHAR2 ) ;
55: /*