Web Analytics Made Easy -StatCounter

eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data

APPS.ICX_CAT dependencies on ICX_CAT

Line 1: package body icx_cat as

1: package body icx_cat as
2: /* $Header: ICXCATHB.pls 115.3 99/07/17 03:15:41 porting ship $ */
3:
4:
5:

Line 22:

18: htp.title(l_title);
19: htp.headClose;
20:
21: htp.p('
22:
23:
24: ');
25:
26:

Line 23:

19: htp.headClose;
20:
21: htp.p('
22:
23:
24: ');
25:
26:
27: htp.p('');

Line 48: from icx_category_set_lov;

44:
45: cursor category_sets is
46: select category_set_id,
47: category_set_name
48: from icx_category_set_lov;
49:
50: cursor relations is
51: select lookup_code,
52: meaning

Line 93: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value

89: js.null_alert;
90: js.equal_alert;
91:
92: htp.p('function autoquery() {
93: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
94: parent.tail.document.Tail.p_category_id.value = document.Category.ICX_CATEGORY_ID.value
95: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
96: parent.tail.document.Tail.submit()
97: }');

Line 94: parent.tail.document.Tail.p_category_id.value = document.Category.ICX_CATEGORY_ID.value

90: js.equal_alert;
91:
92: htp.p('function autoquery() {
93: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
94: parent.tail.document.Tail.p_category_id.value = document.Category.ICX_CATEGORY_ID.value
95: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
96: parent.tail.document.Tail.submit()
97: }');
98:

Line 95: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value

91:
92: htp.p('function autoquery() {
93: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
94: parent.tail.document.Tail.p_category_id.value = document.Category.ICX_CATEGORY_ID.value
95: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
96: parent.tail.document.Tail.submit()
97: }');
98:
99: htp.p('function set_changed() {

Line 100: document.Category.ICX_CATEGORY_ID.value = ""

96: parent.tail.document.Tail.submit()
97: }');
98:
99: htp.p('function set_changed() {
100: document.Category.ICX_CATEGORY_ID.value = ""
101: document.Category.ICX_CATEGORY.value = ""
102: document.Category.ICX_RELATED_CATEGORY_ID.value = ""
103: document.Category.ICX_RELATED_CATEGORY.value = ""
104: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value

Line 101: document.Category.ICX_CATEGORY.value = ""

97: }');
98:
99: htp.p('function set_changed() {
100: document.Category.ICX_CATEGORY_ID.value = ""
101: document.Category.ICX_CATEGORY.value = ""
102: document.Category.ICX_RELATED_CATEGORY_ID.value = ""
103: document.Category.ICX_RELATED_CATEGORY.value = ""
104: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
105: parent.tail.document.Tail.p_category_id.value = ""

Line 104: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value

100: document.Category.ICX_CATEGORY_ID.value = ""
101: document.Category.ICX_CATEGORY.value = ""
102: document.Category.ICX_RELATED_CATEGORY_ID.value = ""
103: document.Category.ICX_RELATED_CATEGORY.value = ""
104: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
105: parent.tail.document.Tail.p_category_id.value = ""
106: parent.tail.document.Tail.p_category_name.value = ""
107: parent.tail.document.Tail.submit()
108: }');

Line 111: document.Category.ICX_CATEGORY_ID.value = ""

107: parent.tail.document.Tail.submit()
108: }');
109:
110: htp.p('function cat_changed() {
111: document.Category.ICX_CATEGORY_ID.value = ""
112: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
113: parent.tail.document.Tail.p_category_id.value = ""
114: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
115: parent.tail.document.Tail.submit()

Line 112: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value

108: }');
109:
110: htp.p('function cat_changed() {
111: document.Category.ICX_CATEGORY_ID.value = ""
112: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
113: parent.tail.document.Tail.p_category_id.value = ""
114: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
115: parent.tail.document.Tail.submit()
116: }');

Line 114: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value

110: htp.p('function cat_changed() {
111: document.Category.ICX_CATEGORY_ID.value = ""
112: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
113: parent.tail.document.Tail.p_category_id.value = ""
114: parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
115: parent.tail.document.Tail.submit()
116: }');
117:
118: htp.p('function pre_cat_LOV() {

Line 119: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value

115: parent.tail.document.Tail.submit()
116: }');
117:
118: htp.p('function pre_cat_LOV() {
119: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
120: LOV(''178'',''ICX_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
121: }');
122:
123: htp.p('function post_cat_LOV(cat_id, cat_name) {

Line 120: LOV(''178'',''ICX_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)

116: }');
117:
118: htp.p('function pre_cat_LOV() {
119: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
120: LOV(''178'',''ICX_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
121: }');
122:
123: htp.p('function post_cat_LOV(cat_id, cat_name) {
124: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value

Line 124: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value

120: LOV(''178'',''ICX_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
121: }');
122:
123: htp.p('function post_cat_LOV(cat_id, cat_name) {
124: parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
125: parent.tail.document.Tail.p_category_id.value = cat_id
126: parent.tail.document.Tail.p_category_name.value = cat_name
127: parent.tail.document.Tail.submit()
128: }');

Line 130: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_BEFORE');

126: parent.tail.document.Tail.p_category_name.value = cat_name
127: parent.tail.document.Tail.submit()
128: }');
129:
130: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_BEFORE');
131: htp.p('function pre_rel_cat_LOV() {
132: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
133: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
134: LOV(''178'',''ICX_RELATED_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)

Line 132: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {

128: }');
129:
130: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_BEFORE');
131: htp.p('function pre_rel_cat_LOV() {
132: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
133: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
134: LOV(''178'',''ICX_RELATED_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
135: }
136: }');

Line 133: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value

129:
130: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_BEFORE');
131: htp.p('function pre_rel_cat_LOV() {
132: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
133: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
134: LOV(''178'',''ICX_RELATED_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
135: }
136: }');
137: -- remove manual where clause for now because html can not deal

Line 139: -- var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value + "^@~^and^@~^CONCATENATED_SEGMENTS<>''" + document.Category.ICX_CATEGORY.value + "''"

135: }
136: }');
137: -- remove manual where clause for now because html can not deal
138: -- with the spaces in the category name
139: -- var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value + "^@~^and^@~^CONCATENATED_SEGMENTS<>''" + document.Category.ICX_CATEGORY.value + "''"
140:
141:
142: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
143: htp.p('function cat_submit() {

Line 144: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(4))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {

140:
141:
142: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
143: htp.p('function cat_submit() {
144: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(4))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {');
146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');
148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');

Line 148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');

144: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(4))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {');
146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');
148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
149: htp.p(' if (!equal_alert(document.Category.ICX_CATEGORY.value,document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
150: document.Category.submit()
151: }
152: }

Line 149: htp.p(' if (!equal_alert(document.Category.ICX_CATEGORY.value,document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {

145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {');
146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');
148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
149: htp.p(' if (!equal_alert(document.Category.ICX_CATEGORY.value,document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
150: document.Category.submit()
151: }
152: }
153: } else {

Line 164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');

160: htp.headClose;
161: htp.bodyOpen(icx_admin_sig.background);
162: icx_admin_sig.toolbar(language_code => l_language);
163:
164: htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');
165:
166: htp.tableOpen;
167: htp.tableRowOpen;
168: htp.tableData('

'||l_title||'

');

Line 177: htp.p(''||htf.formSelectOpen('ICX_CATEGORY_SET_ID','','','onchange="set_changed()"'));

173:
174: -- Category Set poplist
175: htp.tableRowOpen;
176: htp.tableData(l_prompts(2),'RIGHT');
177: htp.p(''||htf.formSelectOpen('ICX_CATEGORY_SET_ID','','','onchange="set_changed()"'));
178: open category_sets;
179: loop
180: fetch category_sets into temp_cat_set_id, temp_cat_set;
181: exit when category_sets%NOTFOUND;

Line 192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);

188: close category_sets;
189: htp.p(htf.formSelectClose||'');
190:
191: -- Category text field
192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);
193: htp.tableData(l_prompts(4),'RIGHT');
194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));
195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||
196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));

