APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_CMN_RG_BALANCES

Line 589: jai_cmn_rg_balances_pkg.get_balance(

585:
586: fnd_file.put_line(FND_FILE.LOG, ' Trx amt ' || ln_tr_amount);
587:
588: /* Get the balance details */
589: jai_cmn_rg_balances_pkg.get_balance(
590: P_ORGANIZATION_ID => pr_tax.organization_id,
591: P_LOCATION_ID => pr_tax.location_id,
592: P_REGISTER_TYPE => 'PLA',
593: P_OPENING_BALANCE => ln_opening_balance,

Line 629: jai_cmn_rg_balances_pkg.update_row(

625: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath);
626: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
627: /* Update the balances with the latest amount*/
628:
629: jai_cmn_rg_balances_pkg.update_row(
630: p_organization_id => pr_tax.organization_id,
631: p_location_id => pr_tax.location_id,
632: p_register_type => 'PLA',
633: p_amount_to_be_added=> ln_tr_amount,

Line 743: jai_cmn_rg_balances_pkg.get_balance(

739: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);
740: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
741:
742: /* Get the balance details */
743: jai_cmn_rg_balances_pkg.get_balance(
744: P_ORGANIZATION_ID => pr_tax.organization_id,
745: P_LOCATION_ID => pr_tax.location_id,
746: P_REGISTER_TYPE => lv_register_type,
747: P_OPENING_BALANCE => ln_opening_balance,

Line 785: jai_cmn_rg_balances_pkg.update_row(

781: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath);
782: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
783: /* Update the balances with the latest amount*/
784:
785: jai_cmn_rg_balances_pkg.update_row(
786: p_organization_id => pr_tax.organization_id,
787: p_location_id => pr_tax.location_id,
788: p_register_type => lv_register_type,
789: p_amount_to_be_added=> ln_tr_amount,

Line 6152: FROM JAI_CMN_RG_BALANCES

6148: jai_constants.register_type_pla, pla_balance,
6149: jai_constants.register_type_a, rg23a_balance,
6150: jai_constants.register_type_c, rg23c_balance
6151: )
6152: FROM JAI_CMN_RG_BALANCES
6153: WHERE organization_id = cp_organization_id
6154: AND location_id = cp_location_id;
6155:
6156: ln_current_balance NUMBER;