APPS.IGI_CIS_IGIPMTHP_PKG dependencies on AP_OTHER_PERIODS

Line 123: l_period_type ap_other_periods.period_type%TYPE;

119: RETURN(p_report_lev);
120: END get_p_rep_mode;
121:
122: FUNCTION get_period_start_date RETURN VARCHAR2 IS
123: l_period_type ap_other_periods.period_type%TYPE;
124: l_start_date ap_other_periods.start_date%TYPE;
125: BEGIN
126: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
127:

Line 124: l_start_date ap_other_periods.start_date%TYPE;

120: END get_p_rep_mode;
121:
122: FUNCTION get_period_start_date RETURN VARCHAR2 IS
123: l_period_type ap_other_periods.period_type%TYPE;
124: l_start_date ap_other_periods.start_date%TYPE;
125: BEGIN
126: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
127:
128: SELECT start_date

Line 130: FROM ap_other_periods

126: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
127:
128: SELECT start_date
129: INTO l_start_date
130: FROM ap_other_periods
131: WHERE period_type = l_period_type
132: AND period_name = p_period;
133:
134: RETURN(l_start_date);

Line 142: l_period_type ap_other_periods.period_type%TYPE;

138: END get_period_start_date;
139:
140:
141: FUNCTION get_period_end_date RETURN VARCHAR2 IS
142: l_period_type ap_other_periods.period_type%TYPE;
143: l_end_date ap_other_periods.start_date%TYPE;
144: BEGIN
145: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
146:

Line 143: l_end_date ap_other_periods.start_date%TYPE;

139:
140:
141: FUNCTION get_period_end_date RETURN VARCHAR2 IS
142: l_period_type ap_other_periods.period_type%TYPE;
143: l_end_date ap_other_periods.start_date%TYPE;
144: BEGIN
145: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
146:
147: SELECT end_date

Line 149: FROM ap_other_periods

145: l_period_type := fnd_profile.value('IGI_CIS2007_CALENDAR');
146:
147: SELECT end_date
148: INTO l_end_date
149: FROM ap_other_periods
150: WHERE period_type = l_period_type
151: AND period_name = p_period;
152:
153: RETURN (l_end_date);