DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_RG_EXC_INV_NOS

Line 1218: FROM JAI_CMN_RG_EXC_INV_NOS

1214:
1215: CURSOR Def_Excise_Invoice_Cur(p_organization_id IN NUMBER, p_location_id IN NUMBER, p_fin_year IN NUMBER,
1216: p_batch_name IN VARCHAR2, p_register_code IN VARCHAR2) IS
1217: SELECT start_number, end_number, jump_by, prefix
1218: FROM JAI_CMN_RG_EXC_INV_NOS
1219: WHERE organization_id = p_organization_id
1220: AND location_id = p_location_id
1221: AND fin_year = p_fin_year
1222: AND transaction_type = 'I'

Line 3362: JAI_CMN_RG_EXC_INV_NOS

3358: IF v_exc_invoice_no IS NOT NULL THEN
3359: IF v_start_number IS NOT NULL THEN
3360: FOR master_org_rec IN ec_code_cur(v_organization_id, v_location_id) LOOP
3361: UPDATE
3362: JAI_CMN_RG_EXC_INV_NOS
3363: SET
3364: start_number = v_start_number,
3365: last_update_date = v_last_update_date,
3366: last_updated_by = v_last_updated_by,