APPS.PMI_COST_ANALZ_PACK dependencies on IC_CLDR_DTL

Line 223: orgn_code_vi IN ic_cldr_dtl.orgn_code%TYPE,

219: RETURN l_line_type;
220: END;
221:
222: FUNCTION gmca_inv_perend(
223: orgn_code_vi IN ic_cldr_dtl.orgn_code%TYPE,
224: fiscal_year_vi IN ic_cldr_dtl.fiscal_year%TYPE,
225: period_vi IN ic_cldr_dtl.period%TYPE)
226: RETURN DATE
227: IS

Line 224: fiscal_year_vi IN ic_cldr_dtl.fiscal_year%TYPE,

220: END;
221:
222: FUNCTION gmca_inv_perend(
223: orgn_code_vi IN ic_cldr_dtl.orgn_code%TYPE,
224: fiscal_year_vi IN ic_cldr_dtl.fiscal_year%TYPE,
225: period_vi IN ic_cldr_dtl.period%TYPE)
226: RETURN DATE
227: IS
228: period_end_date_v DATE := null;

Line 225: period_vi IN ic_cldr_dtl.period%TYPE)

221:
222: FUNCTION gmca_inv_perend(
223: orgn_code_vi IN ic_cldr_dtl.orgn_code%TYPE,
224: fiscal_year_vi IN ic_cldr_dtl.fiscal_year%TYPE,
225: period_vi IN ic_cldr_dtl.period%TYPE)
226: RETURN DATE
227: IS
228: period_end_date_v DATE := null;
229:

Line 234: ic_cldr_dtl

230: BEGIN
231: IF period_vi >= 1 THEN
232: SELECT (period_end_date + 1 - 1/(24 * 60 * 60)) INTO period_end_date_v
233: FROM
234: ic_cldr_dtl
235: WHERE
236: orgn_code = orgn_code_vi
237: AND fiscal_year = fiscal_year_vi
238: AND period = period_vi;