APPS.IGF_AP_CALC_IM_EFC dependencies on IGF_AP_CSS_PROFILE

Line 137: FROM igf_ap_css_profile prof

133: CURSOR c_all_profiles(
134: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
135: ) IS
136: SELECT prof.*
137: FROM igf_ap_css_profile prof
138: WHERE base_id = cp_base_id;
139:
140: l_profile c_all_profiles%ROWTYPE;
141:

Line 144: cp_cssp_id igf_ap_css_profile_all.cssp_id%TYPE

140: l_profile c_all_profiles%ROWTYPE;
141:
142: -- Get fnar record for a PROFILE
143: CURSOR c_fnar(
144: cp_cssp_id igf_ap_css_profile_all.cssp_id%TYPE
145: ) IS
146: SELECT fnar.*
147: FROM igf_ap_css_fnar fnar
148: WHERE cssp_id = cp_cssp_id;

Line 152: l_efc_duration igf_ap_css_profile_all.coa_duration_num%TYPE;

148: WHERE cssp_id = cp_cssp_id;
149:
150: l_fnar igf_ap_css_fnar%ROWTYPE;
151:
152: l_efc_duration igf_ap_css_profile_all.coa_duration_num%TYPE;
153: l_coa_duration_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE;
154:
155: -- Get sys_award_year based on cal type and sequence number
156: CURSOR c_award_year(

Line 153: l_coa_duration_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE;

149:
150: l_fnar igf_ap_css_fnar%ROWTYPE;
151:
152: l_efc_duration igf_ap_css_profile_all.coa_duration_num%TYPE;
153: l_coa_duration_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE;
154:
155: -- Get sys_award_year based on cal type and sequence number
156: CURSOR c_award_year(
157: cp_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

Line 172: l_cssp_id igf_ap_css_profile_all.cssp_id%TYPE;

168: l_error_msg fnd_new_messages.message_name%TYPE DEFAULT NULL;
169:
170: lv_cssp_rowid ROWID;
171: lv_fnar_rowid ROWID;
172: l_cssp_id igf_ap_css_profile_all.cssp_id%TYPE;
173: l_fnar_id igf_ap_css_fnar_all.fnar_id%TYPE;
174: l_fnar_cssp_id igf_ap_css_fnar_all.cssp_id%TYPE;
175: l_base_id igf_ap_css_profile_all.base_id%TYPE;
176:

Line 175: l_base_id igf_ap_css_profile_all.base_id%TYPE;

171: lv_fnar_rowid ROWID;
172: l_cssp_id igf_ap_css_profile_all.cssp_id%TYPE;
173: l_fnar_id igf_ap_css_fnar_all.fnar_id%TYPE;
174: l_fnar_cssp_id igf_ap_css_fnar_all.cssp_id%TYPE;
175: l_base_id igf_ap_css_profile_all.base_id%TYPE;
176:
177: SKIP_PROFILE_RECORD EXCEPTION;
178:
179: BEGIN

Line 277: igf_ap_css_profile_pkg.update_row(

273: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.calculate_efc.debug','l_coa_duration_efc_amt:'||l_coa_duration_efc_amt);
274: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_calc_im_efc.calculate_efc.debug','l_efc_duration:'||l_efc_duration);
275: END IF;
276: --update coa_duration_efc_amt,coa_duration_num
277: igf_ap_css_profile_pkg.update_row(
278: x_rowid => l_profile.row_id,
279: x_cssp_id => l_profile.cssp_id,
280: x_base_id => l_profile.base_id,
281: x_system_record_type => l_profile.system_record_type,