Line 194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));

190:
191: -- Category text field
192: htp.formHidden('ICX_CATEGORY_ID',p_category_id);
193: htp.tableData(l_prompts(4),'RIGHT');
194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"'));
195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||
196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
197: htp.tableRowClose;
198:

Line 313: open('''||l_agent||'/ICX_CAT.cat_delete?icx_category_set_id='' + cat_set_id + ''&icx_category_id='' + cat_id + ''&icx_related_category_id='' + related_cat_id,''tail'')

309: -- javascript function to confirm delete of relationship
310: FND_MESSAGE.Set_name('ICX','ICX_DELETE');
311: htp.p('function delete_relation(cat, related_cat, cat_set_id, cat_id, related_cat_id) {
312: if (confirm("'||icx_util.replace_quotes(FND_MESSAGE.Get)||': " + cat + " - " + related_cat)) {
313: open('''||l_agent||'/ICX_CAT.cat_delete?icx_category_set_id='' + cat_set_id + ''&icx_category_id='' + cat_id + ''&icx_related_category_id='' + related_cat_id,''tail'')
314: }
315: }');
316:
317: js.scriptClose;

Line 322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');

318: htp.headClose;
319:
320: htp.bodyOpen(icx_admin_sig.background);
321:
322: htp.formOpen(l_agent||'/icx_cat.cat_tail','POST','','','NAME="Tail"');
323:
324: htp.formHidden('p_category_set_id',p_category_set_id);
325: htp.formHidden('p_category_id',p_category_id);
326: htp.formHidden('p_category_name',p_category_name);

