APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on FV_FINCHRG_DEBITMEMO_TEMP

Line 493: INSERT INTO fv_finchrg_debitmemo_temp

489: l_module_name VARCHAR2(200);
490: BEGIN
491: l_module_name := g_module_name || 'create_record_temp';
492: IF create_adjust='C' THEN
493: INSERT INTO fv_finchrg_debitmemo_temp
494: (Trx_number,
495: Charge_type ,
496: amount,
497: line_number,

Line 512: INSERT INTO fv_finchrg_debitmemo_temp

508: v_org_id);
509:
510: ELSIF create_adjust='A' THEN
511:
512: INSERT INTO fv_finchrg_debitmemo_temp
513: (trx_number ,
514: charge_type ,
515: amount ,
516: create_adjust_flag ,

Line 1301: DELETE FROM fv_finchrg_debitmemo_temp -- Purge from temp table 2157100

1297: and batch_source_name = var_batch_source_name -- added line
1298: and interface_line_id not in (select interface_line_id
1299: from ra_interface_errors);
1300:
1301: DELETE FROM fv_finchrg_debitmemo_temp -- Purge from temp table 2157100
1302: WHERE set_of_books_id=SOB_ID
1303: AND NVL(org_id,-99)=NVL(v_org_id,-99) ;
1304: exception
1305: when others then

Line 1488: DELETE FROM fv_finchrg_debitmemo_temp -- Purge from temp table

1484: END IF;
1485: CLOSE fv_ar_open_periods;
1486: --
1487:
1488: DELETE FROM fv_finchrg_debitmemo_temp -- Purge from temp table
1489: WHERE set_of_books_id=SOB_ID
1490: AND NVL(org_id,-99)=NVL(v_org_id,-99) ;
1491:
1492: v_interface_record := 'N';