APPS.JAI_CMN_UTILS_PKG dependencies on JAI_CMN_RG_SLNOS

Line 315: INSERT INTO JAI_CMN_RG_SLNOS

311: IS
312: PRAGMA autonomous_transaction;
313: BEGIN
314: --Issue#76. 4627086
315: INSERT INTO JAI_CMN_RG_SLNOS
316: (organization_id, location_id, current_fin_year, register_type, slno, balance,created_by, creation_date, last_updated_by, last_update_date )
317: VALUES
318: (pn_organization_id, pn_location_id, pn_current_fin_year, pv_register_type, 0, 0, fnd_global.user_id , sysdate, fnd_global.user_id , sysdate);
319:

Line 329: UPDATE JAI_CMN_RG_SLNOS

325: END insert_record;
326:
327: BEGIN
328:
329: UPDATE JAI_CMN_RG_SLNOS
330: SET slno = NVL(slno,0) + 1,
331: balance = NVL(balance,0) + pn_txn_amt
332: WHERE register_type = pv_register_type
333: AND organization_id = pn_organization_id

Line 341: UPDATE JAI_CMN_RG_SLNOS

337: IF SQL%NOTFOUND THEN
338:
339: insert_record(pn_organization_id, pn_location_id, pn_fin_year, pv_register_type);
340:
341: UPDATE JAI_CMN_RG_SLNOS
342: SET slno = NVL(slno,0) + 1,
343: balance = NVL(balance,0) + pn_txn_amt
344: WHERE register_type = pv_register_type
345: AND organization_id = pn_organization_id

Line 351: UPDATE JAI_CMN_RG_SLNOS

347: RETURNING slno, balance, current_fin_year INTO ln_slno, ln_closing_balance, ln_fin_year;
348:
349: ELSIF ln_fin_year <> pn_fin_year THEN
350:
351: UPDATE JAI_CMN_RG_SLNOS
352: SET slno = 1,
353: current_fin_year = pn_fin_year
354: WHERE register_type = pv_register_type
355: AND organization_id = pn_organization_id