APPS.JTF_DSPMGRVALIDATION_GRP dependencies on JTF_DSP_TPL_CTG

Line 445: -- deliverable id/ category id in JTF_DSP_TPL_CTG

441:
442: -----------------------------------------------------------------
443: -- NOTES
444: -- 1. Returns false if there is no association for a
445: -- deliverable id/ category id in JTF_DSP_TPL_CTG
446: -- 2. No message is pushed on the stack
447: ---------------------------------------------------------------------
448: FUNCTION check_ctg_tpl_relation_exists(p_category_id IN NUMBER,
449: p_template_id IN NUMBER)

Line 455: SELECT 1 from dual where exists (select tpl_ctg_id from jtf_dsp_tpl_ctg where

451: IS
452: l_api_name CONSTANT VARCHAR2(40) := 'check_ctg_tpl_relation_exists';
453:
454: CURSOR ctg_tpl_relation_cur( p_category_id IN NUMBER,p_template_id IN NUMBER ) IS
455: SELECT 1 from dual where exists (select tpl_ctg_id from jtf_dsp_tpl_ctg where
456: category_id = p_category_id and item_id = p_template_id);
457: l_exists NUMBER;
458: l_return_status boolean := false;
459:

Line 1319: (SELECT A.ITEM_ID from JTF_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where

1315:
1316: CURSOR item_dlv_cur(p_item_id in NUMBER,
1317: p_deliverable_id IN NUMBER ) IS
1318: SELECT 1 from dual where exists
1319: (SELECT A.ITEM_ID from JTF_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where
1320: B.INVENTORY_ITEM_ID = p_item_id and
1321: B.CATEGORY_ID = A.CATEGORY_ID AND
1322: A.ITEM_ID= p_deliverable_id );
1323:

Line 1379: (SELECT ITEM_ID from JTF_DSP_TPL_CTG where category_id = p_category_id and

1375:
1376: CURSOR category_dlv_cur(p_category_id in NUMBER,
1377: p_deliverable_id IN NUMBER ) IS
1378: SELECT 1 from dual where exists
1379: (SELECT ITEM_ID from JTF_DSP_TPL_CTG where category_id = p_category_id and
1380: ITEM_ID= p_deliverable_id );
1381:
1382: l_return_status boolean := false;
1383: l_exists NUMBER := 0;