APPS.JAI_PA_BILLING_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 804: lv_remarks jai_cmn_rg_23ac_ii_trxs.remarks%type;

800: ln_register_id number;
801: lv_register varchar2(30);
802: ld_transaction_date date;
803: lv_rg23_part_ii_reg_type varchar2(1);
804: lv_remarks jai_cmn_rg_23ac_ii_trxs.remarks%type;
805: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;
806: ld_excise_invoice_date date;
807:
808: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;

Line 805: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;

801: lv_register varchar2(30);
802: ld_transaction_date date;
803: lv_rg23_part_ii_reg_type varchar2(1);
804: lv_remarks jai_cmn_rg_23ac_ii_trxs.remarks%type;
805: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;
806: ld_excise_invoice_date date;
807:
808: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;
809: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;

Line 808: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;

804: lv_remarks jai_cmn_rg_23ac_ii_trxs.remarks%type;
805: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;
806: ld_excise_invoice_date date;
807:
808: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;
809: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;
810: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;
811: lv_transaction_type varchar2(30);
812: lv_transaction_source varchar2(30);

Line 809: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;

805: lv_excise_inv_no jai_cmn_rg_23ac_ii_trxs.excise_invoice_no%type;
806: ld_excise_invoice_date date;
807:
808: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;
809: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;
810: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;
811: lv_transaction_type varchar2(30);
812: lv_transaction_source varchar2(30);
813: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;

Line 810: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;

806: ld_excise_invoice_date date;
807:
808: ln_customer_id jai_cmn_rg_23ac_ii_trxs.customer_id%type;
809: ln_customer_site_id jai_cmn_rg_23ac_ii_trxs.customer_site_id%type;
810: ln_debit_account_id jai_cmn_rg_23ac_ii_trxs.charge_account_id%type;
811: lv_transaction_type varchar2(30);
812: lv_transaction_source varchar2(30);
813: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;
814: lv_source_name varchar2(30);

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

985:
986: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;
987:
988: if jai_pa_billing_pkg.gv_debug then
989: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'
990: );
991: end if;
992:
993: jai_cmn_rg_23ac_ii_pkg.insert_row

Line 1383: pn_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%type ,

1379: END process_excise;
1380:
1381:
1382: PROCEDURE check_excise_balance(
1383: pn_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%type ,
1384: pn_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%type ,
1385: pn_basic_excise_amt IN number ,
1386: pn_additional_excise_amt IN number ,
1387: pn_other_excise_amt IN number ,

Line 1384: pn_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%type ,

1380:
1381:
1382: PROCEDURE check_excise_balance(
1383: pn_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%type ,
1384: pn_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%type ,
1385: pn_basic_excise_amt IN number ,
1386: pn_additional_excise_amt IN number ,
1387: pn_other_excise_amt IN number ,
1388: pn_excise_cess_amt IN number ,