APPS.JAI_CMN_UTILS_PKG dependencies on JAI_CMN_RG_SLNOS

Line 285: INSERT INTO JAI_CMN_RG_SLNOS

281: IS
282: PRAGMA autonomous_transaction;
283: BEGIN
284: --Issue#76. 4627086
285: INSERT INTO JAI_CMN_RG_SLNOS
286: (organization_id, location_id, current_fin_year, register_type, slno, balance,created_by, creation_date, last_updated_by, last_update_date )
287: VALUES
288: (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);
289:

Line 299: UPDATE JAI_CMN_RG_SLNOS

295: END insert_record;
296:
297: BEGIN
298:
299: UPDATE JAI_CMN_RG_SLNOS
300: SET slno = NVL(slno,0) + 1,
301: balance = NVL(balance,0) + pn_txn_amt
302: WHERE register_type = pv_register_type
303: AND organization_id = pn_organization_id

Line 311: UPDATE JAI_CMN_RG_SLNOS

307: IF SQL%NOTFOUND THEN
308:
309: insert_record(pn_organization_id, pn_location_id, pn_fin_year, pv_register_type);
310:
311: UPDATE JAI_CMN_RG_SLNOS
312: SET slno = NVL(slno,0) + 1,
313: balance = NVL(balance,0) + pn_txn_amt
314: WHERE register_type = pv_register_type
315: AND organization_id = pn_organization_id

Line 321: UPDATE JAI_CMN_RG_SLNOS

317: RETURNING slno, balance, current_fin_year INTO ln_slno, ln_closing_balance, ln_fin_year;
318:
319: ELSIF ln_fin_year <> pn_fin_year THEN
320:
321: UPDATE JAI_CMN_RG_SLNOS
322: SET slno = 1,
323: current_fin_year = pn_fin_year
324: WHERE register_type = pv_register_type
325: AND organization_id = pn_organization_id