DBA Data[Home] [Help]

APPS.ICX_REQ_COPY_REQ dependencies on HTP

Line 35: htp.htmlOpen;

31:
32: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_INTRO_TITLE');
33: c_title := FND_MESSAGE.GET;
34:
35: htp.htmlOpen;
36: htp.title(c_title);
37: htp.bodyOpen;
38:
39: htp.headOpen;

Line 36: htp.title(c_title);

32: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_INTRO_TITLE');
33: c_title := FND_MESSAGE.GET;
34:
35: htp.htmlOpen;
36: htp.title(c_title);
37: htp.bodyOpen;
38:
39: htp.headOpen;
40:

Line 37: htp.bodyOpen;

33: c_title := FND_MESSAGE.GET;
34:
35: htp.htmlOpen;
36: htp.title(c_title);
37: htp.bodyOpen;
38:
39: htp.headOpen;
40:
41: icx_util.copyright;

Line 39: htp.headOpen;

35: htp.htmlOpen;
36: htp.title(c_title);
37: htp.bodyOpen;
38:
39: htp.headOpen;
40:
41: icx_util.copyright;
42:
43: js.scriptOpen;

Line 45: htp.p('function help_window(){

41: icx_util.copyright;
42:
43: js.scriptOpen;
44:
45: htp.p('function help_window(){
46: help_win = window.open(''/OA_DOC/' || v_lang || '/awe' || '/icxhlprq.htm'', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,height=250");
47: help_win = window.open(''/OA_DOC/' || v_lang || '/awe' || '/icxhlprq.htm'', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,height=250")
48: }
49: ');

Line 52: htp.headClose;

48: }
49: ');
50:
51: js.scriptClose;
52: htp.headClose;
53:
54: -- TOOLBAR
55: icx_admin_sig.toolbar(language_code => v_lang);
56:

Line 57: htp.p('');

53:
54: -- TOOLBAR
55: icx_admin_sig.toolbar(language_code => v_lang);
56:
57: htp.p('

');
58: htp.p('
59: v_lang || '/FNDDBPX6.gif height=1 width=1>
');
60:
61: htp.p('');

Line 58: htp.p('

54: -- TOOLBAR
55: icx_admin_sig.toolbar(language_code => v_lang);
56:
57: htp.p('');
58: htp.p('
59: v_lang || '/FNDDBPX6.gif height=1 width=1>
');
60:
61: htp.p('');
62: htp.p('
');

Line 61: htp.p('');

57: htp.p('

');
58: htp.p('
59: v_lang || '/FNDDBPX6.gif height=1 width=1>
');
60:
61: htp.p('');
62: htp.p('
');
63:
64: -- The top intro line of the page
65: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_INTRO_TXT');

Line 62: htp.p('
');

58: htp.p('

59: v_lang || '/FNDDBPX6.gif height=1 width=1>
');
60:
61: htp.p('');
62: htp.p('');

89: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_CHK_ORDER_TTL');
90: v_message_caption := FND_MESSAGE.GET;
91: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_CHK_ORDER_TXT');
92: v_message_text := FND_MESSAGE.GET;
93: htp.p('

');
94: htp.p('
');
95: htp.p('
');
63:
64: -- The top intro line of the page
65: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_INTRO_TXT');
66: htp.p(FND_MESSAGE.GET || '

');

Line 66: htp.p(FND_MESSAGE.GET || '

');

62: htp.p('

');
63:
64: -- The top intro line of the page
65: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_INTRO_TXT');
66: htp.p(FND_MESSAGE.GET || '

');
67: htp.p('

');
68:
69: -- The First line of the intro
70: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_COPY_ITEMS_TTL');

Line 67: htp.p('
');

63:
64: -- The top intro line of the page
65: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_INTRO_TXT');
66: htp.p(FND_MESSAGE.GET || '

');
67: htp.p('

');
68:
69: -- The First line of the intro
70: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_COPY_ITEMS_TTL');
71: v_message_caption := FND_MESSAGE.GET;

Line 74: htp.p('');

70: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_COPY_ITEMS_TTL');
71: v_message_caption := FND_MESSAGE.GET;
72: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_COPY_ITEMS_TXT');
73: v_message_text := FND_MESSAGE.GET;
74: htp.p('

');
75: htp.p('');
76: htp.p('');

71: v_message_caption := FND_MESSAGE.GET;
72: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_COPY_ITEMS_TXT');
73: v_message_text := FND_MESSAGE.GET;
74: htp.p('

78: '>' || '

Line 75: htp.p('
');
75: htp.p('');
76: htp.p('');

Line 76: htp.p('
');
82: htp.p('');
84: htp.p('
78: '>' || ' 79: '/FNDICPY.gif border=no height=75 width=75 align=absmiddle> 73: v_message_text := FND_MESSAGE.GET;
74: htp.p('');
75: htp.p('');
76: htp.p('');
80: htp.p('
');
80: htp.p('
');
82: htp.p('
');
84: htp.p('
');
80: htp.p('
');
82: htp.p('
');
84: htp.p('
78: '>' || ' 79: '/FNDICPY.gif border=no height=75 width=75 align=absmiddle>

Line 80: htp.p('

76: htp.p('

78: '>' || ' 79: '/FNDICPY.gif border=no height=75 width=75 align=absmiddle> 81: '/FNDIBLBR.gif width=500 height=4>
' ||
83: '1
' ||

Line 82: htp.p('
' ||

78: '>' || ' 79: '/FNDICPY.gif border=no height=75 width=75 align=absmiddle>

81: '/FNDIBLBR.gif width=500 height=4>
' ||
83: '1
' ||
85: v_message_caption || '

' || v_message_text ||
86: '
');

Line 84: htp.p('
' ||

80: htp.p('

81: '/FNDIBLBR.gif width=500 height=4>
' ||
83: '1
' ||
85: v_message_caption || '
' || v_message_text ||
86: '
');
87:
88: -- Second line

Line 93: htp.p('
 ');
96: htp.p('');
97: htp.p('');

Line 94: htp.p('
');

90: v_message_caption := FND_MESSAGE.GET;
91: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_CHK_ORDER_TXT');
92: v_message_text := FND_MESSAGE.GET;
93: htp.p('

');
94: htp.p('');
95: htp.p('
 
 ');
96: htp.p('');
97: htp.p('');
98: htp.p('');
94: htp.p('');
95: htp.p('

Line 95: htp.p('
');

91: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_CHK_ORDER_TXT');
92: v_message_text := FND_MESSAGE.GET;
93: htp.p('

  ');
96: htp.p('');
97: htp.p('');
98: htp.p('');

Line 96: htp.p('
99: '/FNDICKO.gif height=75 width=75 align = absmiddle>
');

92: v_message_text := FND_MESSAGE.GET;
93: htp.p('

');
94: htp.p('');
95: htp.p('');
371:
372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'

Line 370: htp.p('
');

366: END IF; /* (v_total_rows > 5) */
367:
368: -- Print table header
369: htp.tableOpen('BORDER=2','','','', 'CELLPADDING=2');
370: htp.p('

');
371:
372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN

Line 376: htp.p('
');
378:
379: END IF; /* if ak_query_pkg.... */
380:

Line 377: htp.p('');

373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN
375:
376: htp.p('

');
378:
379: END IF; /* if ak_query_pkg.... */
380:
381: END LOOP;

Line 382: htp.tableRowClose;

378:
379: END IF; /* if ak_query_pkg.... */
380:
381: END LOOP;
382: htp.tableRowClose;
383: htp.tableData(''); -- ?
384:
385: -- FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
386: FOR r IN p_start_row -1..v_end_row - 1 LOOP

Line 383: htp.tableData(''); -- ?

379: END IF; /* if ak_query_pkg.... */
380:
381: END LOOP;
382: htp.tableRowClose;
383: htp.tableData(''); -- ?
384:
385: -- FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
386: FOR r IN p_start_row -1..v_end_row - 1 LOOP
387: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);

Line 389: htp.tableRowOpen;

385: -- FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
386: FOR r IN p_start_row -1..v_end_row - 1 LOOP
387: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
388:
389: htp.tableRowOpen;
390:
391: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
392: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
393: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y')

Line 402: htp.tableData(htf.anchor('oracleON.IC?Y='|| icx_call.encrypt2(v_param), y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));

398:
399: -- Build the parameter to jump into AK flow from here
400: v_param := 'D*****1****' || v_row_id || '*ICX_PO_REQ_HEADER_PK*' || v_req_header_id || '**]';
401: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_REQ_NUM' THEN
402: htp.tableData(htf.anchor('oracleON.IC?Y='|| icx_call.encrypt2(v_param), y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));
403:
404: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_COPY' THEN
405:
406: htp.tableData(htf.anchor('icx_req_copy_req.copy_req?v_req_header_id='|| icx_call.encrypt2(v_req_header_id), htf.img('/OA_MEDIA/' || v_language_code || '/FNDISPLT.gif', 'CENTER', '', '', 'BORDER=NO WIDTH=20 HEIGHT=20')));

Line 406: htp.tableData(htf.anchor('icx_req_copy_req.copy_req?v_req_header_id='|| icx_call.encrypt2(v_req_header_id), htf.img('/OA_MEDIA/' || v_language_code || '/FNDISPLT.gif', 'CENTER', '', '', 'BORDER=NO WIDTH=20 HEIGHT=20')));

402: htp.tableData(htf.anchor('oracleON.IC?Y='|| icx_call.encrypt2(v_param), y_table(ak_query_pkg.g_items_table(i).value_id),'','onMouseOver="return true"'));
403:
404: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_COPY' THEN
405:
406: htp.tableData(htf.anchor('icx_req_copy_req.copy_req?v_req_header_id='|| icx_call.encrypt2(v_req_header_id), htf.img('/OA_MEDIA/' || v_language_code || '/FNDISPLT.gif', 'CENTER', '', '', 'BORDER=NO WIDTH=20 HEIGHT=20')));
407:
408: ELSE
409: IF (y_table(ak_query_pkg.g_items_table(i).value_id)) IS NULL THEN
410: htp.tableData(' ');

Line 410: htp.tableData(' ');

406: htp.tableData(htf.anchor('icx_req_copy_req.copy_req?v_req_header_id='|| icx_call.encrypt2(v_req_header_id), htf.img('/OA_MEDIA/' || v_language_code || '/FNDISPLT.gif', 'CENTER', '', '', 'BORDER=NO WIDTH=20 HEIGHT=20')));
407:
408: ELSE
409: IF (y_table(ak_query_pkg.g_items_table(i).value_id)) IS NULL THEN
410: htp.tableData(' ');
411: ELSE
412: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));
413: END IF;
414: END IF; /* ... ICX_REQ_NUM */

Line 412: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));

408: ELSE
409: IF (y_table(ak_query_pkg.g_items_table(i).value_id)) IS NULL THEN
410: htp.tableData(' ');
411: ELSE
412: htp.tableData(y_table(ak_query_pkg.g_items_table(i).value_id));
413: END IF;
414: END IF; /* ... ICX_REQ_NUM */
415: END IF; /* secured_column = 'F'... */
416:

Line 419: htp.tableRowClose;

415: END IF; /* secured_column = 'F'... */
416:
417: END LOOP;
418:
419: htp.tableRowClose;
420:
421: END LOOP;
422:
423: htp.tableClose;

Line 423: htp.tableClose;

419: htp.tableRowClose;
420:
421: END LOOP;
422:
423: htp.tableClose;
424:
425: htp.br;
426:
427: IF(v_total_rows > 5)

Line 425: htp.br;

421: END LOOP;
422:
423: htp.tableClose;
424:
425: htp.br;
426:
427: IF(v_total_rows > 5)
428: THEN
429: icx_on_utilities2.displaySetIcons(v_language_code,

Line 438: htp.formClose;

434: v_query_size,
435: v_total_rows);
436: END IF; /* (v_total_rows > 5) */
437:
438: htp.formClose;
439: icx_admin_sig.footer;
440:
441: END IF; /* v_total_rows = 0 */
442:

Line 447: -- htp.p('Error in display reqs ' || substr(SQLERRM, 1, 512));

443: END IF; /* validate session */
444:
445: EXCEPTION
446: WHEN OTHERS THEN
447: -- htp.p('Error in display reqs ' || substr(SQLERRM, 1, 512));
448: -- icx_util.add_error(substr(SQLERRM, 12, 512));
449: -- icx_util.error_page_print;
450:
451: l_err_num := SQLCODE;

Line 924: -- htp.p('Error in copy req ' || substr(SQLERRM, 1, 512));

920:
921:
922: EXCEPTION
923: WHEN OTHERS THEN
924: -- htp.p('Error in copy req ' || substr(SQLERRM, 1, 512));
925: icx_util.add_error(substr(SQLERRM, 12, 512));
926: icx_util.error_page_print;
927:
928: END copy_req;

 ');
96: htp.p('');
97: htp.p('');
98: htp.p('');
100: htp.p('');

93: htp.p('

');
94: htp.p('');
95: htp.p('
99: '/FNDICKO.gif height=75 width=75 align = absmiddle>

Line 97: htp.p('
 ');
96: htp.p('');
97: htp.p('');
98: htp.p('');
100: htp.p('');

Line 98: htp.p('
');
95: htp.p('');

109: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PLACE_ORDER_TTL');
110: v_message_caption := FND_MESSAGE.GET;
111: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PLACE_ORDER_TXT');
112: v_message_text := FND_MESSAGE.GET;
113: htp.p('

');
114: htp.p('');
115: htp.p('
99: '/FNDICKO.gif height=75 width=75 align = absmiddle> 101: '/FNDIRDBR.gif width=500 height=4>

94: htp.p('

 ');
96: htp.p('');
97: htp.p('');
98: htp.p('');
100: htp.p('
');
102: htp.p('
');
102: htp.p('
');
104: htp.p('
' ||
106: '
99: '/FNDICKO.gif height=75 width=75 align = absmiddle> 101: '/FNDIRDBR.gif width=500 height=4>
' ||

Line 100: htp.p('

96: htp.p('');
97: htp.p('');
98: htp.p('');
100: htp.p('');
102: htp.p('
');
104: htp.p('
');
100: htp.p('
');
102: htp.p('
');
104: htp.p('
' ||
106: '
99: '/FNDICKO.gif height=75 width=75 align = absmiddle> 101: '/FNDIRDBR.gif width=500 height=4>
' ||
103: '2
' ||

Line 102: htp.p('
' ||

98: htp.p('

99: '/FNDICKO.gif height=75 width=75 align = absmiddle> 101: '/FNDIRDBR.gif width=500 height=4>
' ||
103: '2
' ||
105: v_message_caption || '

' || v_message_text || '
');

Line 104: htp.p('
' ||

100: htp.p('

101: '/FNDIRDBR.gif width=500 height=4>
' ||
103: '2
' ||
105: v_message_caption || '
' || v_message_text || '
');
107:
108: -- Third line

Line 113: htp.p('
 ');
116: htp.p('');
117: htp.p('');

Line 114: htp.p('
');

110: v_message_caption := FND_MESSAGE.GET;
111: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PLACE_ORDER_TXT');
112: v_message_text := FND_MESSAGE.GET;
113: htp.p('

');
114: htp.p('');
115: htp.p('' || '
 
 ');
116: htp.p('');
117: htp.p('');
118: htp.p('');
114: htp.p('');
115: htp.p('

Line 115: htp.p('
');

111: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PLACE_ORDER_TXT');
112: v_message_text := FND_MESSAGE.GET;
113: htp.p('

  ');
116: htp.p('');
117: htp.p('');
118: htp.p('');

Line 116: htp.p('
119: '/FNDIPLO.gif height=75 width=75 align = absmiddle>
');

112: v_message_text := FND_MESSAGE.GET;
113: htp.p('

');
114: htp.p('');
115: htp.p('' || '
 ');
116: htp.p('');
117: htp.p('');
118: htp.p('');
120: htp.p('');

113: htp.p('

');
114: htp.p('');
115: htp.p('
119: '/FNDIPLO.gif height=75 width=75 align = absmiddle>

Line 117: htp.p('
 ');
116: htp.p('');
117: htp.p('');
118: htp.p('');
120: htp.p('');

Line 118: htp.p('
');
115: htp.p('
119: '/FNDIPLO.gif height=75 width=75 align = absmiddle> 121: '/FNDIGRBR.gif width=500 height=4>

114: htp.p('

 ');
116: htp.p('');
117: htp.p('');
118: htp.p('');
120: htp.p('
');
122: htp.p('
');
122: htp.p('
');
124: htp.p('
' || '
119: '/FNDIPLO.gif height=75 width=75 align = absmiddle> 121: '/FNDIGRBR.gif width=500 height=4>
' ||

Line 120: htp.p('

116: htp.p('');
117: htp.p('');
118: htp.p('');
120: htp.p('');
122: htp.p('
');
124: htp.p('
');
120: htp.p('
');
122: htp.p('
');
124: htp.p('
' || '
119: '/FNDIPLO.gif height=75 width=75 align = absmiddle> 121: '/FNDIGRBR.gif width=500 height=4>
' ||
123: '3
' ||

Line 122: htp.p('
' ||

118: htp.p('

119: '/FNDIPLO.gif height=75 width=75 align = absmiddle> 121: '/FNDIGRBR.gif width=500 height=4>
' ||
123: '3
' ||
125: v_message_caption || '

' || v_message_text ||
126: '
');

Line 124: htp.p('
' ||

120: htp.p('

121: '/FNDIGRBR.gif width=500 height=4>
' ||
123: '3
' ||
125: v_message_caption || '
' || v_message_text ||
126: '
');
127:
128: htp.p('
');

Line 128: htp.p('
');

124: htp.p('

' ||
125: v_message_caption || '

' || v_message_text ||
126: '
');
127:
128: htp.p('
');
129:
130: htp.p('
');
131: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs',
132: htf.img('/OA_MEDIA/' || v_lang ||

Line 130: htp.p('
');

126: '

');
127:
128: htp.p('
');
129:
130: htp.p('
');
131: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs',
132: htf.img('/OA_MEDIA/' || v_lang ||
133: '/FNDICPYS.gif', cattributes => 'BORDER = NO align=absmiddle' ));
134: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PROCEED_TO_COPY');

Line 131: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs',

127:
128: htp.p('

');
129:
130: htp.p('
');
131: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs',
132: htf.img('/OA_MEDIA/' || v_lang ||
133: '/FNDICPYS.gif', cattributes => 'BORDER = NO align=absmiddle' ));
134: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PROCEED_TO_COPY');
135: htp.p('');

Line 135: htp.p('');

131: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs',
132: htf.img('/OA_MEDIA/' || v_lang ||
133: '/FNDICPYS.gif', cattributes => 'BORDER = NO align=absmiddle' ));
134: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PROCEED_TO_COPY');
135: htp.p('');
136: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs', FND_MESSAGE.GET);
137: htp.p('
');
138: htp.p('

');
139:

Line 136: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs', FND_MESSAGE.GET);

132: htf.img('/OA_MEDIA/' || v_lang ||
133: '/FNDICPYS.gif', cattributes => 'BORDER = NO align=absmiddle' ));
134: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PROCEED_TO_COPY');
135: htp.p('');
136: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs', FND_MESSAGE.GET);
137: htp.p('
');
138: htp.p('');
139:
140: htp.bodyClose;

Line 137: htp.p('');

133: '/FNDICPYS.gif', cattributes => 'BORDER = NO align=absmiddle' ));
134: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PROCEED_TO_COPY');
135: htp.p('');
136: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs', FND_MESSAGE.GET);
137: htp.p('
');
138: htp.p('');
139:
140: htp.bodyClose;
141: htp.htmlClose;

Line 138: htp.p('');

134: FND_MESSAGE.SET_NAME('ICX', 'ICX_RQS_PROCEED_TO_COPY');
135: htp.p('');
136: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs', FND_MESSAGE.GET);
137: htp.p('
');
138: htp.p('');
139:
140: htp.bodyClose;
141: htp.htmlClose;
142:

Line 140: htp.bodyClose;

136: htp.anchor(v_dcdName || '/ICX_REQ_COPY_REQ.find_reqs', FND_MESSAGE.GET);
137: htp.p('
');
138: htp.p('');
139:
140: htp.bodyClose;
141: htp.htmlClose;
142:
143: END IF; /* validate session */
144:

Line 141: htp.htmlClose;

137: htp.p('');
138: htp.p('');
139:
140: htp.bodyClose;
141: htp.htmlClose;
142:
143: END IF; /* validate session */
144:
145: END welcome_page;

Line 305: htp.htmlOpen;

301: v_end_row := v_total_rows;
302: END IF;
303:
304: IF v_total_rows = 0 THEN
305: htp.htmlOpen;
306: htp.headOpen;
307: icx_util.copyright;
308: js.scriptOpen;
309: icx_admin_sig.help_win_script(v_help_url, v_language_code);

Line 306: htp.headOpen;

302: END IF;
303:
304: IF v_total_rows = 0 THEN
305: htp.htmlOpen;
306: htp.headOpen;
307: icx_util.copyright;
308: js.scriptOpen;
309: icx_admin_sig.help_win_script(v_help_url, v_language_code);
310: js.scriptClose;

Line 311: htp.title(ak_query_pkg.g_regions_table(0).name);

307: icx_util.copyright;
308: js.scriptOpen;
309: icx_admin_sig.help_win_script(v_help_url, v_language_code);
310: js.scriptClose;
311: htp.title(ak_query_pkg.g_regions_table(0).name);
312: htp.headClose;
313:
314: icx_admin_sig.toolbar(language_code => v_language_code,
315: disp_find => 'icx_req_copy_req.find_reqs');

Line 312: htp.headClose;

308: js.scriptOpen;
309: icx_admin_sig.help_win_script(v_help_url, v_language_code);
310: js.scriptClose;
311: htp.title(ak_query_pkg.g_regions_table(0).name);
312: htp.headClose;
313:
314: icx_admin_sig.toolbar(language_code => v_language_code,
315: disp_find => 'icx_req_copy_req.find_reqs');
316:

Line 319: htp.br;

315: disp_find => 'icx_req_copy_req.find_reqs');
316:
317: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
318: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
319: htp.br;
320: htp.tableOpen('BORDER=0');
321: htp.tableRowOpen;
322: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
323: htp.tableClose;

Line 320: htp.tableOpen('BORDER=0');

316:
317: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
318: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
319: htp.br;
320: htp.tableOpen('BORDER=0');
321: htp.tableRowOpen;
322: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
323: htp.tableClose;
324: htp.br;

Line 321: htp.tableRowOpen;

317: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
318: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
319: htp.br;
320: htp.tableOpen('BORDER=0');
321: htp.tableRowOpen;
322: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
323: htp.tableClose;
324: htp.br;
325: icx_admin_sig.footer;

Line 322: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');

318: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
319: htp.br;
320: htp.tableOpen('BORDER=0');
321: htp.tableRowOpen;
322: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
323: htp.tableClose;
324: htp.br;
325: icx_admin_sig.footer;
326:

Line 323: htp.tableClose;

319: htp.br;
320: htp.tableOpen('BORDER=0');
321: htp.tableRowOpen;
322: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
323: htp.tableClose;
324: htp.br;
325: icx_admin_sig.footer;
326:
327: ELSE

Line 324: htp.br;

320: htp.tableOpen('BORDER=0');
321: htp.tableRowOpen;
322: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
323: htp.tableClose;
324: htp.br;
325: icx_admin_sig.footer;
326:
327: ELSE
328: htp.htmlOpen;

Line 328: htp.htmlOpen;

324: htp.br;
325: icx_admin_sig.footer;
326:
327: ELSE
328: htp.htmlOpen;
329: htp.headOpen;
330: icx_util.copyright;
331:
332: js.scriptOpen;

Line 329: htp.headOpen;

325: icx_admin_sig.footer;
326:
327: ELSE
328: htp.htmlOpen;
329: htp.headOpen;
330: icx_util.copyright;
331:
332: js.scriptOpen;
333: icx_admin_sig.help_win_script(v_help_url, v_language_code);

Line 336: htp.title(ak_query_pkg.g_regions_table(0).name);

332: js.scriptOpen;
333: icx_admin_sig.help_win_script(v_help_url, v_language_code);
334: js.scriptClose;
335:
336: htp.title(ak_query_pkg.g_regions_table(0).name);
337: htp.headClose;
338:
339: icx_admin_sig.toolbar(language_code => v_language_code,
340: disp_find => 'icx_req_copy_req.find_reqs');

Line 337: htp.headClose;

333: icx_admin_sig.help_win_script(v_help_url, v_language_code);
334: js.scriptClose;
335:
336: htp.title(ak_query_pkg.g_regions_table(0).name);
337: htp.headClose;
338:
339: icx_admin_sig.toolbar(language_code => v_language_code,
340: disp_find => 'icx_req_copy_req.find_reqs');
341:

Line 343: htp.p('
');

339: icx_admin_sig.toolbar(language_code => v_language_code,
340: disp_find => 'icx_req_copy_req.find_reqs');
341:
342:
343: htp.p('');
344:
345:
346: -- Display Heading
347: htp.tableOpen('BORDER=0');

Line 347: htp.tableOpen('BORDER=0');

343: htp.p('');
344:
345:
346: -- Display Heading
347: htp.tableOpen('BORDER=0');
348: htp.tableRowOpen;
349: htp.tableData(cvalue => ''
350: || ak_query_pkg.g_regions_table(0).name
351: || '
',cattributes => 'VALIGN="MIDDLE"');

Line 348: htp.tableRowOpen;

344:
345:
346: -- Display Heading
347: htp.tableOpen('BORDER=0');
348: htp.tableRowOpen;
349: htp.tableData(cvalue => ''
350: || ak_query_pkg.g_regions_table(0).name
351: || '
',cattributes => 'VALIGN="MIDDLE"');
352: htp.tableRowClose;

Line 349: htp.tableData(cvalue => ''

345:
346: -- Display Heading
347: htp.tableOpen('BORDER=0');
348: htp.tableRowOpen;
349: htp.tableData(cvalue => ''
350: || ak_query_pkg.g_regions_table(0).name
351: || '
',cattributes => 'VALIGN="MIDDLE"');
352: htp.tableRowClose;
353: htp.tableClose;

Line 352: htp.tableRowClose;

348: htp.tableRowOpen;
349: htp.tableData(cvalue => ''
350: || ak_query_pkg.g_regions_table(0).name
351: || '
',cattributes => 'VALIGN="MIDDLE"');
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.br;
355:
356: IF(v_total_rows > 5)

Line 353: htp.tableClose;

349: htp.tableData(cvalue => ''
350: || ak_query_pkg.g_regions_table(0).name
351: || '
',cattributes => 'VALIGN="MIDDLE"');
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.br;
355:
356: IF(v_total_rows > 5)
357: THEN

Line 354: htp.br;

350: || ak_query_pkg.g_regions_table(0).name
351: || '
',cattributes => 'VALIGN="MIDDLE"');
352: htp.tableRowClose;
353: htp.tableClose;
354: htp.br;
355:
356: IF(v_total_rows > 5)
357: THEN
358: icx_on_utilities2.displaySetIcons(v_language_code,

Line 365: htp.br;

361: v_end_row,
362: v_encrypted_where,
363: v_query_size,
364: v_total_rows);
365: htp.br;
366: END IF; /* (v_total_rows > 5) */
367:
368: -- Print table header
369: htp.tableOpen('BORDER=2','','','', 'CELLPADDING=2');

Line 369: htp.tableOpen('BORDER=2','','','', 'CELLPADDING=2');

365: htp.br;
366: END IF; /* (v_total_rows > 5) */
367:
368: -- Print table header
369: htp.tableOpen('BORDER=2','','','', 'CELLPADDING=2');
370: htp.p('

' || ak_query_pkg.g_items_table(i).attribute_label_long);

372: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
373: IF ak_query_pkg.g_items_table(i).secured_column = 'F'
374: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' THEN
375:
376: htp.p('

' || ak_query_pkg.g_items_table(i).attribute_label_long);
377: htp.p('
' || ak_query_pkg.g_items_table(i).attribute_label_long);
377: htp.p('