APPS.IGI_CIS_IGIPMTHP_PKG dependencies on AP_OTHER_PERIODS

Line 187: l_period_type ap_other_periods.period_type%TYPE;

183: END get_p_rep_mode;
184:
185: FUNCTION get_period_start_date RETURN VARCHAR2 IS
186: l_procedure_name VARCHAR2(100):='.get_period_start_date';
187: l_period_type ap_other_periods.period_type%TYPE;
188: l_start_date ap_other_periods.start_date%TYPE;
189: BEGIN
190: l_procedure_name := g_path_name || l_procedure_name;
191: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');

Line 188: l_start_date ap_other_periods.start_date%TYPE;

184:
185: FUNCTION get_period_start_date RETURN VARCHAR2 IS
186: l_procedure_name VARCHAR2(100):='.get_period_start_date';
187: l_period_type ap_other_periods.period_type%TYPE;
188: l_start_date ap_other_periods.start_date%TYPE;
189: BEGIN
190: l_procedure_name := g_path_name || l_procedure_name;
191: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
192: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');

Line 196: FROM ap_other_periods

192: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
193:
194: SELECT start_date
195: INTO l_start_date
196: FROM ap_other_periods
197: WHERE period_type = l_period_type
198: AND period_name = p_period;
199:
200: log(C_STATE_LEVEL, l_procedure_name, 'END');

Line 211: l_period_type ap_other_periods.period_type%TYPE;

207:
208:
209: FUNCTION get_period_end_date RETURN VARCHAR2 IS
210: l_procedure_name VARCHAR2(100):='.get_period_end_date';
211: l_period_type ap_other_periods.period_type%TYPE;
212: l_end_date ap_other_periods.start_date%TYPE;
213: BEGIN
214: l_procedure_name := g_path_name || l_procedure_name;
215: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');

Line 212: l_end_date ap_other_periods.start_date%TYPE;

208:
209: FUNCTION get_period_end_date RETURN VARCHAR2 IS
210: l_procedure_name VARCHAR2(100):='.get_period_end_date';
211: l_period_type ap_other_periods.period_type%TYPE;
212: l_end_date ap_other_periods.start_date%TYPE;
213: BEGIN
214: l_procedure_name := g_path_name || l_procedure_name;
215: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
216: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');

Line 220: FROM ap_other_periods

216: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
217:
218: SELECT end_date
219: INTO l_end_date
220: FROM ap_other_periods
221: WHERE period_type = l_period_type
222: AND period_name = p_period;
223:
224: log(C_STATE_LEVEL, l_procedure_name, 'END');