APPS.IBE_DSPMGRVALIDATION_GRP dependencies on IBE_DSP_TPL_CTG

Line 452: -- deliverable id/ category id in IBE_DSP_TPL_CTG

448:
449: -----------------------------------------------------------------
450: -- NOTES
451: -- 1. Returns false if there is no association for a
452: -- deliverable id/ category id in IBE_DSP_TPL_CTG
453: -- 2. No message is pushed on the stack
454: ---------------------------------------------------------------------
455: FUNCTION check_ctg_tpl_relation_exists(p_category_id IN NUMBER,
456: p_template_id IN NUMBER)

Line 464: from ibe_dsp_tpl_ctg

460:
461: CURSOR ctg_tpl_relation_cur( p_category_id IN NUMBER,p_template_id IN NUMBER ) IS
462: -- select tpl_ctg_id
463: select 1
464: from ibe_dsp_tpl_ctg
465: where category_id = p_category_id and item_id = p_template_id;
466:
467: l_exists NUMBER;
468: l_return_status boolean := false;

Line 1352: from IBE_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where

1348: CURSOR item_dlv_cur(p_item_id in NUMBER,
1349: p_deliverable_id IN NUMBER ) IS
1350: -- SELECT A.ITEM_ID
1351: SELECT 1
1352: from IBE_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where
1353: B.INVENTORY_ITEM_ID = p_item_id and
1354: B.CATEGORY_ID = A.CATEGORY_ID AND
1355: A.ITEM_ID= p_deliverable_id ;
1356:

Line 1413: from IBE_DSP_TPL_CTG where category_id = p_category_id and

1409: CURSOR category_dlv_cur(p_category_id in NUMBER,
1410: p_deliverable_id IN NUMBER ) IS
1411: -- SELECT ITEM_ID
1412: SELECT 1
1413: from IBE_DSP_TPL_CTG where category_id = p_category_id and
1414: ITEM_ID= p_deliverable_id ;
1415:
1416: l_return_status boolean := false;
1417: l_exists NUMBER := 0;