APPS.PMI_COST_ANALZ_PACK dependencies on CM_WHSE_ASC

Line 12: cost_whse_v cm_whse_asc.cost_whse_code%TYPE := NULL;

8: cost_date_vi IN DATE)
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(

Line 17: cost_whse_v IN cm_whse_asc.cost_whse_code%TYPE,

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,
19: cost_date_v IN DATE)
20: IS
21: SELECT d.calendar_code, d.period_code

Line 290: cost_whse_v cm_whse_asc.cost_whse_code%TYPE;

286: batch_completion_dt_v gme_batch_header.actual_cmplt_date%TYPE;
287: batch_close_dt_v gme_batch_header.batch_close_date%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;

Line 927: inv_whse_vi IN cm_whse_asc.whse_code%TYPE,

923:
924: END gmca_uomcv ; -- End of Function
925:
926: FUNCTION gmca_cost_whse(
927: inv_whse_vi IN cm_whse_asc.whse_code%TYPE,
928: asc_date_vi IN DATE)
929: RETURN VARCHAR
930: IS
931: cost_whse_v cm_whse_asc.cost_whse_code%TYPE := NULL;

Line 931: cost_whse_v cm_whse_asc.cost_whse_code%TYPE := NULL;

927: inv_whse_vi IN cm_whse_asc.whse_code%TYPE,
928: asc_date_vi IN DATE)
929: RETURN VARCHAR
930: IS
931: cost_whse_v cm_whse_asc.cost_whse_code%TYPE := NULL;
932: CURSOR cost_whse_cur(
933: inv_whse_v cm_whse_asc.whse_code%TYPE,
934: asc_date_v DATE)
935: IS

Line 933: inv_whse_v cm_whse_asc.whse_code%TYPE,

929: RETURN VARCHAR
930: IS
931: cost_whse_v cm_whse_asc.cost_whse_code%TYPE := NULL;
932: CURSOR cost_whse_cur(
933: inv_whse_v cm_whse_asc.whse_code%TYPE,
934: asc_date_v DATE)
935: IS
936: SELECT cost_whse_code
937: FROM cm_whse_asc

Line 937: FROM cm_whse_asc

933: inv_whse_v cm_whse_asc.whse_code%TYPE,
934: asc_date_v DATE)
935: IS
936: SELECT cost_whse_code
937: FROM cm_whse_asc
938: WHERE whse_code = inv_whse_v
939: AND eff_start_date <= asc_date_v
940: AND eff_end_date >= asc_date_v
941: AND delete_mark = 0;