DBA Data[Home] [Help]

APPS.PMI_COST_ANALZ_PACK dependencies on GME_BATCH_HEADER

Line 252: batch_id_vi IN gme_batch_header.batch_id%TYPE,

248: END gmca_inv_perend;
249:
250:
251: FUNCTION gmca_variance(
252: batch_id_vi IN gme_batch_header.batch_id%TYPE,
253: formula_id_vi IN fm_form_mst.formula_id%TYPE,
254: batch_line_id_vi IN gme_material_details.material_detail_id%TYPE,
255: cost_mthd_vi IN cm_cmpt_dtl.cost_mthd_code%TYPE,
256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,

Line 260: batch_status_vi IN gme_batch_header.batch_status%TYPE,

256: plan_qty_vi IN gme_material_details.plan_qty%TYPE,
257: item_um_vi IN gme_material_details.item_um%TYPE,
258: line_type_vi IN gme_material_details.line_type%TYPE,
259: line_no_vi IN gme_material_details.line_no%TYPE,
260: batch_status_vi IN gme_batch_header.batch_status%TYPE,
261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
264: item_id_vi IN gme_material_details.item_id%TYPE,

Line 261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,

257: item_um_vi IN gme_material_details.item_um%TYPE,
258: line_type_vi IN gme_material_details.line_type%TYPE,
259: line_no_vi IN gme_material_details.line_no%TYPE,
260: batch_status_vi IN gme_batch_header.batch_status%TYPE,
261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
264: item_id_vi IN gme_material_details.item_id%TYPE,
265: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,

Line 262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,

258: line_type_vi IN gme_material_details.line_type%TYPE,
259: line_no_vi IN gme_material_details.line_no%TYPE,
260: batch_status_vi IN gme_batch_header.batch_status%TYPE,
261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
264: item_id_vi IN gme_material_details.item_id%TYPE,
265: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,
266: actual_qty_vi IN gme_material_details.actual_qty%TYPE

Line 263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,

259: line_no_vi IN gme_material_details.line_no%TYPE,
260: batch_status_vi IN gme_batch_header.batch_status%TYPE,
261: actual_cmplt_date_vi IN gme_batch_header.actual_cmplt_date%TYPE,
262: batch_close_date_vi IN gme_batch_header.batch_close_date%TYPE,
263: wip_whse_code_vi IN gme_batch_header.wip_whse_code%TYPE,
264: item_id_vi IN gme_material_details.item_id%TYPE,
265: formulaline_id_vi IN gme_material_details.formulaline_id%TYPE,
266: actual_qty_vi IN gme_material_details.actual_qty%TYPE
267: )

Line 285: batch_status_v gme_batch_header.batch_status%TYPE;

281: scaling_error_v NUMBER := 0;
282: variance_v NUMBER := 0;
283:
284: /* batch values for cost formula retrieval */
285: batch_status_v gme_batch_header.batch_status%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:

Line 286: batch_completion_dt_v gme_batch_header.actual_cmplt_date%TYPE;

282: variance_v NUMBER := 0;
283:
284: /* batch values for cost formula retrieval */
285: batch_status_v gme_batch_header.batch_status%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;

Line 287: batch_close_dt_v gme_batch_header.batch_close_date%TYPE;

283:
284: /* batch values for cost formula retrieval */
285: batch_status_v gme_batch_header.batch_status%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;

Line 288: wip_whse_v gme_batch_header.wip_whse_code%TYPE;

284: /* batch values for cost formula retrieval */
285: batch_status_v gme_batch_header.batch_status%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;