41: v_uom_conversion_rate NUMBER;
42: v_debug_info VARCHAR2(100);
43: v_uom_class VARCHAR2(100);
44: v_uom_base VARCHAR2(10);
45: v_uom_profile VARCHAR2(50):=fnd_profile.value('GHG_UOM_CLASS');
46:
47: BEGIN
48:
49: v_debug_info := 'Starting get_conversion Function. ';
397: and a.invoice_id = x_invoice_id;
398:
399: V_TXN_TYPE_LOOKUP_CODE VARCHAR2(200) := 'INT_INVOICE';
400: V_INVOICE_ID NUMBER := X_INVOICE_ID;
401: V_CREATED_BY NUMBER := fnd_profile.value('USER_ID');
402: V_LAST_UPDATE_LOGIN NUMBER := -1;
403: V_MESG VARCHAR2(4000);
404:
405: BEGIN