DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_OM_OE_GEN_TAXINV_T

Line 3238: FROM JAI_OM_OE_GEN_TAXINV_T

3234: AND location_id = cp_location_id;
3235:
3236: CURSOR c_excise_invoice_not_done ( cp_Delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)IS
3237: SELECT 1
3238: FROM JAI_OM_OE_GEN_TAXINV_T
3239: WHERE delivery_id = cp_delivery_id;
3240:
3241: ln_excise_invoice_not_done NUMBER;
3242:

Line 3584: || It means the delivery is still existing in the JAI_OM_OE_GEN_TAXINV_T table

3580: END IF; -- ln_excise_invoice_not_done IS NULL
3581:
3582: IF ln_excise_invoice_not_done = 1 THEN
3583: /*
3584: || It means the delivery is still existing in the JAI_OM_OE_GEN_TAXINV_T table
3585: || It means that the excise invoice generation was either not processed or errored out.
3586: || We need to raise an error saying that excise invoice number needs to be run before VAT processing can happen.
3587: */
3588: lv_inv_gen_process_flag := jai_constants.expected_error;

Line 3598: || Control comes here - It means record for the delivery does not exist in the JAI_OM_OE_GEN_TAXINV_T table

3594: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
3595: goto NEXTDELIVERY;
3596: ELSE
3597: /*
3598: || Control comes here - It means record for the delivery does not exist in the JAI_OM_OE_GEN_TAXINV_T table
3599: because of reasons such as :
3600: || a. Delivery does not have excise taxes
3601: || b. Explicit setting such as bond register is set to DOMESTIC_WITHOUT_EXCISE or EXPORT_WITHOUT_EXCISE
3602: || c. The item itself is not excisable , hence no excise invoice num is generated.