DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 2171: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;

2167: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
2168: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
2169: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
2170: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
2171: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
2172: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;
2173: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;
2174:
2175: lv_distribution_type VARCHAR2(30); /*bug 7525691*/

Line 2172: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;

2168: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
2169: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
2170: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
2171: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
2172: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;
2173: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;
2174:
2175: lv_distribution_type VARCHAR2(30); /*bug 7525691*/
2176:

Line 2173: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;

2169: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
2170: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
2171: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;
2172: ld_ref_document_date JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE;
2173: lv_vendor_cust_flag JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE;
2174:
2175: lv_distribution_type VARCHAR2(30); /*bug 7525691*/
2176:
2177:

Line 2898: /* jai_cmn_rg_pla_trxs_pkg.insert_row(

2894: FETCH c_pla_account INTO ln_charge_account_id;
2895: CLOSE c_pla_account;
2896: END IF; --v_register_type = 'RG'
2897: --Commented by kunkumar for Bug#6127194
2898: /* jai_cmn_rg_pla_trxs_pkg.insert_row(
2899: p_register_id => ln_register_id,
2900: p_tr6_challan_no => NULL,
2901: p_tr6_challan_date => NULL,
2902: p_cr_basic_ed => p_to_trx_amount,

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

3044: p_customer_site_id IN JAI_CMN_RG_23AC_II_TRXS.customer_site_id%TYPE Default NULL ,
3045: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
3046: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
3047: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
3048: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
3049: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
3050: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
3051: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
3052: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,

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

3045: p_register_id_part_i IN JAI_CMN_RG_23AC_II_TRXS.register_id_part_i%TYPE Default NULL ,
3046: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
3047: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
3048: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
3049: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
3050: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
3051: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
3052: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
3053: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,

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

3046: p_reference_num IN JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE Default NULL ,
3047: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
3048: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
3049: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
3050: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
3051: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
3052: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
3053: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
3054: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,

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

3047: p_rounding_id IN JAI_CMN_RG_23AC_II_TRXS.rounding_id%TYPE Default NULL ,
3048: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
3049: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
3050: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
3051: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
3052: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
3053: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
3054: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
3055: p_process_flag OUT NOCOPY VARCHAR2 ,

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

3048: p_ref_document_id IN JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE Default NULL ,
3049: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
3050: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
3051: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
3052: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
3053: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
3054: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
3055: p_process_flag OUT NOCOPY VARCHAR2 ,
3056: p_process_message OUT NOCOPY VARCHAR2

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

3049: p_ref_document_date IN JAI_CMN_RG_PLA_TRXS.ref_document_date%TYPE Default NULL ,
3050: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
3051: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
3052: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
3053: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
3054: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
3055: p_process_flag OUT NOCOPY VARCHAR2 ,
3056: p_process_message OUT NOCOPY VARCHAR2
3057: )

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

3050: p_dr_invoice_id IN JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE Default NULL ,
3051: p_dr_invoice_date IN JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE Default NULL ,
3052: p_bank_branch_id IN JAI_CMN_RG_PLA_TRXS.bank_branch_id%TYPE Default NULL ,
3053: p_entry_date IN JAI_CMN_RG_PLA_TRXS.entry_date%TYPE Default NULL ,
3054: p_vendor_cust_flag IN JAI_CMN_RG_PLA_TRXS.vendor_cust_flag%TYPE Default NULL ,
3055: p_process_flag OUT NOCOPY VARCHAR2 ,
3056: p_process_message OUT NOCOPY VARCHAR2
3057: )
3058: IS

Line 3137: jai_cmn_rg_pla_trxs_pkg.insert_row(

3133: ELSIF p_register_type = 'PLA' THEN
3134: ln_source_type := 2 ;
3135: lv_source_register := 'PLA' ;
3136:
3137: jai_cmn_rg_pla_trxs_pkg.insert_row(
3138: p_register_id => ln_register_id ,
3139: p_tr6_challan_no => NULL ,
3140: p_tr6_challan_date => NULL ,
3141: p_cr_basic_ed => p_cr_basic_ed ,