APPS.AMV_CATEGORY_PVT dependencies on AMV_C_CATEGORIES_B

Line 261: from amv_c_categories_b b, amv_c_categories_tl tl

257: l_category_id number;
258: --
259: CURSOR Get_CategoryId is
260: select b.channel_category_id
261: from amv_c_categories_b b, amv_c_categories_tl tl
262: where tl.channel_category_name = p_category_name
263: and tl.language = userenv('lang')
264: and tl.channel_category_id = b.channel_category_id
265: and b.parent_channel_category_id is null;

Line 269: from amv_c_categories_b b, amv_c_categories_tl tl

265: and b.parent_channel_category_id is null;
266: --
267: CURSOR Get_SubCategoryId is
268: select b.channel_category_id
269: from amv_c_categories_b b, amv_c_categories_tl tl
270: where tl.channel_category_name = p_category_name
271: and tl.language = userenv('lang')
272: and tl.channel_category_id = b.channel_category_id
273: and b.parent_channel_category_id = p_parent_category_id;

Line 392: from amv_c_categories_b A, amv_c_categories_tl B

388: l_temp_cat_name varchar2(80);
389: --
390: cursor scat_id is
391: select A.channel_category_id, channel_category_name
392: from amv_c_categories_b A, amv_c_categories_tl B
393: where parent_channel_category_id = l_cat_id
394: and A.channel_category_id = B.channel_category_id
395: and B.language = USERENV('LANG')
396: order by channel_category_name;

Line 461: from amv_c_categories_b

457: l_cat_name varchar2(80);
458: --
459: cursor get_parent is
460: select parent_channel_category_id
461: from amv_c_categories_b
462: where channel_category_id = l_cat_id;
463: --
464: BEGIN
465:

Line 571: SELECT amv_c_categories_b_s.nextval

567: l_order number;
568: --
569:
570: CURSOR CategoryId_Seq IS
571: SELECT amv_c_categories_b_s.nextval
572: FROM dual;
573:
574: CURSOR Max_CategoryOrder IS
575: SELECT NVL(MAX(channel_category_order) + 1, 1)

Line 576: FROM amv_c_categories_b

572: FROM dual;
573:
574: CURSOR Max_CategoryOrder IS
575: SELECT NVL(MAX(channel_category_order) + 1, 1)
576: FROM amv_c_categories_b
577: WHERE parent_channel_category_id is null
578: and application_id = p_application_id;
579:
580: CURSOR Max_SubCategoryOrder IS

Line 582: FROM amv_c_categories_b

578: and application_id = p_application_id;
579:
580: CURSOR Max_SubCategoryOrder IS
581: SELECT NVL(MAX(channel_category_order) + 1, 1)
582: FROM amv_c_categories_b
583: WHERE parent_channel_category_id = l_parent_category_id;
584:
585: BEGIN
586: -- Standard begin of API savepoint

Line 1236: FROM amv_c_categories_b b, amv_c_categories_tl tl

1232: l_category_array AMV_NUMBER_VARRAY_TYPE;
1233:
1234: CURSOR Get_CategoryOrder IS
1235: SELECT b.channel_category_id
1236: FROM amv_c_categories_b b, amv_c_categories_tl tl
1237: WHERE b.parent_channel_category_id is null
1238: and b.application_id = p_application_id
1239: ORDER BY tl.channel_category_name;
1240:

Line 1243: FROM amv_c_categories_b b, amv_c_categories_tl tl

1239: ORDER BY tl.channel_category_name;
1240:
1241: CURSOR Get_SubCategoryOrder IS
1242: SELECT b.channel_category_id
1243: FROM amv_c_categories_b b, amv_c_categories_tl tl
1244: WHERE b.parent_channel_category_id = l_parent_category_id
1245: ORDER BY tl.channel_category_name;
1246:
1247: CURSOR Get_CatRec_csr IS

Line 1250: FROM amv_c_categories_b

1246:
1247: CURSOR Get_CatRec_csr IS
1248: SELECT application_id
1249: , channel_count
1250: FROM amv_c_categories_b
1251: WHERE channel_category_id = l_category_id;
1252:
1253: BEGIN
1254: -- Standard begin of API savepoint

Line 1513: from amv_c_categories_b

1509: CURSOR Get_CatRec_csr IS
1510: select application_id,
1511: parent_channel_category_id,
1512: channel_count
1513: from amv_c_categories_b
1514: where channel_category_id = l_category_id;
1515: BEGIN
1516: -- Standard begin of API savepoint
1517: SAVEPOINT Reorder_Category_PVT;

Line 1765: from amv_c_categories_b

1761: application_id,
1762: channel_category_order,
1763: parent_channel_category_id,
1764: channel_count
1765: from amv_c_categories_b
1766: where channel_category_id = l_category_id;
1767:
1768: CURSOR Get_CatDesc_csr IS
1769: select description

Line 4381: from amv_c_categories_b b

4377: , b.object_version_number
4378: , b.application_id
4379: , b.channel_category_order
4380: , b.channel_count
4381: from amv_c_categories_b b
4382: where b.channel_category_id = p_category_id;
4383: --
4384: BEGIN
4385: -- Standard begin of API savepoint