eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_GR_VERIFY_PROCESS dependencies on IGF_AP_FA_BASE_REC

Line 18: -- | IGF_AP_FA_BASE_RECORD_PKG. |

14: | Modified TBH call to addeded field |
15: | Eligible for Additional Unsubsidized Loans |
16: -- | gvarapra 14-sep-2004 FA138 - ISIR Enhancements |
17: -- | Changed arguments in call to |
18: -- | IGF_AP_FA_BASE_RECORD_PKG. |
19: ***************************************************************/
20:
21: param_error EXCEPTION;
22: g_n_indent NUMBER(10) := 0;

Line 113: igf_ap_fa_base_rec_pkg.update_row

109: ridas 08-FEB-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid
110: tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
111: rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
112: added new parameter award_fmly_contribution_type to
113: igf_ap_fa_base_rec_pkg.update_row
114: ugummall 25-SEP-2003 FA 126 - Multiple FA Offices
115: added new parameter assoc_org_num to
116: igf_ap_fa_base_rec_pkg.update_row call
117: nsidana 4/28/2003 Bug 2806057 : Log file should be more appropriate.

Line 116: igf_ap_fa_base_rec_pkg.update_row call

112: added new parameter award_fmly_contribution_type to
113: igf_ap_fa_base_rec_pkg.update_row
114: ugummall 25-SEP-2003 FA 126 - Multiple FA Offices
115: added new parameter assoc_org_num to
116: igf_ap_fa_base_rec_pkg.update_row call
117: nsidana 4/28/2003 Bug 2806057 : Log file should be more appropriate.
118:
119: ***************************************************************/
120:

Line 126: CURSOR c_fa_base_dtls ( cp_c_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,

122: SELECT group_cd
123: FROM igs_pe_all_persid_group_v
124: WHERE group_id = cp_n_grp_id;
125:
126: CURSOR c_fa_base_dtls ( cp_c_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
127: cp_n_ci_seq_num IN igf_ap_fa_base_rec.ci_sequence_number%TYPE,
128: cp_n_person_id IN igf_ap_fa_base_rec.person_id%TYPE ) IS
129: SELECT *
130: FROM igf_ap_fa_base_rec

Line 127: cp_n_ci_seq_num IN igf_ap_fa_base_rec.ci_sequence_number%TYPE,

123: FROM igs_pe_all_persid_group_v
124: WHERE group_id = cp_n_grp_id;
125:
126: CURSOR c_fa_base_dtls ( cp_c_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
127: cp_n_ci_seq_num IN igf_ap_fa_base_rec.ci_sequence_number%TYPE,
128: cp_n_person_id IN igf_ap_fa_base_rec.person_id%TYPE ) IS
129: SELECT *
130: FROM igf_ap_fa_base_rec
131: WHERE ci_cal_type = cp_c_ci_cal_type

Line 128: cp_n_person_id IN igf_ap_fa_base_rec.person_id%TYPE ) IS

124: WHERE group_id = cp_n_grp_id;
125:
126: CURSOR c_fa_base_dtls ( cp_c_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
127: cp_n_ci_seq_num IN igf_ap_fa_base_rec.ci_sequence_number%TYPE,
128: cp_n_person_id IN igf_ap_fa_base_rec.person_id%TYPE ) IS
129: SELECT *
130: FROM igf_ap_fa_base_rec
131: WHERE ci_cal_type = cp_c_ci_cal_type
132: AND ci_sequence_number = cp_n_ci_seq_num

Line 130: FROM igf_ap_fa_base_rec

126: CURSOR c_fa_base_dtls ( cp_c_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
127: cp_n_ci_seq_num IN igf_ap_fa_base_rec.ci_sequence_number%TYPE,
128: cp_n_person_id IN igf_ap_fa_base_rec.person_id%TYPE ) IS
129: SELECT *
130: FROM igf_ap_fa_base_rec
131: WHERE ci_cal_type = cp_c_ci_cal_type
132: AND ci_sequence_number = cp_n_ci_seq_num
133: AND person_id = cp_n_person_id ;
134:

Line 137: TYPE cpergrptyp IS RECORD ( person_id igf_ap_fa_base_rec_all.person_id%TYPE,

133: AND person_id = cp_n_person_id ;
134:
135: TYPE c_pregrpcurtyp IS REF CURSOR ;
136: cur_per_grp c_pregrpcurtyp;
137: TYPE cpergrptyp IS RECORD ( person_id igf_ap_fa_base_rec_all.person_id%TYPE,
138: person_number igs_pe_person_base_v.person_number%TYPE);
139: per_grp_rec cpergrptyp ;
140:
141: l_c_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;

Line 141: l_c_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;

137: TYPE cpergrptyp IS RECORD ( person_id igf_ap_fa_base_rec_all.person_id%TYPE,
138: person_number igs_pe_person_base_v.person_number%TYPE);
139: per_grp_rec cpergrptyp ;
140:
141: l_c_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
142: l_n_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;
143: l_c_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
144: l_c_sql_stmt VARCHAR2(32767);
145: rec_grp_cd c_group_code%ROWTYPE;

Line 142: l_n_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;

138: person_number igs_pe_person_base_v.person_number%TYPE);
139: per_grp_rec cpergrptyp ;
140:
141: l_c_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
142: l_n_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;
143: l_c_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
144: l_c_sql_stmt VARCHAR2(32767);
145: rec_grp_cd c_group_code%ROWTYPE;
146: rec_fa_base_dtls c_fa_base_dtls%ROWTYPE;

Line 220: igf_ap_fa_base_rec_pkg.update_row ( x_rowid => rec_fa_base_dtls.row_id ,

216: FETCH c_fa_base_dtls INTO rec_fa_base_dtls;
217: IF c_fa_base_dtls%FOUND THEN
218: IF rec_fa_base_dtls.fed_verif_status IS NULL OR
219: rec_fa_base_dtls.fed_verif_status = p_c_from THEN
220: igf_ap_fa_base_rec_pkg.update_row ( x_rowid => rec_fa_base_dtls.row_id ,
221: x_base_id => rec_fa_base_dtls.base_id ,
222: x_ci_cal_type => rec_fa_base_dtls.ci_cal_type ,
223: x_person_id => rec_fa_base_dtls.person_id ,
224: x_ci_sequence_number => rec_fa_base_dtls.ci_sequence_number ,