eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_FBT_SETTLEMENT_P SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44


PROCEDURE Insert_Fbt_Settlement
( p_fbt_settlement IN jai_fbt_settlement%ROWTYPE
)
IS
lv_procedure_name VARCHAR2(40):='Insert_Fbt_Settlement';

Line: 63


  INSERT INTO jai_fbt_settlement
              ( legal_entity_id
              , period_start_date
              , period_end_date
              , consolidated_amount
              , projected_amount
              , settlement_date
              , inv_supplier_id
              , inv_supplier_site_id
              , inv_ou_id
              , it_challan
              , return_generate_flag
              , creation_date
              , created_by
              , last_update_date
              , last_updated_by
              , last_update_login
              , deposit_date
              , bank_name
              , branch_name
              , settlement_id
              )
  VALUES      ( p_fbt_settlement.legal_entity_id
              , p_fbt_settlement.period_start_date
              , p_fbt_settlement.period_end_date
              , p_fbt_settlement.consolidated_amount
              , p_fbt_settlement.projected_amount
              , p_fbt_settlement.settlement_date
              , p_fbt_settlement.inv_supplier_id
              , p_fbt_settlement.inv_supplier_site_id
              , p_fbt_settlement.inv_ou_id
              , p_fbt_settlement.it_challan
              , p_fbt_settlement.return_generate_flag
              , p_fbt_settlement.creation_date
              , p_fbt_settlement.created_by
              , p_fbt_settlement.last_update_date
              , p_fbt_settlement.last_updated_by
              , p_fbt_settlement.last_update_login
              , p_fbt_settlement.deposit_date
              , p_fbt_settlement.bank_name
              , p_fbt_settlement.branch_name
              , p_fbt_settlement.settlement_id
              );

Line: 124


END Insert_Fbt_Settlement;

Line: 147


PROCEDURE Insert_Interface_Table
( p_inv_interface       IN inv_interface_rec_type
, p_inv_lines_interface IN inv_lines_interface_rec_type
)
IS
lv_procedure_name VARCHAR2(40):='Insert_Interface_Table';

Line: 167


  INSERT INTO ap_invoices_interface
              ( invoice_id
              , invoice_num
              , invoice_date
              , vendor_id
              , vendor_site_id
              , invoice_amount
              , invoice_currency_code
              , accts_pay_code_combination_id
              , source
              , org_id
              , legal_entity_id
              , payment_method_lookup_code
              , created_by
              , creation_date
              , last_updated_by
              , last_update_date
              , last_update_login
              )
  VALUES      ( p_inv_interface.invoice_id
              , p_inv_interface.invoice_num
              , p_inv_interface.invoice_date
              , p_inv_interface.vendor_id
              , p_inv_interface.vendor_site_id
              , p_inv_interface.invoice_amount
              , p_inv_interface.invoice_currency_code
              , p_inv_interface.accts_pay_ccid
              , p_inv_interface.source
              , p_inv_interface.org_id
              , p_inv_interface.legal_entity_id
              , p_inv_interface.payment_method_lookup_code
              , p_inv_interface.created_by
              , p_inv_interface.creation_date
              , p_inv_interface.last_updated_by
              , p_inv_interface.last_update_date
              , p_inv_interface.last_update_login
              );

Line: 206


  INSERT INTO ap_invoice_lines_interface
              ( invoice_id
              , invoice_line_id
              , line_number
              , line_type_lookup_code
              , amount
              , accounting_date
              , description
              , dist_code_combination_id
              , org_id
              , created_by
              , creation_date
              , last_updated_by
              , last_update_date
              , last_update_login
              )
  VALUES      ( p_inv_lines_interface.invoice_id
              , p_inv_lines_interface.invoice_line_id
              , p_inv_lines_interface.line_number
              , p_inv_lines_interface.line_type_lookup_code
              , p_inv_lines_interface.amount
              , p_inv_lines_interface.accounting_date
              , p_inv_lines_interface.description
              , p_inv_lines_interface.dist_code_combination_id
              , p_inv_lines_interface.org_id
              , p_inv_lines_interface.created_by
              , p_inv_lines_interface.creation_date
              , p_inv_lines_interface.last_updated_by
              , p_inv_lines_interface.last_update_date
              , p_inv_lines_interface.last_update_login
              );

