APPS.QP_PTE_UTIL dependencies on QP_LOOKUPS

Line 244: UPDATE QP_LOOKUPS

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

Line 282: INSERT INTO QP_LOOKUPS

278: BEGIN
279:
280: null;
281: /*
282: INSERT INTO QP_LOOKUPS
283: ( DESCRIPTION
284: , ENABLED_FLAG
285: , END_DATE_ACTIVE
286: , LOOKUP_CODE

Line 327: DELETE FROM QP_LOOKUPS

323: IS
324: BEGIN
325: null;
326: /*
327: DELETE FROM QP_LOOKUPS
328: WHERE LOOKUP_CODE = p_lookup_code
329: ;
330: */
331:

Line 371: FROM QP_LOOKUPS

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;

Line 420: FROM QP_LOOKUPS

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.