DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 1343: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;

1339: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1340: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
1341: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
1342: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
1343: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
1344: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;
1345: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;
1346:
1347:

Line 1344: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;

1340: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
1341: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
1342: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
1343: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
1344: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;
1345: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;
1346:
1347:
1348: ln_sh_cess_amount number;--Added by kunkumar for bug#6127194

Line 1345: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;

1341: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
1342: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
1343: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
1344: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;
1345: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;
1346:
1347:
1348: ln_sh_cess_amount number;--Added by kunkumar for bug#6127194
1349:

Line 1925: /* jai_cmn_rg_pla_trxs_pkg.insert_row(

1921: FETCH c_pla_account INTO ln_charge_account_id;
1922: CLOSE c_pla_account;
1923: END IF; --v_register_type = 'RG'
1924: --Commented by kunkumar for Bug#6127194
1925: /* jai_cmn_rg_pla_trxs_pkg.insert_row(
1926: p_register_id => ln_register_id,
1927: p_tr6_challan_no => NULL,
1928: p_tr6_challan_date => NULL,
1929: p_cr_basic_ed => p_to_trx_amount,

Line 2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,

2071: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
2079: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,

Line 2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,

2072: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
2079: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
2080: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,

Line 2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,

2073: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
2079: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
2080: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
2081: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,

Line 2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,

2074: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
2079: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
2080: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
2081: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
2082: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 2079: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,

2075: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
2079: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
2080: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
2081: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
2082: p_process_flag OUT NOCOPY VARCHAR2 ,
2083: p_process_message OUT NOCOPY VARCHAR2

Line 2080: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,

2076: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
2079: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
2080: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
2081: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
2082: p_process_flag OUT NOCOPY VARCHAR2 ,
2083: p_process_message OUT NOCOPY VARCHAR2
2084: )

Line 2081: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,

2077: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
2078: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
2079: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
2080: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
2081: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
2082: p_process_flag OUT NOCOPY VARCHAR2 ,
2083: p_process_message OUT NOCOPY VARCHAR2
2084: )
2085: IS

Line 2147: jai_cmn_rg_pla_trxs_pkg.insert_row(

2143: ELSIF p_register_type = 'PLA' THEN
2144: ln_source_type := 2 ;
2145: lv_source_register := 'PLA' ;
2146:
2147: jai_cmn_rg_pla_trxs_pkg.insert_row(
2148: p_register_id => ln_register_id ,
2149: p_tr6_challan_no => NULL ,
2150: p_tr6_challan_date => NULL ,
2151: p_cr_basic_ed => p_cr_basic_ed ,