Line: 254


END Insert_Interface_Table;

Line: 329


SELECT SUM(fbt_tax_amount) + SUM(fbt_surcharge_amount)
         + SUM(fbt_edu_cess_amount) + SUM(fbt_sh_cess_amount)
FROM jai_fbt_repository
WHERE legal_entity_id = pn_legal_entity_id
  AND period_start_date = ld_start_date
  AND period_end_date = ld_end_date;

Line: 338


SELECT 1
FROM dual
WHERE EXISTS( SELECT 1
              FROM jai_fbt_settlement
              WHERE legal_entity_id = pn_legal_entity_id
              AND period_start_date = ld_start_date
              AND period_end_date = ld_end_date);

Line: 347


SELECT
  pvsa.org_id
, pvsa.accts_pay_code_combination_id
, pvsa.payment_method_lookup_code
FROM po_vendor_sites_all pvsa
WHERE pvsa.vendor_site_id = pn_supplier_site_id;

Line: 355


SELECT
  gsob.currency_code
FROM
  gl_sets_of_books   gsob
, xle_fp_ou_ledger_v xfolv
WHERE gsob.set_of_books_id = xfolv.ledger_id
  AND xfolv.legal_entity_id = pn_legal_entity_id;

Line: 389


    SELECT
      NVL(fc.precision, 2)
    INTO
      ln_precision
    FROM
      gl_sets_of_books gsob
    , fnd_currencies   fc
    WHERE gsob.set_of_books_id = fnd_profile.VALUE('GL_SET_OF_BKS_ID')
      AND gsob.currency_code = fc.currency_code;

Line: 399


    SELECT
      TO_CHAR(ld_start_date,'MM')
    INTO
      lv_jan
    FROM
      dual;

Line: 429


    SELECT jai_fbt_settlement_s.NEXTVAL
    INTO ln_settlement_id
    FROM dual;

Line: 453


    fbt_settlement_rec.last_update_date     := SYSDATE;

Line: 454


    fbt_settlement_rec.last_updated_by      := ln_user_id;

Line: 455


    fbt_settlement_rec.last_update_login    := ln_login_id;

Line: 458


    Insert_Fbt_Settlement(fbt_settlement_rec);

Line: 463


    UPDATE jai_fbt_repository
    SET settlement_id = ln_settlement_id
    WHERE legal_entity_id = pn_legal_entity_id
      AND period_start_date = ld_start_date
      AND period_end_date = ld_end_date;

Line: 472


    SELECT ap_invoices_interface_s.nextval
    INTO ln_invoice_id
    FROM dual;

Line: 478


    SELECT 'FBT/Invoice/'||pn_legal_entity_id||'/'|| TO_CHAR(ld_end_date)  -- Modified by jia for bug#7146038 on 2008/06/04
    INTO ln_invoice_num
    FROM dual;

Line: 509


    inv_interface_rec.last_update_date           := SYSDATE;

Line: 510


    inv_interface_rec.last_updated_by            := ln_user_id;

Line: 511


    inv_interface_rec.last_update_login          := ln_login_id;

Line: 515


    SELECT ap_invoice_lines_interface_s.nextval
    INTO ln_invoice_line_id
    FROM dual;

Line: 530


    inv_lines_interface_rec.last_update_date         := SYSDATE;

Line: 531


    inv_lines_interface_rec.last_updated_by          := ln_user_id;

Line: 532


    inv_lines_interface_rec.last_update_login        := ln_login_id;

Line: 534


    Insert_Interface_Table( inv_interface_rec
                          , inv_lines_interface_rec
                          );