212: END;
213:
214: BEGIN
215: DELETE
216: FROM FV_SF1080_DETAIL_TEMP;
217: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_DETAIL_TEMP');
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: NULL;
213:
214: BEGIN
215: DELETE
216: FROM FV_SF1080_DETAIL_TEMP;
217: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_DETAIL_TEMP');
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: NULL;
221: WHEN OTHERS THEN
506: IF LINE_COUNT > 1 AND line_count_flag = 0 THEN
507: ---FV_UTILITY.DEBUG_MESG('Inside the multi line if statement');
508: BEGIN
509: FOR LINE_COUNTER IN 1..LINE_COUNT LOOP
510: INSERT INTO FV_SF1080_DETAIL_TEMP
511: (
512: CUSTOMER_TRX_ID,
513: LINE_NUMBER,
514: EXTENDED_AMOUNT,
537:
538: END;
539: ELSIF LINE_COUNT = 1 AND line_count_flag = 0 THEN
540: ---FV_UTILITY.DEBUG_MESG('Inside the single line if statement');
541: INSERT INTO FV_SF1080_DETAIL_TEMP
542: (
543: CUSTOMER_TRX_ID,
544: LINE_NUMBER,
545: EXTENDED_AMOUNT,