95: SELECT
96: INVOICE_NUM
97: INTO L_INVOICE
98: FROM
99: AP_INVOICES_ALL
100: WHERE INVOICE_ID = C_INVOICE_ID
101: AND ROWNUM < 2;
102: EXCEPTION
103: WHEN NO_DATA_FOUND THEN
119: SELECT
120: INVOICE_NUM
121: INTO L_INVOICE
122: FROM
123: AP_INVOICES_ALL
124: WHERE INVOICE_ID = C_INVOICE_ID
125: AND ROWNUM < 2;
126: EXCEPTION
127: WHEN OTHERS THEN