APPS.PMI_COST_ANALZ_PACK dependencies on CM_CLDR_DTL

Line 13: cost_calendar_v cm_cldr_dtl.calendar_code%TYPE := NULL;

9: RETURN NUMBER
10: IS
11: cost_v NUMBER := 0;
12: cost_whse_v cm_whse_asc.cost_whse_code%TYPE := NULL;
13: cost_calendar_v cm_cldr_dtl.calendar_code%TYPE := NULL;
14: cost_period_v cm_cldr_dtl.period_code%TYPE := NULL;
15:
16: CURSOR get_cal_per_cur(
17: cost_whse_v IN cm_whse_asc.cost_whse_code%TYPE,

Line 14: cost_period_v cm_cldr_dtl.period_code%TYPE := NULL;

10: IS
11: cost_v NUMBER := 0;
12: cost_whse_v cm_whse_asc.cost_whse_code%TYPE := NULL;
13: cost_calendar_v cm_cldr_dtl.calendar_code%TYPE := NULL;
14: cost_period_v cm_cldr_dtl.period_code%TYPE := NULL;
15:
16: CURSOR get_cal_per_cur(
17: cost_whse_v IN cm_whse_asc.cost_whse_code%TYPE,
18: cost_mthd_code_v IN cm_cldr_hdr.cost_mthd_code%TYPE,

Line 22: FROM cm_cldr_dtl d,

18: cost_mthd_code_v IN cm_cldr_hdr.cost_mthd_code%TYPE,
19: cost_date_v IN DATE)
20: IS
21: SELECT d.calendar_code, d.period_code
22: FROM cm_cldr_dtl d,
23: cm_cldr_hdr h,
24: sy_orgn_mst o,
25: ic_whse_mst w
26: WHERE

Line 292: cost_calendar_v cm_cldr_dtl.calendar_code%TYPE;

288: wip_whse_v gme_batch_header.wip_whse_code%TYPE;
289:
290: cost_whse_v cm_whse_asc.cost_whse_code%TYPE;
291: cost_date_v DATE := NULL;
292: cost_calendar_v cm_cldr_dtl.calendar_code%TYPE;
293: cost_period_v cm_cldr_dtl.period_code%TYPE;
294: cost_fmeff_id_v fm_form_eff.fmeff_id%TYPE;
295: cost_formula_id_v fm_form_mst.formula_id%TYPE;
296:

Line 293: cost_period_v cm_cldr_dtl.period_code%TYPE;

289:
290: cost_whse_v cm_whse_asc.cost_whse_code%TYPE;
291: cost_date_v DATE := NULL;
292: cost_calendar_v cm_cldr_dtl.calendar_code%TYPE;
293: cost_period_v cm_cldr_dtl.period_code%TYPE;
294: cost_fmeff_id_v fm_form_eff.fmeff_id%TYPE;
295: cost_formula_id_v fm_form_mst.formula_id%TYPE;
296:
297: all_linear BOOLEAN := TRUE;

Line 386: FROM cm_cldr_dtl d,

382: BEGIN
383: /* Determine the appropriate cost calendar/period */
384: SELECT d.calendar_code, d.period_code
385: INTO cost_calendar_v, cost_period_v
386: FROM cm_cldr_dtl d,
387: cm_cldr_hdr h,
388: sy_orgn_mst o,
389: ic_whse_mst w
390: WHERE