APPS.ICX_RELATED_CATEGORIES_PUB dependencies on ICX_RELATED_CATEGORIES

Line 1: PACKAGE BODY ICX_Related_Categories_PUB AS

1: PACKAGE BODY ICX_Related_Categories_PUB AS
2: /* $Header: ICXPCATB.pls 115.1 99/07/17 03:20:00 porting ship $ */
3:
4:
5: PROCEDURE Insert_Relation

Line 85: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);

81: p_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83:
84: -- Get prompts table for translation of messages
85: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
86:
87:
88: -- Perform manditory validation
89:

Line 280: from icx_related_categories

276:
277: -- check that top relationship does not already exist if needed
278: if p_relationship_type = 'TOP' then
279: select count(*) into l_count
280: from icx_related_categories
281: where category_set_id = l_category_set_id
282: and category_id = l_category_id
283: and related_category_id = l_category_id;
284:

Line 304: from icx_related_categories

300:
301: -- check that relationship does not already exist
302: if l_category_id <> l_related_category_id then
303: select count(*) into l_count
304: from icx_related_categories
305: where category_set_id = l_category_set_id
306: and category_id = l_category_id
307: and related_category_id = l_related_category_id;
308:

Line 349: insert into icx_related_categories

345:
346:
347: -- API body
348:
349: insert into icx_related_categories
350: (category_set_id,
351: category_id,
352: related_category_id,
353: relationship_type,

Line 520: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);

516:
517:
518: -- Get prompts table for translation of messages
519:
520: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
521:
522:
523: -- Perform manditory validation
524:

Line 626: delete from icx_related_categories

622:
623:
624: -- API body
625:
626: delete from icx_related_categories
627: where category_set_id = l_category_set_id
628: and category_id = l_category_id
629: and related_category_id = l_related_category_id;
630:

Line 720: END ICX_Related_Categories_PUB;

716: END; -- Delete_Relation
717:
718:
719:
720: END ICX_Related_Categories_PUB;