DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_CMN_RG_EXC_INV_NOS

Line 3235: FROM JAI_CMN_RG_EXC_INV_NOS

3231:
3232: CURSOR Def_Excise_Invoice_Cur(p_organization_id IN NUMBER, p_location_id IN NUMBER, p_fin_year IN NUMBER,
3233: p_batch_name IN VARCHAR2, p_register_code IN VARCHAR2) IS
3234: SELECT start_number, end_number, jump_by, prefix
3235: FROM JAI_CMN_RG_EXC_INV_NOS
3236: WHERE organization_id = p_organization_id
3237: AND location_id = p_location_id
3238: AND fin_year = p_fin_year
3239: AND transaction_type = 'I'

Line 4086: JAI_CMN_RG_EXC_INV_NOS

4082: IF v_exc_invoice_no IS NOT NULL THEN
4083: IF v_start_number IS NOT NULL THEN
4084: FOR master_org_rec IN ec_code_cur(v_organization_id, v_location_id) LOOP
4085: UPDATE
4086: JAI_CMN_RG_EXC_INV_NOS
4087: SET
4088: start_number = v_start_number,
4089: last_update_date = v_last_update_date,
4090: last_updated_by = v_last_updated_by,