APPS.FV_SF1081_TRANSACTION dependencies on FV_SF1081_TEMP

Line 83: from fv_sf1081_temp

79: l_request_id number;
80:
81: CURSOR c_warning_1 IS
82: select distinct trx_number
83: from fv_sf1081_temp
84: where alc_code = '1';
85:
86: CURSOR c_warning_2 IS
87: select distinct trx_number

Line 88: from fv_sf1081_temp

84: where alc_code = '1';
85:
86: CURSOR c_warning_2 IS
87: select distinct trx_number
88: from fv_sf1081_temp
89: where alc_code = '2';
90:
91: CURSOR c_warning_3 IS
92: select distinct customer_name

Line 93: from fv_sf1081_temp

89: where alc_code = '2';
90:
91: CURSOR c_warning_3 IS
92: select distinct customer_name
93: from fv_sf1081_temp
94: where alc_code = '3';
95:
96: BEGIN
97:

Line 251: delete from fv_sf1081_temp where alc_code in ('1','2','3');

247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NO CUSTOMERS HAVE THIS EXCEPTION.');
248: END IF;
249: END IF;
250:
251: delete from fv_sf1081_temp where alc_code in ('1','2','3');
252: END IF;
253:
254: error_code := g_error_code;
255: error_message := 'Normal End of FVSF1081 Package';

Line 380: FROM fv_sf1081_temp;

376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Start a100_clear_report_temp_table');
377: END IF;
378:
379: DELETE
380: FROM fv_sf1081_temp;
381:
382: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
383: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Deleting from FV_SF1081_TEMP');
384: END IF;

Line 383: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Deleting from FV_SF1081_TEMP');

379: DELETE
380: FROM fv_sf1081_temp;
381:
382: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
383: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Deleting from FV_SF1081_TEMP');
384: END IF;
385:
386: EXCEPTION
387: WHEN NO_DATA_FOUND THEN

Line 668: -- This for loop inserts values into FV_SF1081_TEMP table.

664: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_default_alc = N');
665: END IF;
666: END;
667:
668: -- This for loop inserts values into FV_SF1081_TEMP table.
669: v_warning := 'N'; -- set warning condition to No cmb
670:
671: IF parm_alc is not null THEN
672: open ts_report_alc_cursor;

Line 872: INSERT INTO fv_sf1081_temp

868: END;
869:
870:
871: BEGIN
872: INSERT INTO fv_sf1081_temp
873: (customer_trx_id,
874: trx_number,
875: customer_name,
876: cust_address1,