DBA Data[Home] [Help]

APPS.INV_DEFAULT_TROLIN dependencies on DUAL

Line 80: FROM DUAL;

76: BEGIN
77:
78: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
79: INTO l_line_id
80: FROM DUAL;
81:
82: /* inv_debug.message(to_char(l_line_id)); */
83:
84: RETURN l_line_id;

Line 620: -- If dual control and secondary quantity is missing, calculate it

616: p_trolin_rec.secondary_uom := NULL;
617: END IF;
618:
619: -- INVCONV BEGIN
620: -- If dual control and secondary quantity is missing, calculate it
621: IF p_trolin_rec.secondary_uom IS NOT NULL AND
622: nvl(p_trolin_rec.secondary_quantity,0) = 0 AND ( l_secondary_default_ind in('F','D') ) THEN
623: l_tmp_secondary_quantity := inv_convert.inv_um_convert(
624: item_id => p_trolin_rec.inventory_item_id