351: RETURN VARCHAR2 IS
352:
353: CURSOR c IS
354: SELECT NVL(shippable_item_flag, 'N')
355: FROM oke_system_items_v
356: WHERE id1 = (
357: SELECT item_id
358: FROM oke_deliverables_b
359: WHERE source_code = 'PA'
400: RETURN VARCHAR2 IS
401:
402: CURSOR c IS
403: SELECT NVL(invoiceable_item_flag, 'N')
404: FROM oke_system_items_v
405: WHERE id1 = (
406: SELECT item_id
407: FROM oke_deliverables_b
408: WHERE source_code = 'PA'
448: RETURN VARCHAR2 IS
449:
450: CURSOR c IS
451: SELECT NVL(purchasing_enabled_flag, 'N')
452: FROM oke_system_items_v
453: WHERE id1 = (
454: SELECT item_id
455: FROM oke_deliverables_b
456: WHERE source_code = 'PA'