DBA Data[Home] [Help]

APPS.GME_FPL_PVT dependencies on SY_UOMS_MST

Line 22: ,x_fixed_process_loss_uom OUT NOCOPY sy_uoms_mst.uom_code%TYPE

18: p_batch_id IN NUMBER DEFAULT NULL
19: ,p_validity_rule_id IN NUMBER
20: ,p_organization_id IN NUMBER DEFAULT NULL
21: ,x_fixed_process_loss OUT NOCOPY NUMBER
22: ,x_fixed_process_loss_uom OUT NOCOPY sy_uoms_mst.uom_code%TYPE
23: )
24: IS
25:
26: l_api_name VARCHAR2 (30) := 'GET_FIXED_PROCESS_LOSS';

Line 223: l_fixed_process_loss_uom sy_uoms_mst.uom_code%TYPE;

219: )
220: IS
221: l_api_name VARCHAR2(30) := 'APPLY_FIXED_PROCESS_LOSS';
222: l_fixed_process_loss NUMBER;
223: l_fixed_process_loss_uom sy_uoms_mst.uom_code%TYPE;
224: l_item_uom sy_uoms_mst.uom_code%TYPE;
225: l_new_fpl NUMBER;
226: l_convert_dtl_uom NUMBER := 0;
227: l_convert_fpl_uom NUMBER := 0;

Line 224: l_item_uom sy_uoms_mst.uom_code%TYPE;

220: IS
221: l_api_name VARCHAR2(30) := 'APPLY_FIXED_PROCESS_LOSS';
222: l_fixed_process_loss NUMBER;
223: l_fixed_process_loss_uom sy_uoms_mst.uom_code%TYPE;
224: l_item_uom sy_uoms_mst.uom_code%TYPE;
225: l_new_fpl NUMBER;
226: l_convert_dtl_uom NUMBER := 0;
227: l_convert_fpl_uom NUMBER := 0;
228: l_new_dtl_qty NUMBER;

Line 237: l_from_uom sy_uoms_mst.uom_code%TYPE;

233: l_original_primary_qty NUMBER;
234: l_plan_qty NUMBER;
235: l_item_no VARCHAR2 (2000);
236: l_item_id NUMBER;
237: l_from_uom sy_uoms_mst.uom_code%TYPE;
238: l_to_uom sy_uoms_mst.uom_code%TYPE;
239: l_error_msg varchar2(4000);
240:
241: conversion_failure EXCEPTION;

Line 238: l_to_uom sy_uoms_mst.uom_code%TYPE;

234: l_plan_qty NUMBER;
235: l_item_no VARCHAR2 (2000);
236: l_item_id NUMBER;
237: l_from_uom sy_uoms_mst.uom_code%TYPE;
238: l_to_uom sy_uoms_mst.uom_code%TYPE;
239: l_error_msg varchar2(4000);
240:
241: conversion_failure EXCEPTION;
242: --Bug 6908375