DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_RG_EXC_INV_NOS

Line 1289: FROM JAI_CMN_RG_EXC_INV_NOS

1285:
1286: CURSOR Def_Excise_Invoice_Cur(p_organization_id IN NUMBER, p_location_id IN NUMBER, p_fin_year IN NUMBER,
1287: p_batch_name IN VARCHAR2, p_register_code IN VARCHAR2) IS
1288: SELECT start_number, end_number, jump_by, prefix
1289: FROM JAI_CMN_RG_EXC_INV_NOS
1290: WHERE organization_id = p_organization_id
1291: AND location_id = p_location_id
1292: AND fin_year = p_fin_year
1293: AND transaction_type = 'I'

Line 3623: JAI_CMN_RG_EXC_INV_NOS

3619: IF v_exc_invoice_no IS NOT NULL THEN
3620: IF v_start_number IS NOT NULL THEN
3621: FOR master_org_rec IN ec_code_cur(v_organization_id, v_location_id) LOOP
3622: UPDATE
3623: JAI_CMN_RG_EXC_INV_NOS
3624: SET
3625: start_number = v_start_number,
3626: last_update_date = v_last_update_date,
3627: last_updated_by = v_last_updated_by,