DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on CHV_CUM_PERIOD_ITEMS

Line 139: -- x_asl_uom chv_cum_period_items.purchasing_unit_of_measure%type := null;

135: x_progress VARCHAR2(3);
136: x_new_conversion NUMBER := 0;
137: x_cum_enabled chv_org_options.enable_cum_flag%TYPE := NULL;
138: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := NULL;
139: -- x_asl_uom chv_cum_period_items.purchasing_unit_of_measure%type := null;
140: x_asl_uom VARCHAR2(80) := NULL;
141: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;
142: x_error_status VARCHAR2(1);
143: BEGIN

Line 244: FROM chv_cum_period_items

240: IF ( x_cum_enabled = 'Y'
241: AND x_supply_agreement_flag = 'Y') THEN
242: SELECT NVL(MAX(NULL), 'notfound') -- purchasing_unit_of_measure doesn't exist!!
243: INTO x_asl_uom
244: FROM chv_cum_period_items
245: WHERE organization_id = NVL(x_uom_record.to_organization_id, organization_id);
246:
247: IF (x_asl_uom <> 'notfound') THEN
248: x_new_conversion := 0;