Line 477: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_CATEGORY' then

473: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
474: end if;
475: end if;
476:
477: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_CATEGORY' then
478: temp_cat := l_result_row_table(ak_query_pkg.g_items_table(k).value_id);
479: end if;
480:
481: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_RELATED_CATEGORY' then

Line 485: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_CATEGORY_SET_ID' then

481: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_RELATED_CATEGORY' then
482: temp_related_cat := l_result_row_table(ak_query_pkg.g_items_table(k).value_id);
483: end if;
484:
485: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_CATEGORY_SET_ID' then
486: temp_cat_set_id := l_result_row_table(ak_query_pkg.g_items_table(k).value_id);
487: end if;
488:
489: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_CATEGORY_ID' then

Line 489: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_CATEGORY_ID' then

485: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_CATEGORY_SET_ID' then
486: temp_cat_set_id := l_result_row_table(ak_query_pkg.g_items_table(k).value_id);
487: end if;
488:
489: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_CATEGORY_ID' then
490: temp_cat_id := l_result_row_table(ak_query_pkg.g_items_table(k).value_id);
491: end if;
492:
493: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_RELATED_CATEGORY_ID' then

Line 527: fnd_message.set_name('ICX','ICX_CAT_NO_RELATION');

523:
524:
525: -- display message if no rows were returned by query
526: if j = 0 then
527: fnd_message.set_name('ICX','ICX_CAT_NO_RELATION');
528: fnd_message.set_token('CATEGORY',p_category_name);
529: htp.p('

'||fnd_message.get||'

');
530: end if;
531:

Line 562: procedure cat_insert(icx_category_set_id in varchar2 default null,

558: end cat_tail;
559:
560:
561:
562: procedure cat_insert(icx_category_set_id in varchar2 default null,
563: icx_category_id in varchar2 default null,
564: icx_category in varchar2 default null,
565: icx_relation in varchar2 default null,
566: icx_related_category_id in varchar2 default null,

Line 563: icx_category_id in varchar2 default null,

559:
560:
561:
562: procedure cat_insert(icx_category_set_id in varchar2 default null,
563: icx_category_id in varchar2 default null,
564: icx_category in varchar2 default null,
565: icx_relation in varchar2 default null,
566: icx_related_category_id in varchar2 default null,
567: icx_related_category in varchar2 default null) is

Line 564: icx_category in varchar2 default null,

560:
561:
562: procedure cat_insert(icx_category_set_id in varchar2 default null,
563: icx_category_id in varchar2 default null,
564: icx_category in varchar2 default null,
565: icx_relation in varchar2 default null,
566: icx_related_category_id in varchar2 default null,
567: icx_related_category in varchar2 default null) is
568:

Line 591: p_category_set_id => icx_category_set_id ,

587: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
588: p_return_status => l_return_status ,
589: p_msg_count => l_msg_count ,
590: p_msg_data => l_msg_data ,
591: p_category_set_id => icx_category_set_id ,
592: p_category_id => icx_category_id ,
593: p_category => icx_category ,
594: p_related_category_id => icx_category_id ,
595: p_related_category => icx_category ,

Line 592: p_category_id => icx_category_id ,

588: p_return_status => l_return_status ,
589: p_msg_count => l_msg_count ,
590: p_msg_data => l_msg_data ,
591: p_category_set_id => icx_category_set_id ,
592: p_category_id => icx_category_id ,
593: p_category => icx_category ,
594: p_related_category_id => icx_category_id ,
595: p_related_category => icx_category ,
596: p_relationship_type => 'TOP' ,

Line 593: p_category => icx_category ,

589: p_msg_count => l_msg_count ,
590: p_msg_data => l_msg_data ,
591: p_category_set_id => icx_category_set_id ,
592: p_category_id => icx_category_id ,
593: p_category => icx_category ,
594: p_related_category_id => icx_category_id ,
595: p_related_category => icx_category ,
596: p_relationship_type => 'TOP' ,
597: p_created_by => l_user_id

Line 594: p_related_category_id => icx_category_id ,

590: p_msg_data => l_msg_data ,
591: p_category_set_id => icx_category_set_id ,
592: p_category_id => icx_category_id ,
593: p_category => icx_category ,
594: p_related_category_id => icx_category_id ,
595: p_related_category => icx_category ,
596: p_relationship_type => 'TOP' ,
597: p_created_by => l_user_id
598: );

Line 595: p_related_category => icx_category ,

591: p_category_set_id => icx_category_set_id ,
592: p_category_id => icx_category_id ,
593: p_category => icx_category ,
594: p_related_category_id => icx_category_id ,
595: p_related_category => icx_category ,
596: p_relationship_type => 'TOP' ,
597: p_created_by => l_user_id
598: );
599:

Line 614: p_category_set_id => icx_category_set_id ,

610: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
611: p_return_status => l_return_status ,
612: p_msg_count => l_msg_count ,
613: p_msg_data => l_msg_data ,
614: p_category_set_id => icx_category_set_id ,
615: p_category_id => icx_category_id ,
616: p_category => icx_category ,
617: p_related_category_id => icx_related_category_id ,
618: p_related_category => icx_related_category ,

Line 615: p_category_id => icx_category_id ,

611: p_return_status => l_return_status ,
612: p_msg_count => l_msg_count ,
613: p_msg_data => l_msg_data ,
614: p_category_set_id => icx_category_set_id ,
615: p_category_id => icx_category_id ,
616: p_category => icx_category ,
617: p_related_category_id => icx_related_category_id ,
618: p_related_category => icx_related_category ,
619: p_relationship_type => 'CHILD' ,

Line 616: p_category => icx_category ,

612: p_msg_count => l_msg_count ,
613: p_msg_data => l_msg_data ,
614: p_category_set_id => icx_category_set_id ,
615: p_category_id => icx_category_id ,
616: p_category => icx_category ,
617: p_related_category_id => icx_related_category_id ,
618: p_related_category => icx_related_category ,
619: p_relationship_type => 'CHILD' ,
620: p_created_by => l_user_id

Line 634: icx_cat.cat_head(icx_category_set_id, icx_category_id, icx_category, 'T');

630:
631: else
632:
633: -- repaint header
634: icx_cat.cat_head(icx_category_set_id, icx_category_id, icx_category, 'T');
635:
636: end if;
637:
638:

Line 646: procedure cat_delete(icx_category_set_id in varchar2 default null,

642:
643:
644:
645:
646: procedure cat_delete(icx_category_set_id in varchar2 default null,
647: icx_category_id in varchar2 default null,
648: icx_related_category_id in varchar2 default null) is
649:
650: cursor category_name is

Line 647: icx_category_id in varchar2 default null,

643:
644:
645:
646: procedure cat_delete(icx_category_set_id in varchar2 default null,
647: icx_category_id in varchar2 default null,
648: icx_related_category_id in varchar2 default null) is
649:
650: cursor category_name is
651: select CONCATENATED_SEGMENTS

Line 652: from icx_category_lov

648: icx_related_category_id in varchar2 default null) is
649:
650: cursor category_name is
651: select CONCATENATED_SEGMENTS
652: from icx_category_lov
653: where category_id = icx_category_id;
654:
655: l_return_status varchar2(1) := 'S';
656: l_msg_count number;

Line 653: where category_id = icx_category_id;

649:
650: cursor category_name is
651: select CONCATENATED_SEGMENTS
652: from icx_category_lov
653: where category_id = icx_category_id;
654:
655: l_return_status varchar2(1) := 'S';
656: l_msg_count number;
657: l_msg_data varchar2(240);

Line 678: p_category_set_id => icx_category_set_id ,

674: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
675: p_return_status => l_return_status ,
676: p_msg_count => l_msg_count ,
677: p_msg_data => l_msg_data ,
678: p_category_set_id => icx_category_set_id ,
679: p_category_id => icx_category_id ,
680: p_related_category_id => icx_related_category_id
681: );
682:

Line 679: p_category_id => icx_category_id ,

675: p_return_status => l_return_status ,
676: p_msg_count => l_msg_count ,
677: p_msg_data => l_msg_data ,
678: p_category_set_id => icx_category_set_id ,
679: p_category_id => icx_category_id ,
680: p_related_category_id => icx_related_category_id
681: );
682:
683:

Line 695: icx_cat.cat_tail(icx_category_set_id, icx_category_id,l_category);

691: -- repaint relationships
692: open category_name;
693: fetch category_name into l_category;
694: close category_name;
695: icx_cat.cat_tail(icx_category_set_id, icx_category_id,l_category);
696:
697: end if;
698:
699:

Line 707: end icx_cat;

703:
704:
705:
706:
707: end icx_cat;