240: BEGIN
241:
242: null;
243: /*
244: UPDATE QP_LOOKUPS
245: SET DESCRIPTION = p_PTE_rec.description
246: , ENABLED_FLAG = p_PTE_rec.enabled_flag
247: , END_DATE_ACTIVE = p_PTE_rec.end_date_active
248: , LOOKUP_CODE = p_PTE_rec.lookup_code
278: BEGIN
279:
280: null;
281: /*
282: INSERT INTO QP_LOOKUPS
283: ( DESCRIPTION
284: , ENABLED_FLAG
285: , END_DATE_ACTIVE
286: , LOOKUP_CODE
323: IS
324: BEGIN
325: null;
326: /*
327: DELETE FROM QP_LOOKUPS
328: WHERE LOOKUP_CODE = p_lookup_code
329: ;
330: */
331:
367: , l_PTE_rec.lookup_code
368: , l_PTE_rec.lookup_type
369: , l_PTE_rec.meaning
370: , l_PTE_rec.start_date_active
371: FROM QP_LOOKUPS
372: WHERE LOOKUP_CODE = p_lookup_code
373: ;
374:
375: RETURN l_PTE_rec;
416: , l_PTE_rec.lookup_code
417: , l_PTE_rec.lookup_type
418: , l_PTE_rec.meaning
419: , l_PTE_rec.start_date_active
420: FROM QP_LOOKUPS
421: WHERE LOOKUP_CODE = p_PTE_rec.lookup_code
422: FOR UPDATE NOWAIT;
423:
424: -- Row locked. Compare IN attributes to DB attributes.