DBA Data[Home] [Help]

APPS.FV_SF1080_TRANSACTION dependencies on FV_SF1080_DETAIL_TEMP

Line 216: FROM FV_SF1080_DETAIL_TEMP;

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;

Line 217: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_DETAIL_TEMP');

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

Line 510: INSERT INTO FV_SF1080_DETAIL_TEMP

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,

Line 541: INSERT INTO FV_SF1080_DETAIL_TEMP

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,