APPS.JAI_PA_BILLING_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 770: lv_remarks jai_cmn_rg_23ac_ii_trxs.remarks%type;

766: ln_register_id number;
767: lv_register varchar2(30);
768: ld_transaction_date date;
769: lv_rg23_part_ii_reg_type varchar2(1);
770: lv_remarks jai_cmn_rg_23ac_ii_trxs.remarks%type;
771: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;
772: ld_excise_invoice_date date;
773:
774: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;

Line 771: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;

767: lv_register varchar2(30);
768: ld_transaction_date date;
769: lv_rg23_part_ii_reg_type varchar2(1);
770: lv_remarks jai_cmn_rg_23ac_ii_trxs.remarks%type;
771: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;
772: ld_excise_invoice_date date;
773:
774: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;
775: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;

Line 774: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;

770: lv_remarks jai_cmn_rg_23ac_ii_trxs.remarks%type;
771: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;
772: ld_excise_invoice_date date;
773:
774: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;
775: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;
776: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;
777: lv_transaction_type varchar2(30);
778: lv_transaction_source varchar2(30);

Line 775: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;

771: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;
772: ld_excise_invoice_date date;
773:
774: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;
775: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;
776: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;
777: lv_transaction_type varchar2(30);
778: lv_transaction_source varchar2(30);
779: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;

Line 776: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;

772: ld_excise_invoice_date date;
773:
774: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;
775: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;
776: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;
777: lv_transaction_type varchar2(30);
778: lv_transaction_source varchar2(30);
779: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;
780: lv_source_name varchar2(30);

Line 953: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'

949:
950: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;
951:
952: if jai_pa_billing_pkg.gv_debug then
953: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'
954: );
955: end if;
956:
957: jai_cmn_rg_23ac_ii_pkg.insert_row

Line 1347: pn_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%type ,

1343: END process_excise;
1344:
1345:
1346: PROCEDURE check_excise_balance(
1347: pn_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%type ,
1348: pn_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%type ,
1349: pn_basic_excise_amt IN number ,
1350: pn_additional_excise_amt IN number ,
1351: pn_other_excise_amt IN number ,

Line 1348: pn_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%type ,

1344:
1345:
1346: PROCEDURE check_excise_balance(
1347: pn_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%type ,
1348: pn_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%type ,
1349: pn_basic_excise_amt IN number ,
1350: pn_additional_excise_amt IN number ,
1351: pn_other_excise_amt IN number ,
1352: pn_excise_cess_amt IN number ,