APPS.JAI_CMN_RG_OTHERS_PKG SQL Statements

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

Line: 19

                   and not process the insert into JAI_CMN_RG_OTHERS table with zero debit and credit.

2. 08-Jun-2005  Version 116.1 jai_cmn_rg_oth -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
		as required for CASE COMPLAINCE.

3. 14-Jun-2005      rchandan for bug#4428980, Version 116.2
                        Modified the object to remove literals from DML statements and CURSORS.
4.16-apr-2007    Vkaranam For bug#5989740,File version 120.2
                 Forward Porting The changes in 115 bug #5907436
                 Added a new peocedure check_sh_balances.



------------------------------------------------------------------------------------------------------------------------------

***************************************************************************************************/

procedure insert_row (p_source_type         JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE        ,
                      p_source_name         JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE    ,
                      p_source_id           JAI_CMN_RG_OTHERS.SOURCE_REGISTER_ID%TYPE ,
                      p_tax_type            JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE           ,
                      debit_amt             JAI_CMN_RG_OTHERS.DEBIT%TYPE              ,
                      credit_amt            JAI_CMN_RG_OTHERS.CREDIT%TYPE             ,
                      p_process_flag OUT NOCOPY VARCHAR2                              ,
                      p_process_msg OUT NOCOPY VARCHAR2                              ,
                      p_attribute1          VARCHAR2 DEFAULT NULL                 ,
                      p_attribute2          VARCHAR2 DEFAULT NULL                 ,
                      p_attribute3          VARCHAR2 DEFAULT NULL                 ,
                      p_attribute4          VARCHAR2 DEFAULT NULL                 ,
                      p_attribute5          VARCHAR2 DEFAULT NULL
                     ) IS

  CURSOR c_rg_other_id IS
  SELECT JAI_CMN_RG_OTHERS_S.nextval
  FROM   dual;

Line: 87

    Insert into JAI_CMN_RG_OTHERS
    (
    rg_other_id              ,
    source_type              ,
    source_register          ,
    source_register_id       ,
    tax_type                 ,
    credit                   ,
    debit                    ,
    created_by               ,
    creation_date            ,
    last_updated_by          ,
    last_update_date         ,
    last_update_login
    )
    Values
    (
     ln_rg_other_id         ,
     p_source_type          ,
     p_source_name          ,
     p_source_id            ,
     p_tax_type             ,
     credit_amt             ,
     debit_amt              ,
     ln_user_id             ,
     sysdate                ,
     ln_user_id             ,
     sysdate                ,
     fnd_global.login_id
    );

Line: 122

    p_process_msg  := 'Error Occured in jai_cmn_rg_others_pkg.insert_row - ' || substr(sqlerrm,1,900);

Line: 123

END insert_row;

Line: 136

  SELECT org_unit_id
  FROM   JAI_CMN_INVENTORY_ORGS
  WHERE  organization_id = p_organization_id
  AND    location_id     = p_location_id ;

Line: 142

  SELECT NVL(SUM(balance),0)
  FROM   JAI_CMN_RG_OTH_BALANCES
  WHERE  org_unit_id = cp_org_unit_id
  and    register_type = p_register_type
  and    tax_type in ( jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess);  --rchandan for bug#4428980

Line: 212

  SELECT org_unit_id
  FROM   JAI_CMN_INVENTORY_ORGS
  WHERE  organization_id = p_organization_id
  AND    location_id     = p_location_id ;

Line: 219

  SELECT NVL(SUM(balance),0)
  FROM   JAI_CMN_RG_OTH_BALANCES
  WHERE  org_unit_id = cp_org_unit_id
  and    register_type = p_register_type
  and    tax_type in ( jai_constants.tax_type_sh_exc_edu_cess,
		       jai_constants.tax_type_sh_cvd_edu_cess
		     );