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_TEMPLATE_HEIRARCHY dependencies on HTP

Line 15: htp.htmlOpen;

11: begin
12: if icx_sec.validateSession then
13: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts);
14:
15: htp.htmlOpen;
16: htp.headOpen;
17: icx_util.copyright;
18: htp.title(l_title);
19: htp.headClose;

Line 16: htp.headOpen;

12: if icx_sec.validateSession then
13: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts);
14:
15: htp.htmlOpen;
16: htp.headOpen;
17: icx_util.copyright;
18: htp.title(l_title);
19: htp.headClose;
20:

Line 18: htp.title(l_title);

14:
15: htp.htmlOpen;
16: htp.headOpen;
17: icx_util.copyright;
18: htp.title(l_title);
19: htp.headClose;
20:
21: htp.p('
22:

Line 19: htp.headClose;

15: htp.htmlOpen;
16: htp.headOpen;
17: icx_util.copyright;
18: htp.title(l_title);
19: htp.headClose;
20:
21: htp.p('
22:
23:

Line 21: htp.p('

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

Line 27: htp.p('');

23:
24: ');
25:
26:
27: htp.p('');
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31:

Line 29: htp.p(FND_MESSAGE.Get);

25:
26:
27: htp.p('');
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31:
32: htp.htmlClose;
33: end if; -- validateSession

Line 30: htp.p('');

26:
27: htp.p('');
28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31:
32: htp.htmlClose;
33: end if; -- validateSession
34:

Line 32: htp.htmlClose;

28: FND_MESSAGE.SET_NAME('ICX','ICX_BROWSER');
29: htp.p(FND_MESSAGE.Get);
30: htp.p('');
31:
32: htp.htmlClose;
33: end if; -- validateSession
34:
35: end main;
36:

Line 71: htp.htmlOpen;

67: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
68: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts);
69: icx_util.getPrompts(601,'ICX_LOV',lov_title,lov_prompts);
70:
71: htp.htmlOpen;
72: htp.headOpen;
73: icx_util.copyright;
74:
75: htp.title(l_title);

Line 72: htp.headOpen;

68: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_R',l_title,l_prompts);
69: icx_util.getPrompts(601,'ICX_LOV',lov_title,lov_prompts);
70:
71: htp.htmlOpen;
72: htp.headOpen;
73: icx_util.copyright;
74:
75: htp.title(l_title);
76:

Line 75: htp.title(l_title);

71: htp.htmlOpen;
72: htp.headOpen;
73: icx_util.copyright;
74:
75: htp.title(l_title);
76:
77: js.scriptOpen;
78: icx_util.LOVScript;
79: icx_admin_sig.help_win_script('/OA_HTML/'||l_language||'/ICXHLMTH.htm');

Line 84: htp.p('function autoquery() {

80:
81: js.null_alert;
82: js.equal_alert;
83:
84: htp.p('function autoquery() {
85: parent.tail.document.Tail.p_template.value = document.Template.ICX_TEMPLATE1.value
86: parent.tail.document.Tail.submit()
87: }');
88:

Line 90: htp.p('function template_changed() {

86: parent.tail.document.Tail.submit()
87: }');
88:
89:
90: htp.p('function template_changed() {
91: parent.tail.document.Tail.p_template.value = document.Template.ICX_TEMPLATE1.value
92: parent.tail.document.Tail.submit()
93: }');
94:

Line 95: htp.p('function pre_template_LOV() {

91: parent.tail.document.Tail.p_template.value = document.Template.ICX_TEMPLATE1.value
92: parent.tail.document.Tail.submit()
93: }');
94:
95: htp.p('function pre_template_LOV() {
96: LOV(''178'',''ICX_TEMPLATE1'',''601'',''ICX_RELATED_TEMPLATES_R'',''Template'',''header'','''','''')
97: }');
98:
99: htp.p('function post_template_LOV(template_name) {

Line 99: htp.p('function post_template_LOV(template_name) {

95: htp.p('function pre_template_LOV() {
96: LOV(''178'',''ICX_TEMPLATE1'',''601'',''ICX_RELATED_TEMPLATES_R'',''Template'',''header'','''','''')
97: }');
98:
99: htp.p('function post_template_LOV(template_name) {
100: parent.tail.document.Tail.p_template.value = template_name
101: parent.tail.document.Tail.submit()
102: }');
103:

Line 105: htp.p('function pre_rel_template_LOV() {

101: parent.tail.document.Tail.submit()
102: }');
103:
104: FND_MESSAGE.SET_NAME('ICX','ICX_TMP_BEFORE');
105: htp.p('function pre_rel_template_LOV() {
106: if (!null_alert(document.Template.ICX_TEMPLATE1.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
107: LOV(''178'',''ICX_RELATED_TEMPLATE'',''601'',''ICX_RELATED_TEMPLATES_R'',''Template'',''header'','''','''')
108: }
109: }');

Line 116: htp.p('function template_submit() {

112: -- var l_where = "EXPRESS_NAME<>''" + document.Template.ICX_TEMPLATE1.value + "''"
113:
114:
115: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
116: htp.p('function template_submit() {
117: if (!null_alert(document.Template.ICX_TEMPLATE1.value,"'||icx_util.replace_quotes(l_prompts(1))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
118: if (document.Template.ICX_RELATION.options[document.Template.ICX_RELATION.selectedIndex].value != "TOP") {');
119: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
120: htp.p(' if (!null_alert(document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(l_prompts(2))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');

Line 120: htp.p(' if (!null_alert(document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(l_prompts(2))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');

116: htp.p('function template_submit() {
117: if (!null_alert(document.Template.ICX_TEMPLATE1.value,"'||icx_util.replace_quotes(l_prompts(1))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
118: if (document.Template.ICX_RELATION.options[document.Template.ICX_RELATION.selectedIndex].value != "TOP") {');
119: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
120: htp.p(' if (!null_alert(document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(l_prompts(2))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');
121: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
122: htp.p(' if (!equal_alert(document.Template.ICX_TEMPLATE1.value,document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
123: document.Template.submit()
124: }

Line 122: htp.p(' if (!equal_alert(document.Template.ICX_TEMPLATE1.value,document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {

118: if (document.Template.ICX_RELATION.options[document.Template.ICX_RELATION.selectedIndex].value != "TOP") {');
119: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
120: htp.p(' if (!null_alert(document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(l_prompts(2))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {');
121: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
122: htp.p(' if (!equal_alert(document.Template.ICX_TEMPLATE1.value,document.Template.ICX_RELATED_TEMPLATE.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {
123: document.Template.submit()
124: }
125: }
126: } else {

Line 133: htp.headClose;

129: }
130: }');
131:
132: js.scriptClose;
133: htp.headClose;
134:
135: htp.bodyOpen(icx_admin_sig.background);
136: icx_admin_sig.toolbar(language_code => l_language);
137:

Line 135: htp.bodyOpen(icx_admin_sig.background);

131:
132: js.scriptClose;
133: htp.headClose;
134:
135: htp.bodyOpen(icx_admin_sig.background);
136: icx_admin_sig.toolbar(language_code => l_language);
137:
138: htp.formOpen(l_agent||'/icx_template_heirarchy.template_insert','POST','','','NAME="Template"');
139:

Line 138: htp.formOpen(l_agent||'/icx_template_heirarchy.template_insert','POST','','','NAME="Template"');

134:
135: htp.bodyOpen(icx_admin_sig.background);
136: icx_admin_sig.toolbar(language_code => l_language);
137:
138: htp.formOpen(l_agent||'/icx_template_heirarchy.template_insert','POST','','','NAME="Template"');
139:
140: htp.tableOpen;
141: htp.tableRowOpen;
142: htp.tableData('

'||l_title||'

');

Line 140: htp.tableOpen;

136: icx_admin_sig.toolbar(language_code => l_language);
137:
138: htp.formOpen(l_agent||'/icx_template_heirarchy.template_insert','POST','','','NAME="Template"');
139:
140: htp.tableOpen;
141: htp.tableRowOpen;
142: htp.tableData('

'||l_title||'

');
143: htp.tableRowClose;
144: htp.tableClose;

Line 141: htp.tableRowOpen;

137:
138: htp.formOpen(l_agent||'/icx_template_heirarchy.template_insert','POST','','','NAME="Template"');
139:
140: htp.tableOpen;
141: htp.tableRowOpen;
142: htp.tableData('

'||l_title||'

');
143: htp.tableRowClose;
144: htp.tableClose;
145:

Line 142: htp.tableData('

'||l_title||'

');

138: htp.formOpen(l_agent||'/icx_template_heirarchy.template_insert','POST','','','NAME="Template"');
139:
140: htp.tableOpen;
141: htp.tableRowOpen;
142: htp.tableData('

'||l_title||'

');
143: htp.tableRowClose;
144: htp.tableClose;
145:
146: htp.tableOpen;

Line 143: htp.tableRowClose;

139:
140: htp.tableOpen;
141: htp.tableRowOpen;
142: htp.tableData('

'||l_title||'

');
143: htp.tableRowClose;
144: htp.tableClose;
145:
146: htp.tableOpen;
147: htp.tableRowOpen;

Line 144: htp.tableClose;

140: htp.tableOpen;
141: htp.tableRowOpen;
142: htp.tableData('

'||l_title||'

');
143: htp.tableRowClose;
144: htp.tableClose;
145:
146: htp.tableOpen;
147: htp.tableRowOpen;
148:

Line 146: htp.tableOpen;

142: htp.tableData('

'||l_title||'

');
143: htp.tableRowClose;
144: htp.tableClose;
145:
146: htp.tableOpen;
147: htp.tableRowOpen;
148:
149: -- Blank table data
150: htp.tableData('
');

Line 147: htp.tableRowOpen;

143: htp.tableRowClose;
144: htp.tableClose;
145:
146: htp.tableOpen;
147: htp.tableRowOpen;
148:
149: -- Blank table data
150: htp.tableData('
');
151: htp.tableData('
');

Line 150: htp.tableData('
');

146: htp.tableOpen;
147: htp.tableRowOpen;
148:
149: -- Blank table data
150: htp.tableData('
');
151: htp.tableData('
');
152:
153: -- Template text field
154: htp.tableData(l_prompts(1),'RIGHT');

Line 151: htp.tableData('
');

147: htp.tableRowOpen;
148:
149: -- Blank table data
150: htp.tableData('
');
151: htp.tableData('
');
152:
153: -- Template text field
154: htp.tableData(l_prompts(1),'RIGHT');
155: htp.tableData(htf.formText('ICX_TEMPLATE1',30,81,p_template,'onchange="template_changed()"'));

Line 154: htp.tableData(l_prompts(1),'RIGHT');

150: htp.tableData('
');
151: htp.tableData('
');
152:
153: -- Template text field
154: htp.tableData(l_prompts(1),'RIGHT');
155: htp.tableData(htf.formText('ICX_TEMPLATE1',30,81,p_template,'onchange="template_changed()"'));
156: htp.tableData(htf.anchor('javascript:pre_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
157: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
158: htp.tableRowClose;

Line 155: htp.tableData(htf.formText('ICX_TEMPLATE1',30,81,p_template,'onchange="template_changed()"'));

151: htp.tableData('
');
152:
153: -- Template text field
154: htp.tableData(l_prompts(1),'RIGHT');
155: htp.tableData(htf.formText('ICX_TEMPLATE1',30,81,p_template,'onchange="template_changed()"'));
156: htp.tableData(htf.anchor('javascript:pre_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
157: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
158: htp.tableRowClose;
159:

Line 156: htp.tableData(htf.anchor('javascript:pre_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),

152:
153: -- Template text field
154: htp.tableData(l_prompts(1),'RIGHT');
155: htp.tableData(htf.formText('ICX_TEMPLATE1',30,81,p_template,'onchange="template_changed()"'));
156: htp.tableData(htf.anchor('javascript:pre_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
157: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
158: htp.tableRowClose;
159:
160: -- Relation poplist

Line 158: htp.tableRowClose;

154: htp.tableData(l_prompts(1),'RIGHT');
155: htp.tableData(htf.formText('ICX_TEMPLATE1',30,81,p_template,'onchange="template_changed()"'));
156: htp.tableData(htf.anchor('javascript:pre_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
157: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
158: htp.tableRowClose;
159:
160: -- Relation poplist
161: htp.tableRowOpen;
162: htp.tableData(l_prompts(3),'RIGHT');

Line 161: htp.tableRowOpen;

157: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
158: htp.tableRowClose;
159:
160: -- Relation poplist
161: htp.tableRowOpen;
162: htp.tableData(l_prompts(3),'RIGHT');
163: htp.p(''||htf.formSelectOpen('ICX_RELATION'));
164: open relations;
165: loop

Line 162: htp.tableData(l_prompts(3),'RIGHT');

158: htp.tableRowClose;
159:
160: -- Relation poplist
161: htp.tableRowOpen;
162: htp.tableData(l_prompts(3),'RIGHT');
163: htp.p(''||htf.formSelectOpen('ICX_RELATION'));
164: open relations;
165: loop
166: fetch relations into temp_relation_code, temp_relation;

Line 163: htp.p(''||htf.formSelectOpen('ICX_RELATION'));

159:
160: -- Relation poplist
161: htp.tableRowOpen;
162: htp.tableData(l_prompts(3),'RIGHT');
163: htp.p(''||htf.formSelectOpen('ICX_RELATION'));
164: open relations;
165: loop
166: fetch relations into temp_relation_code, temp_relation;
167: exit when relations%NOTFOUND;

Line 168: htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');

164: open relations;
165: loop
166: fetch relations into temp_relation_code, temp_relation;
167: exit when relations%NOTFOUND;
168: htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');
169: end loop;
170: close relations;
171: htp.p(htf.formSelectClose||'');
172:

Line 171: htp.p(htf.formSelectClose||'');

167: exit when relations%NOTFOUND;
168: htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');
169: end loop;
170: close relations;
171: htp.p(htf.formSelectClose||'');
172:
173: -- Related Category text field
174: htp.tableData(l_prompts(2),'RIGHT');
175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,''));

Line 174: htp.tableData(l_prompts(2),'RIGHT');

170: close relations;
171: htp.p(htf.formSelectClose||'');
172:
173: -- Related Category text field
174: htp.tableData(l_prompts(2),'RIGHT');
175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,''));
176: htp.tableData(htf.anchor('javascript:pre_rel_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
177: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
178: htp.tableRowClose;

Line 175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,''));

171: htp.p(htf.formSelectClose||'');
172:
173: -- Related Category text field
174: htp.tableData(l_prompts(2),'RIGHT');
175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,''));
176: htp.tableData(htf.anchor('javascript:pre_rel_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
177: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
178: htp.tableRowClose;
179: htp.tableClose;

Line 176: htp.tableData(htf.anchor('javascript:pre_rel_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),

172:
173: -- Related Category text field
174: htp.tableData(l_prompts(2),'RIGHT');
175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,''));
176: htp.tableData(htf.anchor('javascript:pre_rel_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
177: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
178: htp.tableRowClose;
179: htp.tableClose;
180:

Line 178: htp.tableRowClose;

174: htp.tableData(l_prompts(2),'RIGHT');
175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,''));
176: htp.tableData(htf.anchor('javascript:pre_rel_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
177: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
178: htp.tableRowClose;
179: htp.tableClose;
180:
181:
182: -- Write submit and clear buttons

Line 179: htp.tableClose;

175: htp.tableData(htf.formText('ICX_RELATED_TEMPLATE',30,81,''));
176: htp.tableData(htf.anchor('javascript:pre_rel_template_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),
177: '','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"'));
178: htp.tableRowClose;
179: htp.tableClose;
180:
181:
182: -- Write submit and clear buttons
183: htp.tableOpen;

Line 183: htp.tableOpen;

179: htp.tableClose;
180:
181:
182: -- Write submit and clear buttons
183: htp.tableOpen;
184: htp.tableRowOpen;
185: icx_util.DynamicButton(l_prompts(4),'FNDBSBMT.gif',l_prompts(4),'javascript:template_submit()',l_language,FALSE);
186: if (instr(c_browser, 'MSIE') = 0) then
187: icx_util.DynamicButton(l_prompts(5),'FNDBCLR.gif',l_prompts(5),'javascript:document.Template.reset()',l_language,FALSE);

Line 184: htp.tableRowOpen;

180:
181:
182: -- Write submit and clear buttons
183: htp.tableOpen;
184: htp.tableRowOpen;
185: icx_util.DynamicButton(l_prompts(4),'FNDBSBMT.gif',l_prompts(4),'javascript:template_submit()',l_language,FALSE);
186: if (instr(c_browser, 'MSIE') = 0) then
187: icx_util.DynamicButton(l_prompts(5),'FNDBCLR.gif',l_prompts(5),'javascript:document.Template.reset()',l_language,FALSE);
188: end if;

Line 189: htp.tableRowClose;

185: icx_util.DynamicButton(l_prompts(4),'FNDBSBMT.gif',l_prompts(4),'javascript:template_submit()',l_language,FALSE);
186: if (instr(c_browser, 'MSIE') = 0) then
187: icx_util.DynamicButton(l_prompts(5),'FNDBCLR.gif',l_prompts(5),'javascript:document.Template.reset()',l_language,FALSE);
188: end if;
189: htp.tableRowClose;
190: htp.tableClose;
191:
192:
193: -- Query relationships if screen is being repainted after a commit

Line 190: htp.tableClose;

186: if (instr(c_browser, 'MSIE') = 0) then
187: icx_util.DynamicButton(l_prompts(5),'FNDBCLR.gif',l_prompts(5),'javascript:document.Template.reset()',l_language,FALSE);
188: end if;
189: htp.tableRowClose;
190: htp.tableClose;
191:
192:
193: -- Query relationships if screen is being repainted after a commit
194: if p_query_flag = 'T' then

Line 195: htp.p('');
198: end if;
199:

Line 196: htp.p('autoquery()');

192:
193: -- Query relationships if screen is being repainted after a commit
194: if p_query_flag = 'T' then
195: htp.p('');
198: end if;
199:
200:

Line 197: htp.p('');

193: -- Query relationships if screen is being repainted after a commit
194: if p_query_flag = 'T' then
195: htp.p('');
198: end if;
199:
200:
201: htp.formClose;

Line 201: htp.formClose;

197: htp.p('');
198: end if;
199:
200:
201: htp.formClose;
202: icx_sig.footer;
203: htp.bodyClose;
204: htp.htmlClose;
205:

Line 203: htp.bodyClose;

199:
200:
201: htp.formClose;
202: icx_sig.footer;
203: htp.bodyClose;
204: htp.htmlClose;
205:
206: end if; -- ValidateSession
207:

Line 204: htp.htmlClose;

200:
201: htp.formClose;
202: icx_sig.footer;
203: htp.bodyClose;
204: htp.htmlClose;
205:
206: end if; -- ValidateSession
207:
208: exception

Line 259: htp.htmlOpen;

255: icx_util.error_page_setup;
256: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
257: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_DISP_R',l_title,l_prompts);
258:
259: htp.htmlOpen;
260: htp.headOpen;
261: icx_util.copyright;
262: js.scriptOpen;
263:

Line 260: htp.headOpen;

256: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
257: icx_util.getPrompts(601,'ICX_RELATED_TEMPLATES_DISP_R',l_title,l_prompts);
258:
259: htp.htmlOpen;
260: htp.headOpen;
261: icx_util.copyright;
262: js.scriptOpen;
263:
264: -- Javascript function to handle CD buttons

Line 265: htp.p('function rows(start_num, end_num) {

261: icx_util.copyright;
262: js.scriptOpen;
263:
264: -- Javascript function to handle CD buttons
265: htp.p('function rows(start_num, end_num) {
266: document.Tail.p_start_row.value = start_num
267: document.Tail.p_end_row.value = end_num
268: document.Tail.submit()
269: }');

Line 273: htp.p('function delete_relation(template, related_template, html_template, html_related_template) {

269: }');
270:
271: -- javascript function to confirm delete of relationship
272: FND_MESSAGE.Set_name('ICX','ICX_DELETE');
273: htp.p('function delete_relation(template, related_template, html_template, html_related_template) {
274: if (confirm("'||icx_util.replace_onMouseOver_quotes(FND_MESSAGE.Get)||': " + template + " - " + related_template)) {
275: open('''||l_agent||'/ICX_TEMPLATE_HEIRARCHY.template_delete?icx_template1='' + html_template + ''&icx_related_template='' + html_related_template,''tail'')
276: }
277: }');

Line 280: htp.headClose;

276: }
277: }');
278:
279: js.scriptClose;
280: htp.headClose;
281:
282: htp.bodyOpen(icx_admin_sig.background);
283:
284: htp.formOpen(l_agent||'/icx_template_heirarchy.template_tail','POST','','','NAME="Tail"');

Line 282: htp.bodyOpen(icx_admin_sig.background);

278:
279: js.scriptClose;
280: htp.headClose;
281:
282: htp.bodyOpen(icx_admin_sig.background);
283:
284: htp.formOpen(l_agent||'/icx_template_heirarchy.template_tail','POST','','','NAME="Tail"');
285:
286: htp.formHidden('p_template',p_template);

Line 284: htp.formOpen(l_agent||'/icx_template_heirarchy.template_tail','POST','','','NAME="Tail"');

280: htp.headClose;
281:
282: htp.bodyOpen(icx_admin_sig.background);
283:
284: htp.formOpen(l_agent||'/icx_template_heirarchy.template_tail','POST','','','NAME="Tail"');
285:
286: htp.formHidden('p_template',p_template);
287: htp.formHidden('p_start_row',p_start_row);
288: htp.formHidden('p_end_row',p_end_row);

Line 286: htp.formHidden('p_template',p_template);

282: htp.bodyOpen(icx_admin_sig.background);
283:
284: htp.formOpen(l_agent||'/icx_template_heirarchy.template_tail','POST','','','NAME="Tail"');
285:
286: htp.formHidden('p_template',p_template);
287: htp.formHidden('p_start_row',p_start_row);
288: htp.formHidden('p_end_row',p_end_row);
289:
290:

Line 287: htp.formHidden('p_start_row',p_start_row);

283:
284: htp.formOpen(l_agent||'/icx_template_heirarchy.template_tail','POST','','','NAME="Tail"');
285:
286: htp.formHidden('p_template',p_template);
287: htp.formHidden('p_start_row',p_start_row);
288: htp.formHidden('p_end_row',p_end_row);
289:
290:
291: -- check if p_template is valid

Line 288: htp.formHidden('p_end_row',p_end_row);

284: htp.formOpen(l_agent||'/icx_template_heirarchy.template_tail','POST','','','NAME="Tail"');
285:
286: htp.formHidden('p_template',p_template);
287: htp.formHidden('p_start_row',p_start_row);
288: htp.formHidden('p_end_row',p_end_row);
289:
290:
291: -- check if p_template is valid
292: select count(*) into l_count

Line 379: htp.tableOpen('BORDER=1');

375: end if; -- CD Buttons
376:
377:
378: -- display table header
379: htp.tableOpen('BORDER=1');
380: htp.p('');
381: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
382: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
383: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then

Line 380: htp.p('');

376:
377:
378: -- display table header
379: htp.tableOpen('BORDER=1');
380: htp.p('');
381: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
382: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
383: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
384: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT');

Line 384: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT');

380: htp.p('');
381: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
382: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
383: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
384: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT');
385: end if;
386: end loop;
387: htp.tableRowClose;
388:

Line 387: htp.tableRowClose;

383: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
384: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT');
385: end if;
386: end loop;
387: htp.tableRowClose;
388:
389: end if; -- CD Buttons and table header
390:
391:

Line 397: htp.p('');

393: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table);
394:
395:
396: -- display one row of data
397: htp.p('');
398: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
399: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
400: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
401:

Line 411: htp.tableData('
');

407: end if;
408: end loop;
409: -- dont display related category if relationship is TOP
410: if l_result_row_table(ak_query_pkg.g_items_table(temp_relation_item).value_id) = 'TOP' then
411: htp.tableData('
');
412: else
413: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
414: 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));
415: end if;

Line 413: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

409: -- dont display related category if relationship is TOP
410: if l_result_row_table(ak_query_pkg.g_items_table(temp_relation_item).value_id) = 'TOP' then
411: htp.tableData('
');
412: else
413: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
414: 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));
415: end if;
416: else
417: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

Line 417: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

413: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
414: 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));
415: end if;
416: else
417: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
418: 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));
419: end if;
420: end if;
421:

Line 432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''',

428: end if;
429:
430: end loop;
431:
432: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_template)||''','''||icx_util.replace_quotes(temp_related_template)||''',
433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')',
434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'',
435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"'));
436:

Line 437: htp.tableRowClose;

433: '''||replace(icx_util.replace_quotes(temp_template),' ','@~$')||''','''||replace(icx_util.replace_quotes(temp_related_template),' ','@~$')||''')',
434: htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'',
435: 'BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||''';return true"'));
436:
437: htp.tableRowClose;
438:
439: end loop; -- Display data
440:
441: htp.tableClose;

Line 441: htp.tableClose;

437: htp.tableRowClose;
438:
439: end loop; -- Display data
440:
441: htp.tableClose;
442:
443:
444: -- print button set if appropriate
445: if (l_total_rows > l_query_size) and not

Line 464: htp.p('

'||fnd_message.get||'

');

460: -- display message if no rows were returned by query
461: if j = 0 then
462: fnd_message.set_name('ICX','ICX_TMP_NO_RELATION');
463: fnd_message.set_token('TEMPLATE',p_template);
464: htp.p('

'||fnd_message.get||'

');
465: end if;
466:
467:
468: else -- p_template is not valid

Line 473: htp.p('

'||FND_MESSAGE.Get||'

');

469: if p_template is not null then
470: -- display message that category name is not valid
471: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
472: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',p_template);
473: htp.p('

'||FND_MESSAGE.Get||'
');
474: end if;
475:
476: end if;
477:

Line 479: htp.formClose;

475:
476: end if;
477:
478:
479: htp.formClose;
480: htp.bodyClose;
481: htp.htmlClose;
482:
483: end if; -- ValidateSession

Line 480: htp.bodyClose;

476: end if;
477:
478:
479: htp.formClose;
480: htp.bodyClose;
481: htp.htmlClose;
482:
483: end if; -- ValidateSession
484:

Line 481: htp.htmlClose;

477:
478:
479: htp.formClose;
480: htp.bodyClose;
481: htp.htmlClose;
482:
483: end if; -- ValidateSession
484:
485: exception