[Home] [Help]
327: htp.p(' 328: 'VALUE="'||x_file_name|| '" SIZE="40">'||
329: l_search_document_URL);
Line 326: htp.p('');
322: --htp.tableRowOpen( cvalign => 'TOP' );
323: htp.tableRowOpen;
324: htp.p('
');
325: htp.p(' ');
326: htp.p('');
327: htp.p('
328: 'VALUE="'||x_file_name|| '" SIZE="40">'||
329: l_search_document_URL);
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
Line 327: htp.p('
323: htp.tableRowOpen;
324: htp.p('
');
325: htp.p(' ');
326: htp.p('');
327: htp.p('
328: 'VALUE="'||x_file_name|| '" SIZE="40">'||
329: l_search_document_URL);
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
331: cvalue=>x_file_name)|| l_search_document_URL,
Line 330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
326: htp.p('
');
327: htp.p('
328: 'VALUE="'||x_file_name|| '" SIZE="40">'||
329: l_search_document_URL);
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
331: cvalue=>x_file_name)|| l_search_document_URL,
332: calign => 'left');*/
333: htp.tableRowClose;
334: htp.tableClose;
Line 333: htp.tableRowClose;
329: l_search_document_URL);
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
331: cvalue=>x_file_name)|| l_search_document_URL,
332: calign => 'left');*/
333: htp.tableRowClose;
334: htp.tableClose;
335:
336: htp.formHidden ( cname =>'text', cvalue=>'');
337: htp.formHidden ( cname =>'url', cvalue=>'');
Line 334: htp.tableClose;
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
331: cvalue=>x_file_name)|| l_search_document_URL,
332: calign => 'left');*/
333: htp.tableRowClose;
334: htp.tableClose;
335:
336: htp.formHidden ( cname =>'text', cvalue=>'');
337: htp.formHidden ( cname =>'url', cvalue=>'');
338: end if;
Line 336: htp.formHidden ( cname =>'text', cvalue=>'');
332: calign => 'left');*/
333: htp.tableRowClose;
334: htp.tableClose;
335:
336: htp.formHidden ( cname =>'text', cvalue=>'');
337: htp.formHidden ( cname =>'url', cvalue=>'');
338: end if;
339:
340: end DocumentInformation;
Line 337: htp.formHidden ( cname =>'url', cvalue=>'');
333: htp.tableRowClose;
334: htp.tableClose;
335:
336: htp.formHidden ( cname =>'text', cvalue=>'');
337: htp.formHidden ( cname =>'url', cvalue=>'');
338: end if;
339:
340: end DocumentInformation;
341:
Line 409: htp.htmlOpen;
405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
407:
408: -- Call the procedure that prints header
409: htp.htmlOpen;
410: htp.headOpen;
411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
Line 410: htp.headOpen;
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
407:
408: -- Call the procedure that prints header
409: htp.htmlOpen;
410: htp.headOpen;
411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
414: -- Call the procedure that prints header
Line 412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
408: -- Call the procedure that prints header
409: htp.htmlOpen;
410: htp.headOpen;
411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
414: -- Call the procedure that prints header
415: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
416: cname => 'top_frame', cmarginheight=>'0',
Line 415: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
414: -- Call the procedure that prints header
415: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
416: cname => 'top_frame', cmarginheight=>'0',
417: cmarginwidth=> '0', cscrolling => 'NO',
418: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
419:
Line 421: htp.frame (csrc => l_dcdname ||
417: cmarginwidth=> '0', cscrolling => 'NO',
418: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
419:
420: -- Print The Body of the Add Attachment page.
421: htp.frame (csrc => l_dcdname ||
422: '/fnd_webattch.PrintUpdateAttachment?attached_document_id='||
423: l_attached_document_id ||
424: '&'||'package_name='|| l_packagename ||
425: '&'||'function_name='||l_function_name ||
Line 439: htp.framesetclose;
435: cmarginheight=>'0', cmarginwidth=> '10', cscrolling => 'AUTO',
436: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
437:
438: -- Close the frameset.
439: htp.framesetclose;
440:
441: end UpdateAttachment;
442:
443:
Line 578: htp.htmlOpen;
574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
576:
577: -- Call the procedure that prints header
578: htp.htmlOpen;
579: htp.headOpen;
580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
Line 579: htp.headOpen;
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
576:
577: -- Call the procedure that prints header
578: htp.htmlOpen;
579: htp.headOpen;
580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
583: -- Call the procedure that prints header
Line 581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
577: -- Call the procedure that prints header
578: htp.htmlOpen;
579: htp.headOpen;
580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
583: -- Call the procedure that prints header
584: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
585: cname => 'tooolbar_frame', cmarginheight=>'0',
Line 584: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
583: -- Call the procedure that prints header
584: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
585: cname => 'tooolbar_frame', cmarginheight=>'0',
586: cmarginwidth=> '0', cscrolling => 'NO',
587: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
588:
Line 590: htp.frame (csrc => l_dcdname ||
586: cmarginwidth=> '0', cscrolling => 'NO',
587: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
588:
589: -- Print The Body of the Add Attachment page.
590: htp.frame (csrc => l_dcdname ||
591: '/fnd_webattch.PrintAddAttachment?package_name='||
592: l_packagename ||
593: '&'||'function_name='||l_function_name ||
594: '&'||'entity_name='||l_entity_name ||
Line 607: htp.framesetclose;
603: cmarginheight=>'0', cmarginwidth=> '10', cscrolling => 'AUTO',
604: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
605:
606: -- Close the frameset.
607: htp.framesetclose;
608:
609: end AddAttachment;
610:
611: -- ViewTextDocument
Line 772: -- This htp call is required for webDB implementation.
768: Add_Attachment(seq_num, category_id, document_description, datatype_id,
769: text, l_file_name, url, function_name, entity_name, pk1_value,
770: pk2_value, pk3_value, pk4_value, pk5_value, l_media_id, user_id);
771:
772: -- This htp call is required for webDB implementation.
773: htp.p('');
774:
775: END;
776:
Line 773: htp.p('');
769: text, l_file_name, url, function_name, entity_name, pk1_value,
770: pk2_value, pk3_value, pk4_value, pk5_value, l_media_id, user_id);
771:
772: -- This htp call is required for webDB implementation.
773: htp.p('');
774:
775: END;
776:
777: -- Add_Attachment
Line 1018: -- This htp call is required for webDB implementation.
1014: l_file_name, url, attached_document_id, datatype_id, function_name,
1015: entity_name, pk1_value, pk2_value, pk3_value, pk4_value, pk5_value,
1016: l_media_id, l_user_id);
1017:
1018: -- This htp call is required for webDB implementation.
1019: htp.p('');
1020:
1021: END;
1022:
Line 1019: htp.p('');
1015: entity_name, pk1_value, pk2_value, pk3_value, pk4_value, pk5_value,
1016: l_media_id, l_user_id);
1017:
1018: -- This htp call is required for webDB implementation.
1019: htp.p('');
1020:
1021: END;
1022:
1023: -- Update_Attachment
Line 1273: htp.htmlOpen;
1269: if NOT (icx_sec.ValidateSession(null)) then
1270: return;
1271: end if;
1272:
1273: htp.htmlOpen;
1274: htp.bodyOpen;
1275: -- Body background color.
1276: htp.p('
');
1277:
Line 1274: htp.bodyOpen;
1270: return;
1271: end if;
1272:
1273: htp.htmlOpen;
1274: htp.bodyOpen;
1275: -- Body background color.
1276: htp.p('
');
1277:
1278: icx_admin_sig.toolbar(language_code => Header.Lang);
Line 1276: htp.p('');
1272:
1273: htp.htmlOpen;
1274: htp.bodyOpen;
1275: -- Body background color.
1276: htp.p('');
1277:
1278: icx_admin_sig.toolbar(language_code => Header.Lang);
1279:
1280: -- Style sheet declaration.
Line 1281: htp.p('');
1277:
1278: icx_admin_sig.toolbar(language_code => Header.Lang);
1279:
1280: -- Style sheet declaration.
1281: htp.p('');
1282:
1283: htp.bodyClose;
1284: htp.htmlClose;
1285:
Line 1283: htp.bodyClose;
1279:
1280: -- Style sheet declaration.
1281: htp.p('');
1282:
1283: htp.bodyClose;
1284: htp.htmlClose;
1285:
1286: end Header;
1287:
Line 1284: htp.htmlClose;
1280: -- Style sheet declaration.
1281: htp.p('');
1282:
1283: htp.bodyClose;
1284: htp.htmlClose;
1285:
1286: end Header;
1287:
1288: -- PrintSummary
Line 1367: htp.htmlOpen;
1363:
1364: -- Set the title
1365: l_title := fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-TITLE');
1366:
1367: htp.htmlOpen;
1368: htp.headOpen;
1369: htp.p( '' );
1381: help_win = window.open('||
1382: fnd_help.get_url('ICX','@T_ATTACH')||
1383: ', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,'||
1384: 'height=250")}');
1385: htp.print( '' );
1386: htp.title(l_title);
1387:
1388: -- Add the java script to the header to open the dm window for
1389: -- any DM function that is executed.
Line 1386: htp.title(l_title);
1382: fnd_help.get_url('ICX','@T_ATTACH')||
1383: ', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,'||
1384: 'height=250")}');
1385: htp.print( '' );
1386: htp.title(l_title);
1387:
1388: -- Add the java script to the header to open the dm window for
1389: -- any DM function that is executed.
1390: fnd_document_management.get_open_dm_attach_window;
Line 1396: htp.p('');
1392: -- Add java script to the header to open display window
1393: fnd_document_management.get_open_dm_display_window;
1394:
1395: -- Style sheet declaration.
1396: htp.p('');
1397:
1398: htp.headClose;
1399: htp.bodyOpen;
1400:
Line 1398: htp.headClose;
1394:
1395: -- Style sheet declaration.
1396: htp.p('');
1397:
1398: htp.headClose;
1399: htp.bodyOpen;
1400:
1401: -- Body background color.
1402: htp.p('
');
Line 1399: htp.bodyOpen;
1395: -- Style sheet declaration.
1396: htp.p('');
1397:
1398: htp.headClose;
1399: htp.bodyOpen;
1400:
1401: -- Body background color.
1402: htp.p('
');
1403: htp.br;
Line 1402: htp.p('');
1398: htp.headClose;
1399: htp.bodyOpen;
1400:
1401: -- Body background color.
1402: htp.p('');
1403: htp.br;
1404:
1405:
1406: -- Process the cursor
Line 1403: htp.br;
1399: htp.bodyOpen;
1400:
1401: -- Body background color.
1402: htp.p('
');
1403: htp.br;
1404:
1405:
1406: -- Process the cursor
1407: open al_cursor;
Line 1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1407: open al_cursor;
1408: fetch al_cursor into atlstrec;
1409: if al_cursor%NOTFOUND then
1410: close al_cursor;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
Line 1412: htp.br;
1408: fetch al_cursor into atlstrec;
1409: if al_cursor%NOTFOUND then
1410: close al_cursor;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
Line 1413: htp.print( '' );
1409: if al_cursor%NOTFOUND then
1410: close al_cursor;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1417: -- Branch to the bottom header
Line 1414: htp.br;
1410: close al_cursor;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1417: -- Branch to the bottom header
1418: GOTO bottom_header;
Line 1415: htp.br;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1417: -- Branch to the bottom header
1418: GOTO bottom_header;
1419: end if;
Line 1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1417: -- Branch to the bottom header
1418: GOTO bottom_header;
1419: end if;
1420:
Line 1422: htp.p('
');
1418: GOTO bottom_header;
1419: end if;
1420:
1421: -- Create a header.
1422: htp.p('');
1423: htp.p('');
1424: htp.p('. ');
1425: htp.p(''||
1426: fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-HEADING')
Line 1423: htp.p('');
1419: end if;
1420:
1421: -- Create a header.
1422: htp.p('
');
1423: htp.p('');
1424: htp.p('. ');
1425: htp.p(''||
1426: fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-HEADING')
1427: ||' : '||atlstrec.user_entity_name||' ');
Line 1424: htp.p('. ');
1420:
1421: -- Create a header.
1422: htp.p('
');
1423: htp.p('');
1424: htp.p('. ');
1425: htp.p(''||
1426: fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-HEADING')
1427: ||' : '||atlstrec.user_entity_name||' ');
1428: htp.tableRowClose;
Line 1425: htp.p(''||
1421: -- Create a header.
1422: htp.p('
');
1423: htp.p('');
1424: htp.p('. ');
1425: htp.p(''||
1426: fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-HEADING')
1427: ||' : '||atlstrec.user_entity_name||' ');
1428: htp.tableRowClose;
1429: htp.tableClose;
Line 1428: htp.tableRowClose;
1424: htp.p('
. ');
1425: htp.p(''||
1426: fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-HEADING')
1427: ||' : '||atlstrec.user_entity_name||' ');
1428: htp.tableRowClose;
1429: htp.tableClose;
1430: htp.br;
1431:
1432: -- There are some attachments for the entity. Construct the page.
Line 1429: htp.tableClose;
1425: htp.p('
'||
1426: fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-HEADING')
1427: ||' : '||atlstrec.user_entity_name||' ');
1428: htp.tableRowClose;
1429: htp.tableClose;
1430: htp.br;
1431:
1432: -- There are some attachments for the entity. Construct the page.
1433: htp.p('
Line 1430: htp.br;
1426: fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-HEADING')
1427: ||' : '||atlstrec.user_entity_name||'');
1428: htp.tableRowClose;
1429: htp.tableClose;
1430: htp.br;
1431:
1432: -- There are some attachments for the entity. Construct the page.
1433: htp.p('
1434: 'cellspacing=0 border=0>');
Line 1433: htp.p('
1429: htp.tableClose;
1430: htp.br;
1431:
1432: -- There are some attachments for the entity. Construct the page.
1433: htp.p('
1434: 'cellspacing=0 border=0>');
1435: htp.p('');
1436:
1437: htp.p('');
Line 1435: htp.p('');
1431:
1432: -- There are some attachments for the entity. Construct the page.
1433: htp.p('
1434: 'cellspacing=0 border=0>');
1435: htp.p('');
1436:
1437: htp.p('');
1438: htp.p('');
1439:
Line 1437: htp.p('
');
1433: htp.p('
1434: 'cellspacing=0 border=0>');
1435: htp.p('');
1436:
1437: htp.p('');
1438: htp.p('');
1439:
1440: --Top Column Headings
1441: htp.p(' '||
Line 1438: htp.p('');
1434: 'cellspacing=0 border=0>');
1435: htp.p('
');
1436:
1437: htp.p('');
1438: htp.p('');
1439:
1440: --Top Column Headings
1441: htp.p(' '||
1442: ''||
Line 1441: htp.p(' '||
1437: htp.p('
');
1438: htp.p('');
1439:
1440: --Top Column Headings
1441: htp.p(' '||
1442: ''||
1443: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-DETAILS')||
1444: ' ');
1445: htp.p(' '||
Line 1445: htp.p(' '||
1441: htp.p('
'||
1442: ''||
1443: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-DETAILS')||
1444: ' ');
1445: htp.p(' '||
1446: ''||
1447: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-SEQUENCE')||
1448: ' ');
1449: htp.p(' '||
Line 1449: htp.p(' '||
1445: htp.p('
'||
1446: ''||
1447: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-SEQUENCE')||
1448: ' ');
1449: htp.p(' '||
1450: ''||
1451: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-DESCRIPTI')||
1452: ' ');
1453: htp.p(' '||
Line 1453: htp.p(' '||
1449: htp.p('
'||
1450: ''||
1451: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-DESCRIPTI')||
1452: ' ');
1453: htp.p(' '||
1454: ''||
1455: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-CATEGORY')||
1456: ' ');
1457: htp.p(' '||
Line 1457: htp.p(' '||
1453: htp.p('
'||
1454: ''||
1455: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-CATEGORY')||
1456: ' ');
1457: htp.p(' '||
1458: ''||
1459: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-DATATYPE')||
1460: ' ');
1461: if (query_only <> 'Y') then
Line 1462: htp.p(' '||
1458: ''||
1459: fnd_message.get_string('FND','FND-WEBATCH-DOCUMENT-DATATYPE')||
1460: '
');
1461: if (query_only <> 'Y') then
1462: htp.p(' '||
1463: ''||
1464: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT')||
1465: ' ');
1466: htp.p(' '||
Line 1466: htp.p(' '||
1462: htp.p('
'||
1463: ''||
1464: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT')||
1465: ' ');
1466: htp.p(' '||
1467: ''||
1468: fnd_message.get_string('FND','FND-WEBATCH-REMOVE-ATCHMT')||
1469: ' ');
1470: end if;
Line 1477: htp.p('');
1473: loop
1474:
1475: -- Make altenate rows with different background.
1476: if (round(j/2) = j/2) then
1477: htp.p('');
1478: else
1479: htp.p(' ');
1480: end if;
1481:
Line 1479: htp.p('');
1475: -- Make altenate rows with different background.
1476: if (round(j/2) = j/2) then
1477: htp.p('
');
1478: else
1479: htp.p('');
1480: end if;
1481:
1482: --Construct the one html line per row fetched.
1483: if (atlstrec.datatype_id = 6) then
Line 1484: htp.p(''||
1480: end if;
1481:
1482: --Construct the one html line per row fetched.
1483: if (atlstrec.datatype_id = 6) then
1484: htp.p('
'||
1485: htf.anchor2(owa_util.get_owa_service_path
1486: ||'fnd_webattch.ViewFileDocument?attached_document_id='
1487: ||icx_call.encrypt2(to_char(atlstrec.attached_document_id)),
1488: htf.img2( '/OA_MEDIA/FNDIITMD.gif',
Line 1494: htp.p(''||
1490: ||' '||atlstrec.datatype_name,
1491: cattributes => 'border=no'),
1492: ctarget=>'document_frame') ||'
');
1493: elsif(atlstrec.datatype_id = 5) then
1494: htp.p(''||
1495: htf.anchor2(atlstrec.file_name,
1496: htf.img2( '/OA_MEDIA/FNDIITMD.gif',
1497: calt => fnd_message.get_string('FND','HE_VIEW')
1498: ||' '||atlstrec.datatype_name,
Line 1509: htp.p(''||
1505: l_username,
1506: atlstrec.file_name,
1507: FALSE,
1508: link_string);
1509: htp.p('
'||
1510: htf.anchor2(link_string, htf.img2( '/OA_MEDIA/FNDIITMD.gif',
1511: calt => fnd_message.get_string('FND','HE_VIEW')
1512: ||' '||atlstrec.datatype_name,
1513: cattributes => 'border=no'),
Line 1518: htp.p(''||
1514: ctarget=>'document_frame')
1515: ||'
');
1516: elsif(atlstrec.datatype_id = 1) OR
1517: (atlstrec.datatype_id = 2) then
1518: htp.p(''||
1519: htf.anchor2(owa_util.get_owa_service_path|| package_name
1520: ||'.ViewTextDocument?attached_document_id='||
1521: icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1522: ||'&'||'function_name='||icx_call.encrypt2(function_name)
Line 1538: htp.p(''|| atlstrec.seq_num|| ' ');
1534: cattributes => 'border=no'),
1535: ctarget=>'document_frame')
1536: ||'
');
1537: end if;
1538: htp.p(''|| atlstrec.seq_num|| ' ');
1539: htp.p(''|| atlstrec.document_description||
1540: ' ');
1541: htp.p(''|| atlstrec.category_description ||
1542: ' ');
Line 1539: htp.p(''|| atlstrec.document_description||
1535: ctarget=>'document_frame')
1536: ||'
');
1537: end if;
1538: htp.p(''|| atlstrec.seq_num|| ' ');
1539: htp.p(''|| atlstrec.document_description||
1540: ' ');
1541: htp.p(''|| atlstrec.category_description ||
1542: ' ');
1543: htp.p(''|| atlstrec.datatype_name|| ' ');
Line 1541: htp.p(''|| atlstrec.category_description ||
1537: end if;
1538: htp.p('
'|| atlstrec.seq_num|| ' ');
1539: htp.p(''|| atlstrec.document_description||
1540: ' ');
1541: htp.p(''|| atlstrec.category_description ||
1542: ' ');
1543: htp.p(''|| atlstrec.datatype_name|| ' ');
1544:
1545: if (atlstrec.usage_type <> 'S') and
Line 1543: htp.p(''|| atlstrec.datatype_name|| ' ');
1539: htp.p('
'|| atlstrec.document_description||
1540: ' ');
1541: htp.p(''|| atlstrec.category_description ||
1542: ' ');
1543: htp.p(''|| atlstrec.datatype_name|| ' ');
1544:
1545: if (atlstrec.usage_type <> 'S') and
1546: (query_only <> 'Y') then
1547: htp.p(''||
Line 1547: htp.p(''||
1543: htp.p('
'|| atlstrec.datatype_name|| ' ');
1544:
1545: if (atlstrec.usage_type <> 'S') and
1546: (query_only <> 'Y') then
1547: htp.p(''||
1548: htf.anchor2(owa_util.get_owa_service_path|| package_name
1549: ||'.UpdateAttachment?attached_document_id='||
1550: icx_call.encrypt2(to_char(atlstrec.attached_document_id))
1551: ||'&'||'function_name='||icx_call.encrypt2(function_name)
Line 1569: htp.p(''||
1565: ||'
');
1566: end if;
1567:
1568: if (query_only <> 'Y' ) then
1569: htp.p(''||
1570: htf.anchor2('javascript:delete_attachment('''
1571: || owa_util.get_owa_service_path
1572: ||'fnd_webattch.DeleteAttachment?attached_document_id='
1573: ||icx_call.encrypt2(to_char(atlstrec.attached_document_id))
Line 1588: htp.tableRowClose;
1584: calign => 'CENTER', calt => '''Delete Attachment''',
1585: cattributes => 'border=yes width=17 height=16'))
1586: ||'
');
1587: end if;
1588: htp.tableRowClose;
1589:
1590: j := j + 1 ;
1591:
1592: fetch al_cursor into atlstrec;
Line 1597: htp.tableClose;
1593: exit when al_cursor%NOTFOUND;
1594: end loop;
1595: close al_cursor;
1596:
1597: htp.tableClose;
1598: htp.p('
');
1599: htp.p('
');
1600: htp.p('
');
1601:
Line 1598: htp.p('
');
1594: end loop;
1595: close al_cursor;
1596:
1597: htp.tableClose;
1598: htp.p('
');
1599: htp.p(' ');
1600: htp.p('
');
1601:
1602: <>
Line 1599: htp.p('
1595: close al_cursor;
1596:
1597: htp.tableClose;
1598: htp.p('
');
1599: htp.p(' ');
1600: htp.p('
');
1601:
1602: <>
1603: htp.br;
Line 1600: htp.p('
');
1596:
1597: htp.tableClose;
1598: htp.p('');
1599: htp.p('');
1600: htp.p('
');
1601:
1602: <>
1603: htp.br;
1604: htp.p ('');
Line 1603: htp.br;
1599: htp.p('
');
1600: htp.p('
');
1601:
1602: <>
1603: htp.br;
1604: htp.p ('');
1605: if (query_only <> 'Y' ) then
1606: -- Create buttons for adding and back links.
1607: htp.p('');
Line 1607: htp.p('');
1609: htp.p('');
1610: htp.p('');
1611: htp.p('');
Line 1609: htp.p('');
1605: if (query_only <> 'Y' ) then
1606: -- Create buttons for adding and back links.
1607: htp.p('');
1609: htp.p('
');
1610: htp.p('');
1611: htp.p('');
1612: htp.p('');
1613: htp.p('
Line 1610: htp.p('
');
1606: -- Create buttons for adding and back links.
1607: htp.p('');
1609: htp.p('
');
1610: htp.p('');
1611: htp.p('');
1612: htp.p('');
1613: htp.p('
1614: htp.p('
Line 1611: htp.p('');
1607: htp.p('');
1609: htp.p('
');
1610: htp.p('');
1611: htp.p('');
1612: htp.p('');
1613: htp.p('
1614: htp.p('
1615: htp.p('
Line 1612: htp.p('');
1608: ' row defines the edges and tops-->');
1609: htp.p('
');
1610: htp.p('');
1611: htp.p('');
1612: htp.p('');
1613: htp.p('
1614: htp.p('
1615: htp.p('
1616: htp.p(' ');
Line 1613: htp.p('
1609: htp.p('
');
1610: htp.p('');
1611: htp.p('');
1612: htp.p('');
1613: htp.p('
1614: htp.p('
1615: htp.p('
1616: htp.p(' ');
1617: htp.p('
Line 1614: htp.p('
1610: htp.p('
');
1611: htp.p('');
1612: htp.p('');
1613: htp.p('
1614: htp.p('
1615: htp.p('
1616: htp.p(' ');
1617: htp.p('
1618:
Line 1615: htp.p('
1611: htp.p('
');
1612: htp.p('');
1613: htp.p('
1614: htp.p('
1615: htp.p('
1616: htp.p(' ');
1617: htp.p('
1618:
1619: htp.p('');
Line 1616: htp.p(' ');
1612: htp.p('');
1613: htp.p('
1614: htp.p('
1615: htp.p('
1616: htp.p(' ');
1617: htp.p('
1618:
1619: htp.p('');
1620: htp.p('
Line 1617: htp.p('
1613: htp.p('
1614: htp.p('
1615: htp.p('
1616: htp.p(' ');
1617: htp.p('
1618:
1619: htp.p('');
1620: htp.p('
1621: htp.p('
Line 1619: htp.p('');
1615: htp.p('
1616: htp.p(' ');
1617: htp.p('
1618:
1619: htp.p('');
1620: htp.p('
1621: htp.p('
1622: htp.p('
1623: htp.p(' ');
Line 1620: htp.p('
1616: htp.p(' ');
1617: htp.p('
1618:
1619: htp.p('');
1620: htp.p('
1621: htp.p('
1622: htp.p('
1623: htp.p('');
1624: htp.p('');
Line 1621: htp.p('
1617: htp.p('
1618:
1619: htp.p('');
1620: htp.p('
1621: htp.p('
1622: htp.p('
1623: htp.p(' ');
1624: htp.p('');
1625: htp.p('');
Line 1622: htp.p('
1618:
1619: htp.p('');
1620: htp.p('
1621: htp.p('
1622: htp.p('
1623: htp.p(' ');
1624: htp.p('');
1625: htp.p('');
1626: htp.p('
Line 1623: htp.p('
');
1619: htp.p('');
1620: htp.p('
1621: htp.p('
1622: htp.p('
1623: htp.p('');
1624: htp.p('');
1625: htp.p('');
1626: htp.p('
1627: htp.p('
Line 1624: htp.p('');
1620: htp.p('
1621: htp.p('
1622: htp.p('
1623: htp.p(' ');
1624: htp.p('');
1625: htp.p('');
1626: htp.p('
1627: htp.p('
1628: htp.p('
Line 1625: htp.p('');
1621: htp.p('
1622: htp.p('
1623: htp.p(' ');
1624: htp.p('');
1625: htp.p('');
1626: htp.p('
1627: htp.p('
1628: htp.p('
1629: htp.p(' ');
Line 1626: htp.p('
1622: htp.p('
1623: htp.p(' ');
1624: htp.p('');
1625: htp.p('');
1626: htp.p('
1627: htp.p('
1628: htp.p('
1629: htp.p(' ');
1630: htp.p('');
Line 1627: htp.p('
1623: htp.p('
');
1624: htp.p('');
1625: htp.p('');
1626: htp.p('
1627: htp.p('
1628: htp.p('
1629: htp.p(' ');
1630: htp.p('');
1631: htp.p('');
Line 1628: htp.p('
1624: htp.p('
');
1625: htp.p('');
1626: htp.p('
1627: htp.p('
1628: htp.p('
1629: htp.p(' ');
1630: htp.p('');
1631: htp.p('');
1632: htp.p('
1627: htp.p('
1628: htp.p('
1629: htp.p(' ');
1630: htp.p('');
1631: htp.p('');
1632: htp.p('
1641:%20%20%20%20%20%20%20%20%20||'&'||'from_url='||icx_call.encrypt2(replace(from_url,'&','%26'))
1642:%20%20%20%20%20%20%20%20%20||'&'||'query_only='||icx_call.encrypt2(query_only)
1643:%20||'"target="_parent">'
1644: ||fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-ADD'));
1645: htp.p('');
1646: htp.p('
'
1648: || fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-EXIT'));
1649: htp.p(' ');
Line 1646: htp.p(''
1644: ||fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-ADD'));
1645: htp.p(' ');
1646: htp.p(''
1648: || fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-EXIT'));
1649: htp.p(' ');
1650: htp.p('');
Line 1649: htp.p('');
1645: htp.p('');
1646: htp.p('
'
1648: || fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-EXIT'));
1649: htp.p(' ');
1650: htp.p('');
1651: htp.p(' ');
1652:
1653: htp.p('');
Line 1650: htp.p('');
1646: htp.p('
'
1648: || fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-EXIT'));
1649: htp.p(' ');
1650: htp.p('');
1651: htp.p(' ');
1652:
1653: htp.p('');
1654: htp.p('
Line 1651: htp.p('
');
1647: || from_url|| '" target="_parent" >'
1648: || fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-EXIT'));
1649: htp.p('');
1650: htp.p('');
1651: htp.p('');
1652:
1653: htp.p('
');
1654: htp.p('
1655: htp.p('
Line 1653: htp.p('');
1649: htp.p('');
1650: htp.p('');
1651: htp.p('
');
1652:
1653: htp.p('');
1654: htp.p('
1655: htp.p('
1656: htp.p('
1657: htp.p(' ');
Line 1654: htp.p('
1650: htp.p('');
1651: htp.p('
');
1652:
1653: htp.p('');
1654: htp.p('
1655: htp.p('
1656: htp.p('
1657: htp.p(' ');
1658: htp.p('');
Line 1655: htp.p('
1651: htp.p('
');
1652:
1653: htp.p('');
1654: htp.p('
1655: htp.p('
1656: htp.p('
1657: htp.p(' ');
1658: htp.p('');
1659: htp.p('
Line 1656: htp.p('
1652:
1653: htp.p('
');
1654: htp.p('
1655: htp.p('
1656: htp.p('
1657: htp.p(' ');
1658: htp.p('');
1659: htp.p('
1660: htp.p('
Line 1657: htp.p('
');
1653: htp.p('
');
1654: htp.p('
1655: htp.p('
1656: htp.p('
1657: htp.p(' ');
1658: htp.p('');
1659: htp.p('
1660: htp.p('
1661: htp.p('
Line 1658: htp.p('');
1654: htp.p('
1655: htp.p('
1656: htp.p('
1657: htp.p(' ');
1658: htp.p('');
1659: htp.p('
1660: htp.p('
1661: htp.p('
1662: htp.p(' ');
Line 1659: htp.p('
1655: htp.p('
1656: htp.p('
1657: htp.p(' ');
1658: htp.p('');
1659: htp.p('
1660: htp.p('
1661: htp.p('
1662: htp.p(' ');
1663: htp.p('
');
Line 1660: htp.p('
1656: htp.p('
1657: htp.p(' ');
1658: htp.p('');
1659: htp.p('
1660: htp.p('
1661: htp.p('
1662: htp.p(' ');
1663: htp.p('
');
1664: else
Line 1661: htp.p('
1657: htp.p('
');
1658: htp.p('');
1659: htp.p('
1660: htp.p('
1661: htp.p('
1662: htp.p(' ');
1663: htp.p('
');
1664: else
1665: htp.p('');
Line 1663: htp.p('
');
1659: htp.p('
1660: htp.p('
1661: htp.p('
1662: htp.p(' ');
1663: htp.p('
');
1664: else
1665: htp.p('');
1667: htp.p(' ');
Line 1665: htp.p('');
1667: htp.p('');
1668: htp.p('');
1669: htp.p('');
Line 1667: htp.p('');
1663: htp.p('
');
1664: else
1665: htp.p('');
1667: htp.p(' ');
1668: htp.p('');
1669: htp.p('');
1670: htp.p('');
1671: htp.p('
Line 1668: htp.p('
');
1664: else
1665: htp.p('');
1667: htp.p('
');
1668: htp.p('');
1669: htp.p('');
1670: htp.p('');
1671: htp.p('
1672: htp.p('
Line 1669: htp.p('');
1665: htp.p('');
1667: htp.p('
');
1668: htp.p('');
1669: htp.p('');
1670: htp.p('');
1671: htp.p('
1672: htp.p('
1673: htp.p('
Line 1670: htp.p('');
1666: ' row defines the edges and tops-->');
1667: htp.p('
');
1668: htp.p('');
1669: htp.p('');
1670: htp.p('');
1671: htp.p('
1672: htp.p('
1673: htp.p('
1674:
Line 1671: htp.p('
1667: htp.p('
');
1668: htp.p('
1696: end if;
Line 1693: htp.p('
1689:
1690: htp.p('
');
1691: htp.p('
1692: htp.p('
1693: htp.p('
1694: htp.p(' ');
1695: htp.p('
');
1696: end if;
1697:
Line 1694: htp.p('
');
1690: htp.p('
');
1691: htp.p('
1692: htp.p('
1693: htp.p('
1694: htp.p(' ');
1695: htp.p('
');
1696: end if;
1697:
1698: htp.bodyClose;
Line 1695: htp.p('
');
1691: htp.p('
1692: htp.p('
1693: htp.p('
1694: htp.p('');
1695: htp.p('
');
1696: end if;
1697:
1698: htp.bodyClose;
1699: htp.htmlClose;
Line 1698: htp.bodyClose;
1694: htp.p('
');
1695: htp.p('
');
1696: end if;
1697:
1698: htp.bodyClose;
1699: htp.htmlClose;
1700:
1701: exception
1702: when others then
Line 1699: htp.htmlClose;
1695: htp.p('
');
1696: end if;
1697:
1698: htp.bodyClose;
1699: htp.htmlClose;
1700:
1701: exception
1702: when others then
1703: rollback;
Line 1786: htp.bodyClose;
1782: l_html_text := substrb(replace(l_text, fnd_webattch.g_chr_newline,
1783: '
'||fnd_webattch.g_chr_newline),
1784: 1, 32000);
1785:
1786: htp.bodyClose;
1787: htp.htmlClose;
1788: htp.p('
');
1789:
1790: -- Display the text
Line 1787: htp.htmlClose;
1783: '
'||fnd_webattch.g_chr_newline),
1784: 1, 32000);
1785:
1786: htp.bodyClose;
1787: htp.htmlClose;
1788: htp.p('
');
1789:
1790: -- Display the text
1791: htp.formOpen('','','','','NAME="displaytext"');
Line 1788: htp.p('');
1784: 1, 32000);
1785:
1786: htp.bodyClose;
1787: htp.htmlClose;
1788: htp.p('');
1789:
1790: -- Display the text
1791: htp.formOpen('','','','','NAME="displaytext"');
1792: htp.tableOpen( cattributes => ' border=0 cellpadding=2 cellspacing=0' );
Line 1791: htp.formOpen('','','','','NAME="displaytext"');
1787: htp.htmlClose;
1788: htp.p('
');
1789:
1790: -- Display the text
1791: htp.formOpen('','','','','NAME="displaytext"');
1792: htp.tableOpen( cattributes => ' border=0 cellpadding=2 cellspacing=0' );
1793: htp.tableRowOpen;
1794: htp.p('');
1795: htp.p(' ');
Line 1792: htp.tableOpen( cattributes => ' border=0 cellpadding=2 cellspacing=0' );
1788: htp.p('
');
1789:
1790: -- Display the text
1791: htp.formOpen('','','','','NAME="displaytext"');
1792: htp.tableOpen( cattributes => ' border=0 cellpadding=2 cellspacing=0' );
1793: htp.tableRowOpen;
1794: htp.p('');
1795: htp.p(' ');
1796: htp.tableRowClose;
Line 1793: htp.tableRowOpen;
1789:
1790: -- Display the text
1791: htp.formOpen('','','','','NAME="displaytext"');
1792: htp.tableOpen( cattributes => ' border=0 cellpadding=2 cellspacing=0' );
1793: htp.tableRowOpen;
1794: htp.p('
');
1795: htp.p(' ');
1796: htp.tableRowClose;
1797: htp.tableRowOpen;
Line 1794: htp.p('');
1790: -- Display the text
1791: htp.formOpen('','','','','NAME="displaytext"');
1792: htp.tableOpen( cattributes => ' border=0 cellpadding=2 cellspacing=0' );
1793: htp.tableRowOpen;
1794: htp.p('
');
1795: htp.p(' ');
1796: htp.tableRowClose;
1797: htp.tableRowOpen;
1798: htp.tableData( l_html_text);
Line 1795: htp.p('');
1791: htp.formOpen('','','','','NAME="displaytext"');
1792: htp.tableOpen( cattributes => ' border=0 cellpadding=2 cellspacing=0' );
1793: htp.tableRowOpen;
1794: htp.p('
');
1795: htp.p(' ');
1796: htp.tableRowClose;
1797: htp.tableRowOpen;
1798: htp.tableData( l_html_text);
1799: htp.tableRowClose;
Line 1796: htp.tableRowClose;
1792: htp.tableOpen( cattributes => ' border=0 cellpadding=2 cellspacing=0' );
1793: htp.tableRowOpen;
1794: htp.p('
');
1795: htp.p(' ');
1796: htp.tableRowClose;
1797: htp.tableRowOpen;
1798: htp.tableData( l_html_text);
1799: htp.tableRowClose;
1800: htp.tableClose;
Line 1797: htp.tableRowOpen;
1793: htp.tableRowOpen;
1794: htp.p('
');
1795: htp.p(' ');
1796: htp.tableRowClose;
1797: htp.tableRowOpen;
1798: htp.tableData( l_html_text);
1799: htp.tableRowClose;
1800: htp.tableClose;
1801:
Line 1798: htp.tableData( l_html_text);
1794: htp.p('
');
1795: htp.p(' ');
1796: htp.tableRowClose;
1797: htp.tableRowOpen;
1798: htp.tableData( l_html_text);
1799: htp.tableRowClose;
1800: htp.tableClose;
1801:
1802: htp.formClose;
Line 1799: htp.tableRowClose;
1795: htp.p('');
1796: htp.tableRowClose;
1797: htp.tableRowOpen;
1798: htp.tableData( l_html_text);
1799: htp.tableRowClose;
1800: htp.tableClose;
1801:
1802: htp.formClose;
1803: htp.bodyClose;
Line 1800: htp.tableClose;
1796: htp.tableRowClose;
1797: htp.tableRowOpen;
1798: htp.tableData( l_html_text);
1799: htp.tableRowClose;
1800: htp.tableClose;
1801:
1802: htp.formClose;
1803: htp.bodyClose;
1804: htp.htmlClose;
Line 1802: htp.formClose;
1798: htp.tableData( l_html_text);
1799: htp.tableRowClose;
1800: htp.tableClose;
1801:
1802: htp.formClose;
1803: htp.bodyClose;
1804: htp.htmlClose;
1805:
1806: exception
Line 1803: htp.bodyClose;
1799: htp.tableRowClose;
1800: htp.tableClose;
1801:
1802: htp.formClose;
1803: htp.bodyClose;
1804: htp.htmlClose;
1805:
1806: exception
1807:
Line 1804: htp.htmlClose;
1800: htp.tableClose;
1801:
1802: htp.formClose;
1803: htp.bodyClose;
1804: htp.htmlClose;
1805:
1806: exception
1807:
1808: when NO_DATA_FOUND then
Line 1809: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING'));
1805:
1806: exception
1807:
1808: when NO_DATA_FOUND then
1809: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING'));
1810: htp.bodyClose;
1811: htp.htmlClose;
1812:
1813: end PrintTextDocument;
Line 1810: htp.bodyClose;
1806: exception
1807:
1808: when NO_DATA_FOUND then
1809: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING'));
1810: htp.bodyClose;
1811: htp.htmlClose;
1812:
1813: end PrintTextDocument;
1814:
Line 1811: htp.htmlClose;
1807:
1808: when NO_DATA_FOUND then
1809: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING'));
1810: htp.bodyClose;
1811: htp.htmlClose;
1812:
1813: end PrintTextDocument;
1814:
1815: -- PrintUpdateAttachment
Line 1906: htp.htmlOpen;
1902: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
1903: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1904: ||'&'||'query_only='||icx_call.encrypt2(query_only);
1905:
1906: htp.htmlOpen;
1907: htp.headOpen;
1908:
1909: -- Add the java script to the header to open the dm window for
1910: -- any DM function that is executed.
Line 1907: htp.headOpen;
1903: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
1904: ||'&'||'query_only='||icx_call.encrypt2(query_only);
1905:
1906: htp.htmlOpen;
1907: htp.headOpen;
1908:
1909: -- Add the java script to the header to open the dm window for
1910: -- any DM function that is executed.
1911: fnd_document_management.get_open_dm_attach_window;
Line 1917: htp.p( '' );
Line 1922: htp.print( '' );
1918: htp.p( ' function applySubmit(url) {
1919: document.UPDATE_ATCHMT.submit();
1920: top.location.href = url;
1921: }');
1922: htp.print( '' );
1923:
1924: -- Style sheet declaration.
1925: htp.p('
1926: 'TYPE="text/css">');
Line 1925: htp.p('
1921: }');
1922: htp.print( '' );
1923:
1924: -- Style sheet declaration.
1925: htp.p('
1926: 'TYPE="text/css">');
1927:
1928: htp.headClose;
1929: htp.bodyOpen;
Line 1928: htp.headClose;
1924: -- Style sheet declaration.
1925: htp.p('
1926: 'TYPE="text/css">');
1927:
1928: htp.headClose;
1929: htp.bodyOpen;
1930:
1931: -- Body background color.
1932: htp.p('
');
Line 1929: htp.bodyOpen;
1925: htp.p('
1926: 'TYPE="text/css">');
1927:
1928: htp.headClose;
1929: htp.bodyOpen;
1930:
1931: -- Body background color.
1932: htp.p('
');
1933: htp.br;
Line 1932: htp.p('');
1928: htp.headClose;
1929: htp.bodyOpen;
1930:
1931: -- Body background color.
1932: htp.p('');
1933: htp.br;
1934:
1935: -- Print the Page Header.
1936: htp.p('
');
Line 1933: htp.br;
1929: htp.bodyOpen;
1930:
1931: -- Body background color.
1932: htp.p('
');
1933: htp.br;
1934:
1935: -- Print the Page Header.
1936: htp.p('');
1937: htp.p('');
Line 1936: htp.p('
');
1932: htp.p('
');
1933: htp.br;
1934:
1935: -- Print the Page Header.
1936: htp.p('');
1937: htp.p('');
1938: htp.p('. ');
1939: htp.p(''||
1940: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT-HEADIN')
Line 1937: htp.p('');
1933: htp.br;
1934:
1935: -- Print the Page Header.
1936: htp.p('
');
1937: htp.p('');
1938: htp.p('. ');
1939: htp.p(''||
1940: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT-HEADIN')
1941: ||' ');
Line 1938: htp.p('. ');
1934:
1935: -- Print the Page Header.
1936: htp.p('
');
1937: htp.p('');
1938: htp.p('. ');
1939: htp.p(''||
1940: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT-HEADIN')
1941: ||' ');
1942: htp.tableRowClose;
Line 1939: htp.p(''||
1935: -- Print the Page Header.
1936: htp.p('
');
1937: htp.p('');
1938: htp.p('. ');
1939: htp.p(''||
1940: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT-HEADIN')
1941: ||' ');
1942: htp.tableRowClose;
1943: htp.tableClose;
Line 1942: htp.tableRowClose;
1938: htp.p('
. ');
1939: htp.p(''||
1940: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT-HEADIN')
1941: ||' ');
1942: htp.tableRowClose;
1943: htp.tableClose;
1944: htp.br;
1945:
1946: -- Select the updatable information.
Line 1943: htp.tableClose;
1939: htp.p('
'||
1940: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT-HEADIN')
1941: ||' ');
1942: htp.tableRowClose;
1943: htp.tableClose;
1944: htp.br;
1945:
1946: -- Select the updatable information.
1947: open att_doc_cursor;
Line 1944: htp.br;
1940: fnd_message.get_string('FND','FND-WEBATCH-EDIT-ATCHMT-HEADIN')
1941: ||'');
1942: htp.tableRowClose;
1943: htp.tableClose;
1944: htp.br;
1945:
1946: -- Select the updatable information.
1947: open att_doc_cursor;
1948: fetch att_doc_cursor into attdocrec;
Line 1951: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING')
1947: open att_doc_cursor;
1948: fetch att_doc_cursor into attdocrec;
1949: if att_doc_cursor%NOTFOUND then
1950: close att_doc_cursor;
1951: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING')
1952: ||'for update');
1953: htp.print( '' );
1954: htp.bodyClose;
1955: htp.htmlclose;
Line 1953: htp.print( '' );
1949: if att_doc_cursor%NOTFOUND then
1950: close att_doc_cursor;
1951: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING')
1952: ||'for update');
1953: htp.print( '' );
1954: htp.bodyClose;
1955: htp.htmlclose;
1956: return;
1957: end if;
Line 1954: htp.bodyClose;
1950: close att_doc_cursor;
1951: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING')
1952: ||'for update');
1953: htp.print( '' );
1954: htp.bodyClose;
1955: htp.htmlclose;
1956: return;
1957: end if;
1958:
Line 1955: htp.htmlclose;
1951: htp.p(fnd_message.get_string('FND','FND-WEBATCH-ERROR-RETRIEVING')
1952: ||'for update');
1953: htp.print( '' );
1954: htp.bodyClose;
1955: htp.htmlclose;
1956: return;
1957: end if;
1958:
1959: loop
Line 1976: htp.formOpen( curl => upload_action, cattributes=>'NAME="UPDATE_ATCHMT"',
1972: -- GFM Preparation
1973: access_id := fnd_gfm.authorize(NULL);
1974: upload_action := 'fnd_webattch.update_attachment_gfm_wrapper';
1975:
1976: htp.formOpen( curl => upload_action, cattributes=>'NAME="UPDATE_ATCHMT"',
1977: cmethod => 'POST',cenctype=> 'multipart/form-data');
1978:
1979: -- Set the Attachment Information.
1980: htp.p('
');
Line 1980: htp.p('
');
1976: htp.formOpen( curl => upload_action, cattributes=>'NAME="UPDATE_ATCHMT"',
1977: cmethod => 'POST',cenctype=> 'multipart/form-data');
1978:
1979: -- Set the Attachment Information.
1980: htp.p('');
1981: htp.p('');
1982: htp.p('');
1983:
1984: htp.p('');
Line 1981: htp.p('');
1977: cmethod => 'POST',cenctype=> 'multipart/form-data');
1978:
1979: -- Set the Attachment Information.
1980: htp.p('
');
1981: htp.p('');
1982: htp.p('');
1983:
1984: htp.p('');
1985: htp.p(''||'&'||'nbsp; '||
Line 1982: htp.p('');
1978:
1979: -- Set the Attachment Information.
1980: htp.p('
');
1981: htp.p('');
1982: htp.p('');
1983:
1984: htp.p('');
1985: htp.p(''||'&'||'nbsp; '||
1986: ''||
Line 1984: htp.p('');
1980: htp.p('
');
1981: htp.p('');
1982: htp.p('');
1983:
1984: htp.p('');
1985: htp.p(''||'&'||'nbsp; '||
1986: ''||
1987: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||
1988: '');
Line 1985: htp.p(''||'&'||'nbsp; '||
1981: htp.p('');
1982: htp.p('
');
1983:
1984: htp.p('');
1985: htp.p(''||'&'||'nbsp; '||
1986: ''||
1987: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||
1988: '');
1989: htp.p(' ');
Line 1989: htp.p('');
1985: htp.p(''||'&'||'nbsp; '||
1986: ''||
1987: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||
1988: '');
1989: htp.p('');
1990: htp.p('
');
1991: htp.p('
');
1992: htp.br;
1993:
Line 1990: htp.p('
');
1986: ''||
1987: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||
1988: '');
1989: htp.p('');
1990: htp.p('');
1991: htp.p('
');
1992: htp.br;
1993:
1994: --Set the Attachment Information.
Line 1991: htp.p('
');
1987: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||
1988: '');
1989: htp.p('
');
1990: htp.p(' ');
1991: htp.p('
');
1992: htp.br;
1993:
1994: --Set the Attachment Information.
1995: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
Line 1992: htp.br;
1988: '');
1989: htp.p('');
1990: htp.p('');
1991: htp.p('
');
1992: htp.br;
1993:
1994: --Set the Attachment Information.
1995: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
1996: 'width=97% cellspacing=0' );
Line 1995: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
1991: htp.p('
');
1992: htp.br;
1993:
1994: --Set the Attachment Information.
1995: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
1996: 'width=97% cellspacing=0' );
1997: htp.tableRowOpen;
1998: htp.p(''||
1999: ''||
Line 1997: htp.tableRowOpen;
1993:
1994: --Set the Attachment Information.
1995: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
1996: 'width=97% cellspacing=0' );
1997: htp.tableRowOpen;
1998: htp.p('
'||
1999: ''||
2000: ''||
2001: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-SEQUENCE')
Line 1998: htp.p(''||
1994: --Set the Attachment Information.
1995: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
1996: 'width=97% cellspacing=0' );
1997: htp.tableRowOpen;
1998: htp.p('
'||
1999: ''||
2000: ''||
2001: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-SEQUENCE')
2002: || ' ');
Line 2004: htp.p(''||
2000: ''||
2001: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-SEQUENCE')
2002: || '
');
2003:
2004: htp.p(''||
2005: '
2006: ' TYPE='||'"text"'||' VALUE='|| to_char(x_seq_num)||
2007: ' SIZE=4 MAXLENGTH=20> ');
2008: htp.tableRowClose;
Line 2008: htp.tableRowClose;
2004: htp.p('
'||
2005: '
2006: ' TYPE='||'"text"'||' VALUE='|| to_char(x_seq_num)||
2007: ' SIZE=4 MAXLENGTH=20> ');
2008: htp.tableRowClose;
2009:
2010: --Process the category poplist.
2011: htp.tableRowOpen;
2012: htp.p(''||
Line 2011: htp.tableRowOpen;
2007: ' SIZE=4 MAXLENGTH=20>
');
2008: htp.tableRowClose;
2009:
2010: --Process the category poplist.
2011: htp.tableRowOpen;
2012: htp.p(''||
2013: ''||
2014: ''||
2015: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-CATEGORY')
Line 2012: htp.p(''||
2008: htp.tableRowClose;
2009:
2010: --Process the category poplist.
2011: htp.tableRowOpen;
2012: htp.p('
'||
2013: ''||
2014: ''||
2015: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-CATEGORY')
2016: || ' ');
Line 2017: htp.p('');
2013: ''||
2014: ''||
2015: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-CATEGORY')
2016: || '
');
2017: htp.p('');
2018: htp.formSelectOpen( cname => 'category_id' );
2019: FOR dc in doc_cat_cursor LOOP
2020: if (dc.user_name <> ' ' ) then
2021: if (dc.user_name <> x_category_description ) then
Line 2018: htp.formSelectOpen( cname => 'category_id' );
2014: ''||
2015: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-CATEGORY')
2016: || '
');
2017: htp.p('');
2018: htp.formSelectOpen( cname => 'category_id' );
2019: FOR dc in doc_cat_cursor LOOP
2020: if (dc.user_name <> ' ' ) then
2021: if (dc.user_name <> x_category_description ) then
2022: htp.p(' ');
Line 2031: htp.formSelectClose;
2027: else
2028: htp.p('
');
2033: htp.tableRowClose;
2034:
2035: -- Display Document Description.
Line 2032: htp.p('');
2028: htp.p('
Line 2033: htp.tableRowClose;
2029: end if;
2030: END LOOP;
2031: htp.formSelectClose;
2032: htp.p('');
2033: htp.tableRowClose;
2034:
2035: -- Display Document Description.
2036: htp.tableRowOpen;
2037: htp.p('
'||
Line 2036: htp.tableRowOpen;
2032: htp.p('
');
2033: htp.tableRowClose;
2034:
2035: -- Display Document Description.
2036: htp.tableRowOpen;
2037: htp.p(''||
2038: ''||
2039: ''||
2040: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-DESCRIPTI')
Line 2037: htp.p(''||
2033: htp.tableRowClose;
2034:
2035: -- Display Document Description.
2036: htp.tableRowOpen;
2037: htp.p('
'||
2038: ''||
2039: ''||
2040: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-DESCRIPTI')
2041: || ' ');
Line 2042: htp.p(''||
2038: ''||
2039: ''||
2040: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-DESCRIPTI')
2041: || '
');
2042: htp.p(''||
2043: '
2044: ' TYPE='||'"text"'|| ' VALUE="'|| x_document_description ||
2045: '" SIZE=25 MAXLENGTH=80> ');
2046: htp.tableRowClose;
Line 2046: htp.tableRowClose;
2042: htp.p('
'||
2043: '
2044: ' TYPE='||'"text"'|| ' VALUE="'|| x_document_description ||
2045: '" SIZE=25 MAXLENGTH=80> ');
2046: htp.tableRowClose;
2047: htp.tableRowOpen;
2048:
2049: htp.p('');
2050: htp.p(''||
Line 2047: htp.tableRowOpen;
2043: '
2044: ' TYPE='||'"text"'|| ' VALUE="'|| x_document_description ||
2045: '" SIZE=25 MAXLENGTH=80>
');
2046: htp.tableRowClose;
2047: htp.tableRowOpen;
2048:
2049: htp.p('');
2050: htp.p(''||
2051: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
Line 2049: htp.p('');
2045: '" SIZE=25 MAXLENGTH=80>
');
2046: htp.tableRowClose;
2047: htp.tableRowOpen;
2048:
2049: htp.p('');
2050: htp.p(''||
2051: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
2052: '
');
2053: htp.p(''||
Line 2050: htp.p(''||
2046: htp.tableRowClose;
2047: htp.tableRowOpen;
2048:
2049: htp.p('
');
2050: htp.p(''||
2051: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
2052: '
2053: htp.p(''||
2054: '
Line 2053: htp.p(''||
2049: htp.p('
');
2050: htp.p(''||
2051: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
2052: '
2053: htp.p(''||
2054: '
2055: htp.p('
2056: --htp.tableClose;
2057:
Line 2055: htp.p('
2051: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
2052: '');
2053: htp.p('
'||
2054: '
2055: htp.p('
2056: --htp.tableClose;
2057:
2058: -- Query the text from the database.
2059: if (x_datatype_id = 1 ) then
Line 2056: --htp.tableClose;
2052: '');
2053: htp.p('
'||
2054: '
2055: htp.p('
2056: --htp.tableClose;
2057:
2058: -- Query the text from the database.
2059: if (x_datatype_id = 1 ) then
2060: select short_text
Line 2096: htp.formHidden ( cname =>'text', cvalue=>'');
2092: -- Display blank URL document Information for Update
2093: DocumentInformation (x_datatype_id => x_datatype_id,
2094: x_file_name => x_file_name);
2095: else
2096: htp.formHidden ( cname =>'text', cvalue=>'');
2097: htp.formHidden ( cname =>'file_name', cvalue=>'');
2098: htp.formHidden ( cname =>'url', cvalue=>'');
2099: end if;
2100:
Line 2097: htp.formHidden ( cname =>'file_name', cvalue=>'');
2093: DocumentInformation (x_datatype_id => x_datatype_id,
2094: x_file_name => x_file_name);
2095: else
2096: htp.formHidden ( cname =>'text', cvalue=>'');
2097: htp.formHidden ( cname =>'file_name', cvalue=>'');
2098: htp.formHidden ( cname =>'url', cvalue=>'');
2099: end if;
2100:
2101: -- Set the data needed for displaying summary as hidden field.
Line 2098: htp.formHidden ( cname =>'url', cvalue=>'');
2094: x_file_name => x_file_name);
2095: else
2096: htp.formHidden ( cname =>'text', cvalue=>'');
2097: htp.formHidden ( cname =>'file_name', cvalue=>'');
2098: htp.formHidden ( cname =>'url', cvalue=>'');
2099: end if;
2100:
2101: -- Set the data needed for displaying summary as hidden field.
2102: htp.formHidden ( cname =>'attached_document_id',
Line 2102: htp.formHidden ( cname =>'attached_document_id',
2098: htp.formHidden ( cname =>'url', cvalue=>'');
2099: end if;
2100:
2101: -- Set the data needed for displaying summary as hidden field.
2102: htp.formHidden ( cname =>'attached_document_id',
2103: cvalue=> attached_document_id );
2104: htp.formHidden ( cname =>'datatype_id', cvalue=> to_char(x_datatype_id));
2105: htp.formHidden ( cname =>'function_name', cvalue=> function_name );
2106:
Line 2104: htp.formHidden ( cname =>'datatype_id', cvalue=> to_char(x_datatype_id));
2100:
2101: -- Set the data needed for displaying summary as hidden field.
2102: htp.formHidden ( cname =>'attached_document_id',
2103: cvalue=> attached_document_id );
2104: htp.formHidden ( cname =>'datatype_id', cvalue=> to_char(x_datatype_id));
2105: htp.formHidden ( cname =>'function_name', cvalue=> function_name );
2106:
2107: htp.formHidden ( cname =>'entity_name', cvalue=> entity_name);
2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
Line 2105: htp.formHidden ( cname =>'function_name', cvalue=> function_name );
2101: -- Set the data needed for displaying summary as hidden field.
2102: htp.formHidden ( cname =>'attached_document_id',
2103: cvalue=> attached_document_id );
2104: htp.formHidden ( cname =>'datatype_id', cvalue=> to_char(x_datatype_id));
2105: htp.formHidden ( cname =>'function_name', cvalue=> function_name );
2106:
2107: htp.formHidden ( cname =>'entity_name', cvalue=> entity_name);
2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
Line 2107: htp.formHidden ( cname =>'entity_name', cvalue=> entity_name);
2103: cvalue=> attached_document_id );
2104: htp.formHidden ( cname =>'datatype_id', cvalue=> to_char(x_datatype_id));
2105: htp.formHidden ( cname =>'function_name', cvalue=> function_name );
2106:
2107: htp.formHidden ( cname =>'entity_name', cvalue=> entity_name);
2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
Line 2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
2104: htp.formHidden ( cname =>'datatype_id', cvalue=> to_char(x_datatype_id));
2105: htp.formHidden ( cname =>'function_name', cvalue=> function_name );
2106:
2107: htp.formHidden ( cname =>'entity_name', cvalue=> entity_name);
2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
Line 2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
2105: htp.formHidden ( cname =>'function_name', cvalue=> function_name );
2106:
2107: htp.formHidden ( cname =>'entity_name', cvalue=> entity_name);
2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
2113: htp.formHidden ( cname =>'from_url', cvalue=> from_url);
Line 2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2106:
2107: htp.formHidden ( cname =>'entity_name', cvalue=> entity_name);
2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
2113: htp.formHidden ( cname =>'from_url', cvalue=> from_url);
2114: htp.formHidden ( cname =>'query_only', cvalue=> query_only);
Line 2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2107: htp.formHidden ( cname =>'entity_name', cvalue=> entity_name);
2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
2113: htp.formHidden ( cname =>'from_url', cvalue=> from_url);
2114: htp.formHidden ( cname =>'query_only', cvalue=> query_only);
2115: htp.formHidden ( cname =>'package_name', cvalue=>
Line 2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
2108: htp.formHidden ( cname =>'pk1_value', cvalue=> pk1_value);
2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
2113: htp.formHidden ( cname =>'from_url', cvalue=> from_url);
2114: htp.formHidden ( cname =>'query_only', cvalue=> query_only);
2115: htp.formHidden ( cname =>'package_name', cvalue=>
2116: icx_sec.getID(icx_sec.PV_WEB_USER_ID)||';'
Line 2113: htp.formHidden ( cname =>'from_url', cvalue=> from_url);
2109: htp.formHidden ( cname =>'pk2_value', cvalue=> pk2_value);
2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
2113: htp.formHidden ( cname =>'from_url', cvalue=> from_url);
2114: htp.formHidden ( cname =>'query_only', cvalue=> query_only);
2115: htp.formHidden ( cname =>'package_name', cvalue=>
2116: icx_sec.getID(icx_sec.PV_WEB_USER_ID)||';'
2117: || PrintUpdateAttachment.package_name ||';'||to_char(access_id)||';');
Line 2114: htp.formHidden ( cname =>'query_only', cvalue=> query_only);
2110: htp.formHidden ( cname =>'pk3_value', cvalue=> pk3_value);
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
2113: htp.formHidden ( cname =>'from_url', cvalue=> from_url);
2114: htp.formHidden ( cname =>'query_only', cvalue=> query_only);
2115: htp.formHidden ( cname =>'package_name', cvalue=>
2116: icx_sec.getID(icx_sec.PV_WEB_USER_ID)||';'
2117: || PrintUpdateAttachment.package_name ||';'||to_char(access_id)||';');
2118: htp.br;
Line 2115: htp.formHidden ( cname =>'package_name', cvalue=>
2111: htp.formHidden ( cname =>'pk4_value', cvalue=> pk4_value);
2112: htp.formHidden ( cname =>'pk5_value', cvalue=> pk5_value);
2113: htp.formHidden ( cname =>'from_url', cvalue=> from_url);
2114: htp.formHidden ( cname =>'query_only', cvalue=> query_only);
2115: htp.formHidden ( cname =>'package_name', cvalue=>
2116: icx_sec.getID(icx_sec.PV_WEB_USER_ID)||';'
2117: || PrintUpdateAttachment.package_name ||';'||to_char(access_id)||';');
2118: htp.br;
2119:
Line 2118: htp.br;
2114: htp.formHidden ( cname =>'query_only', cvalue=> query_only);
2115: htp.formHidden ( cname =>'package_name', cvalue=>
2116: icx_sec.getID(icx_sec.PV_WEB_USER_ID)||';'
2117: || PrintUpdateAttachment.package_name ||';'||to_char(access_id)||';');
2118: htp.br;
2119:
2120: -- Create buttons for adding and back links.
2121: htp.p('');
Line 2121: htp.p('');
2123: htp.p('');
2124: htp.p('');
2125: htp.p('');
Line 2123: htp.p('');
2119:
2120: -- Create buttons for adding and back links.
2121: htp.p('');
2123: htp.p('
');
2124: htp.p('');
2125: htp.p('');
2126: htp.p('');
2127: htp.p('
Line 2124: htp.p('
');
2120: -- Create buttons for adding and back links.
2121: htp.p('');
2123: htp.p('
');
2124: htp.p('');
2125: htp.p('');
2126: htp.p('');
2127: htp.p('
2128: htp.p('
Line 2125: htp.p('');
2121: htp.p('');
2123: htp.p('
');
2124: htp.p('');
2125: htp.p('');
2126: htp.p('');
2127: htp.p('
2128: htp.p('
2129: htp.p('
Line 2126: htp.p('');
2122: ' row defines the edges and tops-->');
2123: htp.p('
');
2124: htp.p('');
2125: htp.p('');
2126: htp.p('');
2127: htp.p('
2128: htp.p('
2129: htp.p('
2130: htp.p(' ');
Line 2127: htp.p('
2123: htp.p('
');
2124: htp.p('');
2125: htp.p('');
2126: htp.p('');
2127: htp.p('
2128: htp.p('
2129: htp.p('
2130: htp.p(' ');
2131: htp.p('
Line 2128: htp.p('
2124: htp.p('
');
2125: htp.p('');
2126: htp.p('');
2127: htp.p('
2128: htp.p('
2129: htp.p('
2130: htp.p(' ');
2131: htp.p('
2132:
Line 2129: htp.p('
2125: htp.p('
');
2126: htp.p('');
2127: htp.p('
2128: htp.p('
2129: htp.p('
2130: htp.p(' ');
2131: htp.p('
2132:
2133: htp.p('');
Line 2130: htp.p(' ');
2126: htp.p('');
2127: htp.p('
2128: htp.p('
2129: htp.p('
2130: htp.p(' ');
2131: htp.p('
2132:
2133: htp.p('');
2134: htp.p('
Line 2131: htp.p('
2127: htp.p('
2128: htp.p('
2129: htp.p('
2130: htp.p(' ');
2131: htp.p('
2132:
2133: htp.p('');
2134: htp.p('
2135: htp.p('
Line 2133: htp.p('');
2129: htp.p('
2130: htp.p(' ');
2131: htp.p('
2132:
2133: htp.p('');
2134: htp.p('
2135: htp.p('
2136: htp.p('
2137: htp.p(' ');
Line 2134: htp.p('
2130: htp.p(' ');
2131: htp.p('
2132:
2133: htp.p('');
2134: htp.p('
2135: htp.p('
2136: htp.p('
2137: htp.p('');
2138: htp.p('');
Line 2135: htp.p('
2131: htp.p('
2132:
2133: htp.p('');
2134: htp.p('
2135: htp.p('
2136: htp.p('
2137: htp.p(' ');
2138: htp.p('');
2139: htp.p('');
Line 2136: htp.p('
2132:
2133: htp.p('');
2134: htp.p('
2135: htp.p('
2136: htp.p('
2137: htp.p(' ');
2138: htp.p('');
2139: htp.p('');
2140: htp.p('
Line 2137: htp.p('
');
2133: htp.p('');
2134: htp.p('
2135: htp.p('
2136: htp.p('
2137: htp.p('');
2138: htp.p('');
2139: htp.p('');
2140: htp.p('
2141: htp.p('
Line 2138: htp.p('');
2134: htp.p('
2135: htp.p('
2136: htp.p('
2137: htp.p(' ');
2138: htp.p('');
2139: htp.p('');
2140: htp.p('
2141: htp.p('
2142: htp.p('
Line 2139: htp.p('');
2135: htp.p('
2136: htp.p('
2137: htp.p(' ');
2138: htp.p('');
2139: htp.p('');
2140: htp.p('
2141: htp.p('
2142: htp.p('
2143: htp.p(' ');
Line 2140: htp.p('
2136: htp.p('
2137: htp.p(' ');
2138: htp.p('');
2139: htp.p('');
2140: htp.p('
2141: htp.p('
2142: htp.p('
2143: htp.p(' ');
2144: htp.p('');
Line 2141: htp.p('
2137: htp.p('
');
2138: htp.p('');
2139: htp.p('');
2140: htp.p('
2141: htp.p('
2142: htp.p('
2143: htp.p(' ');
2144: htp.p('');
2145: htp.p('');
Line 2142: htp.p('
2138: htp.p('
');
2139: htp.p('');
2140: htp.p('
2141: htp.p('
2142: htp.p('
2143: htp.p(' ');
2144: htp.p('');
2145: htp.p('');
2146: htp.p(''||
Line 2143: htp.p('
');
2139: htp.p('');
2140: htp.p('
2141: htp.p('
2142: htp.p('
2143: htp.p('');
2144: htp.p('');
2145: htp.p('');
2146: htp.p(''||
2147: '
Line 2144: htp.p('');
2140: htp.p('
2141: htp.p('
2142: htp.p('
2143: htp.p(' ');
2144: htp.p('');
2145: htp.p('');
2146: htp.p(''||
2147: '
2148: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
Line 2145: htp.p('');
2141: htp.p('
2142: htp.p('
2143: htp.p(' ');
2144: htp.p('');
2145: htp.p('');
2146: htp.p(''||
2147: '
2148: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2149: ''||
Line 2146: htp.p(''||
2142: htp.p('
2143: htp.p('
');
2144: htp.p('');
2145: htp.p('');
2146: htp.p(''||
2147: '
2148: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2149: ''||
2150: fnd_message.get_string('FND','FND-WEBATCH-UPDATE-ATTACHMENT'));
Line 2151: htp.p('
');
'||
2153: '
2154: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2155: ''||
Line 2152: htp.p(''||
2148: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2149: ''||
2150: fnd_message.get_string('FND','FND-WEBATCH-UPDATE-ATTACHMENT'));
2151: htp.p('
');
2152: htp.p(''||
2153: '
2154: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2155: ''||
2156: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
Line 2157: htp.p('
');
');
2158: htp.p('');
2159: htp.p(' ');
2160:
2161: htp.p('');
Line 2158: htp.p('');
2154: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2155: ''||
2156: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2157: htp.p('');
2158: htp.p('');
2159: htp.p('
');
2160:
2161: htp.p('');
2162: htp.p('
Line 2159: htp.p('
');
2155: ''||
2156: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2157: htp.p('
');
2158: htp.p('');
2159: htp.p(' ');
2160:
2161: htp.p('');
2162: htp.p('
2163: htp.p('
Line 2161: htp.p('');
2157: htp.p('');
2158: htp.p('');
2159: htp.p('
');
2160:
2161: htp.p('');
2162: htp.p('
2163: htp.p('
2164: htp.p('
2165: htp.p(' ');
Line 2162: htp.p('
2158: htp.p('');
2159: htp.p('
');
2160:
2161: htp.p('');
2162: htp.p('
2163: htp.p('
2164: htp.p('
2165: htp.p(' ');
2166: htp.p('');
Line 2163: htp.p('
2159: htp.p('
');
2160:
2161: htp.p('');
2162: htp.p('
2163: htp.p('
2164: htp.p('
2165: htp.p(' ');
2166: htp.p('');
2167: htp.p('
Line 2164: htp.p('
2160:
2161: htp.p('
');
2162: htp.p('
2163: htp.p('
2164: htp.p('
2165: htp.p(' ');
2166: htp.p('');
2167: htp.p('
2168: htp.p('
Line 2165: htp.p('
');
2161: htp.p('
');
2162: htp.p('
2163: htp.p('
2164: htp.p('
2165: htp.p(' ');
2166: htp.p('');
2167: htp.p('
2168: htp.p('
2169: htp.p('
Line 2166: htp.p('');
2162: htp.p('
2163: htp.p('
2164: htp.p('
2165: htp.p(' ');
2166: htp.p('');
2167: htp.p('
2168: htp.p('
2169: htp.p('
2170: htp.p(' ');
Line 2167: htp.p('
2163: htp.p('
2164: htp.p('
2165: htp.p(' ');
2166: htp.p('');
2167: htp.p('
2168: htp.p('
2169: htp.p('
2170: htp.p(' ');
2171: htp.p('
');
Line 2168: htp.p('
2164: htp.p('
2165: htp.p(' ');
2166: htp.p('');
2167: htp.p('
2168: htp.p('
2169: htp.p('
2170: htp.p(' ');
2171: htp.p('
');
2172:
Line 2169: htp.p('
2165: htp.p('
');
2166: htp.p('');
2167: htp.p('
2168: htp.p('
2169: htp.p('
2170: htp.p(' ');
2171: htp.p('
');
2172:
2173: htp.formClose;
Line 2170: htp.p('
');
2166: htp.p('
');
2167: htp.p('
2168: htp.p('
2169: htp.p('
2170: htp.p(' ');
2171: htp.p('
');
2172:
2173: htp.formClose;
2174: htp.bodyClose;
Line 2171: htp.p('
');
2167: htp.p('
2168: htp.p('
2169: htp.p('
2170: htp.p('');
2171: htp.p('
');
2172:
2173: htp.formClose;
2174: htp.bodyClose;
2175: htp.htmlClose;
Line 2173: htp.formClose;
2169: htp.p('
2170: htp.p(' ');
2171: htp.p('
');
2172:
2173: htp.formClose;
2174: htp.bodyClose;
2175: htp.htmlClose;
2176:
2177: exception
Line 2174: htp.bodyClose;
2170: htp.p('
');
2171: htp.p('
');
2172:
2173: htp.formClose;
2174: htp.bodyClose;
2175: htp.htmlClose;
2176:
2177: exception
2178: when others then
Line 2175: htp.htmlClose;
2171: htp.p('
');
2172:
2173: htp.formClose;
2174: htp.bodyClose;
2175: htp.htmlClose;
2176:
2177: exception
2178: when others then
2179: rollback;
Line 2272: htp.htmlOpen;
2268: ||'&'||'pk5_value='||icx_call.encrypt2(pk5_value)
2269: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
2270: ||'&'||'query_only='||icx_call.encrypt2(query_only);
2271:
2272: htp.htmlOpen;
2273: htp.headOpen;
2274:
2275: -- Add the java script to the header to open the dm window for
2276: -- any DM function that is executed.
Line 2273: htp.headOpen;
2269: ||'&'||'from_url=' ||icx_call.encrypt2(from_url)
2270: ||'&'||'query_only='||icx_call.encrypt2(query_only);
2271:
2272: htp.htmlOpen;
2273: htp.headOpen;
2274:
2275: -- Add the java script to the header to open the dm window for
2276: -- any DM function that is executed.
2277: fnd_document_management.get_open_dm_attach_window;
Line 2282: htp.p( '' );
Line 2287: htp.print( '' );
2283: htp.p( ' function applySubmit(url) {
2284: document.ADD_ATCHMT.submit();
2285: top.location.href = url;
2286: }');
2287: htp.print( '' );
2288:
2289: -- Style sheet declaration.
2290: htp.p('
2291: 'TYPE="text/css">');
Line 2290: htp.p('
2286: }');
2287: htp.print( '' );
2288:
2289: -- Style sheet declaration.
2290: htp.p('
2291: 'TYPE="text/css">');
2292:
2293: htp.headClose;
2294: htp.bodyOpen;
Line 2293: htp.headClose;
2289: -- Style sheet declaration.
2290: htp.p('
2291: 'TYPE="text/css">');
2292:
2293: htp.headClose;
2294: htp.bodyOpen;
2295:
2296: -- Body background color.
2297: htp.p('
');
Line 2294: htp.bodyOpen;
2290: htp.p('
2291: 'TYPE="text/css">');
2292:
2293: htp.headClose;
2294: htp.bodyOpen;
2295:
2296: -- Body background color.
2297: htp.p('
');
2298: htp.br;
Line 2297: htp.p('');
2293: htp.headClose;
2294: htp.bodyOpen;
2295:
2296: -- Body background color.
2297: htp.p('');
2298: htp.br;
2299:
2300: -- Print the Page Header.
2301: htp.p('
');
Line 2298: htp.br;
2294: htp.bodyOpen;
2295:
2296: -- Body background color.
2297: htp.p('
');
2298: htp.br;
2299:
2300: -- Print the Page Header.
2301: htp.p('');
2302: htp.p('');
Line 2301: htp.p('
');
2297: htp.p('
');
2298: htp.br;
2299:
2300: -- Print the Page Header.
2301: htp.p('');
2302: htp.p('');
2303: htp.p('. ');
2304: htp.p(''||
2305: fnd_message.get_string('FND','FND-WEBATCH-ADDATCHMT-HEADING')
Line 2302: htp.p('');
2298: htp.br;
2299:
2300: -- Print the Page Header.
2301: htp.p('
');
2302: htp.p('');
2303: htp.p('. ');
2304: htp.p(''||
2305: fnd_message.get_string('FND','FND-WEBATCH-ADDATCHMT-HEADING')
2306: ||' ');
Line 2303: htp.p('. ');
2299:
2300: -- Print the Page Header.
2301: htp.p('
');
2302: htp.p('');
2303: htp.p('. ');
2304: htp.p(''||
2305: fnd_message.get_string('FND','FND-WEBATCH-ADDATCHMT-HEADING')
2306: ||' ');
2307: htp.tableRowClose;
Line 2304: htp.p(''||
2300: -- Print the Page Header.
2301: htp.p('
');
2302: htp.p('');
2303: htp.p('. ');
2304: htp.p(''||
2305: fnd_message.get_string('FND','FND-WEBATCH-ADDATCHMT-HEADING')
2306: ||' ');
2307: htp.tableRowClose;
2308: htp.tableClose;
Line 2307: htp.tableRowClose;
2303: htp.p('
. ');
2304: htp.p(''||
2305: fnd_message.get_string('FND','FND-WEBATCH-ADDATCHMT-HEADING')
2306: ||' ');
2307: htp.tableRowClose;
2308: htp.tableClose;
2309: htp.br;
2310:
2311: -- GFM Preparation
Line 2308: htp.tableClose;
2304: htp.p('
'||
2305: fnd_message.get_string('FND','FND-WEBATCH-ADDATCHMT-HEADING')
2306: ||' ');
2307: htp.tableRowClose;
2308: htp.tableClose;
2309: htp.br;
2310:
2311: -- GFM Preparation
2312: access_id := fnd_gfm.authorize(NULL);
Line 2309: htp.br;
2305: fnd_message.get_string('FND','FND-WEBATCH-ADDATCHMT-HEADING')
2306: ||'');
2307: htp.tableRowClose;
2308: htp.tableClose;
2309: htp.br;
2310:
2311: -- GFM Preparation
2312: access_id := fnd_gfm.authorize(NULL);
2313: upload_action := 'fnd_webattch.add_attachment_gfm_wrapper';
Line 2315: htp.formOpen( curl => upload_action , cattributes=>'NAME="ADD_ATCHMT"',
2311: -- GFM Preparation
2312: access_id := fnd_gfm.authorize(NULL);
2313: upload_action := 'fnd_webattch.add_attachment_gfm_wrapper';
2314:
2315: htp.formOpen( curl => upload_action , cattributes=>'NAME="ADD_ATCHMT"',
2316: cmethod => 'POST',cenctype=> 'multipart/form-data');
2317:
2318: htp.p('
');
2319: htp.p('');
Line 2318: htp.p('
');
2314:
2315: htp.formOpen( curl => upload_action , cattributes=>'NAME="ADD_ATCHMT"',
2316: cmethod => 'POST',cenctype=> 'multipart/form-data');
2317:
2318: htp.p('');
2319: htp.p('');
2320: htp.p('');
2321:
2322: htp.p('');
Line 2319: htp.p('');
2315: htp.formOpen( curl => upload_action , cattributes=>'NAME="ADD_ATCHMT"',
2316: cmethod => 'POST',cenctype=> 'multipart/form-data');
2317:
2318: htp.p('
');
2319: htp.p('');
2320: htp.p('');
2321:
2322: htp.p('');
2323: htp.p(''||'&'||'nbsp; '||
Line 2320: htp.p('');
2316: cmethod => 'POST',cenctype=> 'multipart/form-data');
2317:
2318: htp.p('
');
2319: htp.p('');
2320: htp.p('');
2321:
2322: htp.p('');
2323: htp.p(''||'&'||'nbsp; '||
2324: fnd_message.get_string('FND', 'FND-WEBATCH-ATCHMT-INFO-HEADIN')||' '
Line 2322: htp.p('');
2318: htp.p('
');
2319: htp.p('');
2320: htp.p('');
2321:
2322: htp.p('');
2323: htp.p(''||'&'||'nbsp; '||
2324: fnd_message.get_string('FND', 'FND-WEBATCH-ATCHMT-INFO-HEADIN')||' '
2325: ||''||
2326: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||' '||
Line 2323: htp.p(''||'&'||'nbsp; '||
2319: htp.p('');
2320: htp.p('
');
2321:
2322: htp.p('');
2323: htp.p(''||'&'||'nbsp; '||
2324: fnd_message.get_string('FND', 'FND-WEBATCH-ATCHMT-INFO-HEADIN')||' '
2325: ||''||
2326: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||' '||
2327: '');
Line 2328: htp.p('
');
2324: fnd_message.get_string('FND', 'FND-WEBATCH-ATCHMT-INFO-HEADIN')||' '
2325: ||''||
2326: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||' '||
2327: '');
2328: htp.p('');
2329: htp.p('
');
2330: htp.p('
');
2331: htp.br;
2332:
Line 2329: htp.p('
');
2325: ||''||
2326: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||' '||
2327: '');
2328: htp.p('');
2329: htp.p('');
2330: htp.p('
');
2331: htp.br;
2332:
2333: --Set the Attachment Information.
Line 2330: htp.p('
');
2326: fnd_message.get_string('FND', 'FND-WEBATCH-REQ-FIELDS')||' '||
2327: '');
2328: htp.p('
');
2329: htp.p(' ');
2330: htp.p('
');
2331: htp.br;
2332:
2333: --Set the Attachment Information.
2334: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
Line 2331: htp.br;
2327: '');
2328: htp.p('');
2329: htp.p('');
2330: htp.p('
');
2331: htp.br;
2332:
2333: --Set the Attachment Information.
2334: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
2335: 'width=97% cellspacing=0' );
Line 2334: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
2330: htp.p('
');
2331: htp.br;
2332:
2333: --Set the Attachment Information.
2334: htp.tableOpen( cattributes => ' border=0 cellpadding=0 '||
2335: 'width=97% cellspacing=0' );
2336:
2337: -- Get the max Sequence Number and set it seq_num.
2338: open sm_cursor;
Line 2342: htp.tableRowOpen;
2338: open sm_cursor;
2339: fetch sm_cursor into seq_num;
2340: close sm_cursor;
2341:
2342: htp.tableRowOpen;
2343: htp.p('
'||
2344: ''||
2345: ''||
2346: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-SEQUENCE')
Line 2343: htp.p(''||
2339: fetch sm_cursor into seq_num;
2340: close sm_cursor;
2341:
2342: htp.tableRowOpen;
2343: htp.p('
'||
2344: ''||
2345: ''||
2346: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-SEQUENCE')
2347: || ' ');
Line 2349: htp.p(''||
2345: ''||
2346: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-SEQUENCE')
2347: || '
');
2348:
2349: htp.p(''||
2350: '
2351: ' TYPE='||'"text"'||' VALUE='||
2352: to_char(seq_num)||' SIZE=4 MAXLENGTH=20> ');
2353: htp.tableRowClose;
Line 2353: htp.tableRowClose;
2349: htp.p('
'||
2350: '
2351: ' TYPE='||'"text"'||' VALUE='||
2352: to_char(seq_num)||' SIZE=4 MAXLENGTH=20> ');
2353: htp.tableRowClose;
2354:
2355: --Process the category poplist.
2356: htp.tableRowOpen;
2357: htp.p(''||
Line 2356: htp.tableRowOpen;
2352: to_char(seq_num)||' SIZE=4 MAXLENGTH=20>
');
2353: htp.tableRowClose;
2354:
2355: --Process the category poplist.
2356: htp.tableRowOpen;
2357: htp.p(''||
2358: ''||
2359: ''||
2360: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-CATEGORY')
Line 2357: htp.p(''||
2353: htp.tableRowClose;
2354:
2355: --Process the category poplist.
2356: htp.tableRowOpen;
2357: htp.p('
'||
2358: ''||
2359: ''||
2360: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-CATEGORY')
2361: || ' ');
Line 2362: htp.p('');
2358: ''||
2359: ''||
2360: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-CATEGORY')
2361: || '
');
2362: htp.p('');
2363: htp.formSelectOpen( cname => 'category_id' );
2364: FOR dc in dc_cursor LOOP
2365: if (dc.user_name <> ' ' ) then
2366: htp.p(' ');
2362: htp.p('');
2363: htp.formSelectOpen( cname => 'category_id' );
2364: FOR dc in dc_cursor LOOP
2365: if (dc.user_name <> ' ' ) then
2366: htp.p(' ');
2373: htp.tableRowClose;
2374:
2375: -- Display Document Description.
Line 2372: htp.p('
');
2368: htp.p('
Line 2373: htp.tableRowClose;
2369: end if;
2370: END LOOP;
2371: htp.formSelectClose;
2372: htp.p('');
2373: htp.tableRowClose;
2374:
2375: -- Display Document Description.
2376: htp.tableRowOpen;
2377: htp.p('
'||
Line 2376: htp.tableRowOpen;
2372: htp.p('
');
2373: htp.tableRowClose;
2374:
2375: -- Display Document Description.
2376: htp.tableRowOpen;
2377: htp.p(''||
2378: ''||
2379: ''||
2380: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-DESCRIPTI')
Line 2377: htp.p(''||
2373: htp.tableRowClose;
2374:
2375: -- Display Document Description.
2376: htp.tableRowOpen;
2377: htp.p('
'||
2378: ''||
2379: ''||
2380: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-DESCRIPTI')
2381: || ' ');
Line 2382: htp.p(''||
2378: ''||
2379: ''||
2380: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-DESCRIPTI')
2381: || '
');
2382: htp.p(''||
2383: '
2384: ' TYPE='||'"text"'|| ' SIZE=25 MAXLENGTH=80> ');
2385: htp.tableRowClose;
2386:
Line 2385: htp.tableRowClose;
2381: || '
');
2382: htp.p(''||
2383: '
2384: ' TYPE='||'"text"'|| ' SIZE=25 MAXLENGTH=80> ');
2385: htp.tableRowClose;
2386:
2387: -- Construct the Document Information area.
2388: -- Text datatype
2389: htp.tableRowOpen;
Line 2389: htp.tableRowOpen;
2385: htp.tableRowClose;
2386:
2387: -- Construct the Document Information area.
2388: -- Text datatype
2389: htp.tableRowOpen;
2390:
2391: htp.p('
');
2392: htp.p(''||
2393: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
Line 2391: htp.p('');
2387: -- Construct the Document Information area.
2388: -- Text datatype
2389: htp.tableRowOpen;
2390:
2391: htp.p('
');
2392: htp.p(''||
2393: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
2394: '
');
2395: htp.p(''||
Line 2392: htp.p(''||
2388: -- Text datatype
2389: htp.tableRowOpen;
2390:
2391: htp.p('
');
2392: htp.p(''||
2393: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
2394: '
2395: htp.p(''||
2396: '
Line 2395: htp.p(''||
2391: htp.p('
');
2392: htp.p(''||
2393: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
2394: '
2395: htp.p(''||
2396: '
2397: htp.p('
2398:
2399: htp.tableRowOpen;
Line 2397: htp.p('
2393: fnd_message.get_string('FND', 'FND-WEBATCH-DOC-INFO-HEADING')||
2394: '');
2395: htp.p('
'||
2396: '
2397: htp.p('
2398:
2399: htp.tableRowOpen;
2400: htp.p('');
2401: htp.p('
Line 2399: htp.tableRowOpen;
2395: htp.p('
'||
2396: '
2397: htp.p('
2398:
2399: htp.tableRowOpen;
2400: htp.p(' ');
2401: htp.p('
2402: 'type=radio checked value="2">'||
2403: fnd_message.get_string('FND','FND-WEBATCH-TEXT-DATATYPE')||' ');
Line 2400: htp.p('');
2396: '
');
2397: htp.p('
2398:
2399: htp.tableRowOpen;
2400: htp.p('');
2401: htp.p('
2402: 'type=radio checked value="2">'||
2403: fnd_message.get_string('FND','FND-WEBATCH-TEXT-DATATYPE')||' ');
2404: htp.p('');
Line 2401: htp.p('
2397: htp.p('
2398:
2399: htp.tableRowOpen;
2400: htp.p('');
2401: htp.p('
2402: 'type=radio checked value="2">'||
2403: fnd_message.get_string('FND','FND-WEBATCH-TEXT-DATATYPE')||' ');
2404: htp.p('');
2405: htp.p('');
2407: htp.tableRowClose;
2408:
Line 2405: htp.p('');
2407: htp.tableRowClose;
2408:
2409: -- File Datatype
Line 2407: htp.tableRowClose;
2403: fnd_message.get_string('FND','FND-WEBATCH-TEXT-DATATYPE')||'
');
2404: htp.p('');
2405: htp.p('');
2407: htp.tableRowClose;
2408:
2409: -- File Datatype
2410: htp.tableRowOpen;
2411: htp.p(' ');
Line 2410: htp.tableRowOpen;
2406: '');
2407: htp.tableRowClose;
2408:
2409: -- File Datatype
2410: htp.tableRowOpen;
2411: htp.p('
');
2412: htp.p('
2413: 'type=radio value="6">'||
2414: fnd_message.get_string('FND','FND-WEBATCH-FILE-DATATYPE')||' ');
Line 2411: htp.p('');
2407: htp.tableRowClose;
2408:
2409: -- File Datatype
2410: htp.tableRowOpen;
2411: htp.p('
');
2412: htp.p('
2413: 'type=radio value="6">'||
2414: fnd_message.get_string('FND','FND-WEBATCH-FILE-DATATYPE')||' ');
2415: htp.p('');
Line 2412: htp.p('
2408:
2409: -- File Datatype
2410: htp.tableRowOpen;
2411: htp.p('
');
2412: htp.p('
2413: 'type=radio value="6">'||
2414: fnd_message.get_string('FND','FND-WEBATCH-FILE-DATATYPE')||' ');
2415: htp.p('');
2416: htp.p('
Line 2415: htp.p('');
2411: htp.p('
');
2412: htp.p('
2413: 'type=radio value="6">'||
2414: fnd_message.get_string('FND','FND-WEBATCH-FILE-DATATYPE')||' ');
2415: htp.p('');
2416: htp.p('
2417: ' SIZE="32">');
2418: htp.tableRowClose;
2419:
Line 2416: htp.p('
2412: htp.p('
2413: 'type=radio value="6">'||
2414: fnd_message.get_string('FND','FND-WEBATCH-FILE-DATATYPE')||'
');
2415: htp.p('');
2416: htp.p('
2417: ' SIZE="32">');
2418: htp.tableRowClose;
2419:
2420: -- URL Datatype
Line 2418: htp.tableRowClose;
2414: fnd_message.get_string('FND','FND-WEBATCH-FILE-DATATYPE')||'
');
2415: htp.p('');
2416: htp.p('
2417: ' SIZE="32">');
2418: htp.tableRowClose;
2419:
2420: -- URL Datatype
2421: htp.tableRowOpen;
2422: htp.p(' ');
Line 2421: htp.tableRowOpen;
2417: ' SIZE="32">');
2418: htp.tableRowClose;
2419:
2420: -- URL Datatype
2421: htp.tableRowOpen;
2422: htp.p('
');
2423: htp.p('
2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||' ');
Line 2422: htp.p('');
2418: htp.tableRowClose;
2419:
2420: -- URL Datatype
2421: htp.tableRowOpen;
2422: htp.p('
');
2423: htp.p('
2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||' ');
2426: htp.p('');
Line 2423: htp.p('
2419:
2420: -- URL Datatype
2421: htp.tableRowOpen;
2422: htp.p('
');
2423: htp.p('
2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||' ');
2426: htp.p('');
2427: htp.p('
Line 2426: htp.p('');
2422: htp.p('
');
2423: htp.p('
2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||' ');
2426: htp.p('');
2427: htp.p('
2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
Line 2427: htp.p('
2423: htp.p('
2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
');
2426: htp.p('');
2427: htp.p('
2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
2431: /*
Line 2429: htp.tableRowClose;
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
');
2426: htp.p('');
2427: htp.p('
2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
2431: /*
2432: ** Create the callback syntax to update the local fields
2433: */
Line 2449: htp.tableRowOpen;
2445: TRUE,
2446: l_search_document_URL);
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
Line 2450: htp.p('');
2446: l_search_document_URL);
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
2454: htp.p('');
Line 2451: htp.p('
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
2454: htp.p('');
2455: htp.p('
Line 2454: htp.p('');
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
Line 2455: htp.p('
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
Line 2457: htp.tableRowClose;
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
Line 2458: htp.tableClose;
2454: htp.p('
');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
Line 2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
Line 2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
Line 2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
Line 2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
Line 2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
Line 2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
Line 2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
Line 2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
Line 2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
Line 2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
Line 2471: htp.formHidden (cname =>'user_id',
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
2475:
Line 2473: htp.formHidden (cname =>'package_name',cvalue=>
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
2475:
2476: -- Submit and Reset Buttons.
2477: -- Create buttons for adding and back links.
Line 2478: htp.br;
2474: PrintAddAttachment.package_name );
2475:
2476: -- Submit and Reset Buttons.
2477: -- Create buttons for adding and back links.
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
Line 2479: htp.p('');
2481: htp.p('');
2482: htp.p('');
2483: htp.p('');
Line 2481: htp.p('');
2477: -- Create buttons for adding and back links.
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
Line 2482: htp.p('
');
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
Line 2483: htp.p('');
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
Line 2484: htp.p('');
2480: ' row defines the edges and tops-->');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
Line 2485: htp.p('
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
Line 2486: htp.p('
2482: htp.p('
');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
Line 2487: htp.p('
2483: htp.p('
');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
Line 2488: htp.p(' ');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
Line 2489: htp.p('
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
Line 2491: htp.p('');
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
Line 2492: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p('');
2496: htp.p('');
Line 2493: htp.p('
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
Line 2494: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
Line 2495: htp.p('
');
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p('');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
Line 2496: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
Line 2497: htp.p('');
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
Line 2498: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
Line 2499: htp.p('
2495: htp.p('
');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
Line 2500: htp.p('
2496: htp.p('
');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
Line 2501: htp.p('
');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p('');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
Line 2502: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
Line 2503: htp.p('');
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
Line 2504: htp.p(''||
2500: htp.p('
2501: htp.p('
');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
Line 2509: htp.p('
');
'||
2511: '
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
Line 2510: htp.p(''||
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
2509: htp.p('
');
2510: htp.p(''||
2511: '
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
Line 2515: htp.p('
');
');
2516: htp.p('');
2517: htp.p(' ');
2518:
2519: htp.p('');
Line 2516: htp.p('');
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2515: htp.p('');
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
Line 2517: htp.p('
');
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2515: htp.p('
');
2516: htp.p('');
2517: htp.p(' ');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
Line 2519: htp.p('');
2515: htp.p('');
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
Line 2520: htp.p('
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
Line 2521: htp.p('
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
Line 2522: htp.p('
2518:
2519: htp.p('
');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
Line 2523: htp.p('
');
2519: htp.p('
');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
Line 2524: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
Line 2525: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
Line 2526: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
Line 2527: htp.p('
2523: htp.p('
');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
Line 2528: htp.p('
');
2524: htp.p('
');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
Line 2529: htp.p('
');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p('');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
Line 2530: htp.formClose;
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
Line 2531: htp.bodyClose;
2527: htp.p('
2528: htp.p('
');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
Line 2532: htp.htmlClose;
2528: htp.p('');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: htp.print('Error occured and control in exception');
Line 2536: htp.print('Error occured and control in exception');
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: htp.print('Error occured and control in exception');
2537: rollback;
2538: if (dc_cursor%isopen) then
2539: close dc_cursor;
2540: end if;
Line 2546: htp.htmlOpen;
2542:
2543: PROCEDURE PrintBlankPage
2544: IS
2545: BEGIN
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('
');
Line 2547: htp.bodyOpen;
2543: PROCEDURE PrintBlankPage
2544: IS
2545: BEGIN
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('
');
2551:
Line 2550: htp.p('');
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
Line 2552: htp.bodyClose;
2548:
2549: -- Body background color.
2550: htp.p('
');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
2555:
2556: /*===========================================================================
Line 2553: htp.htmlClose;
2549: -- Body background color.
2550: htp.p('
');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
2555:
2556: /*===========================================================================
2557:
Line 2592: htp.headOpen;
2588: end if;
2589: END IF;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
Line 2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2589: END IF;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
2597:
Line 2594: htp.headClose;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
2597:
2598: htp.p('
');
2600:
Line 2598: htp.p('');
2600:
2601: htp.htmlclose;
2602:
Line 2601: htp.htmlclose;
2597:
2598: htp.p('
');
2600:
2601: htp.htmlclose;
2602:
2603:
2604: END set_document_identifier;
2605:
322: --htp.tableRowOpen( cvalign => 'TOP' );
323: htp.tableRowOpen;
324: htp.p('
325: htp.p('
327: htp.p(' 328: 'VALUE="'||x_file_name|| '" SIZE="40">'||
329: l_search_document_URL);
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
Line 327: htp.p('
323: htp.tableRowOpen;
324: htp.p('
325: htp.p('
327: htp.p(' 328: 'VALUE="'||x_file_name|| '" SIZE="40">'||
329: l_search_document_URL);
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
331: cvalue=>x_file_name)|| l_search_document_URL,
Line 330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
326: htp.p('
327: htp.p(' 328: 'VALUE="'||x_file_name|| '" SIZE="40">'||
329: l_search_document_URL);
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
331: cvalue=>x_file_name)|| l_search_document_URL,
332: calign => 'left');*/
333: htp.tableRowClose;
334: htp.tableClose;
Line 333: htp.tableRowClose;
329: l_search_document_URL);
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
331: cvalue=>x_file_name)|| l_search_document_URL,
332: calign => 'left');*/
333: htp.tableRowClose;
334: htp.tableClose;
335:
336: htp.formHidden ( cname =>'text', cvalue=>'');
337: htp.formHidden ( cname =>'url', cvalue=>'');
Line 334: htp.tableClose;
330: /*htp.tableData( htf.formText( cname => 'dmid', csize => '70',
331: cvalue=>x_file_name)|| l_search_document_URL,
332: calign => 'left');*/
333: htp.tableRowClose;
334: htp.tableClose;
335:
336: htp.formHidden ( cname =>'text', cvalue=>'');
337: htp.formHidden ( cname =>'url', cvalue=>'');
338: end if;
Line 336: htp.formHidden ( cname =>'text', cvalue=>'');
332: calign => 'left');*/
333: htp.tableRowClose;
334: htp.tableClose;
335:
336: htp.formHidden ( cname =>'text', cvalue=>'');
337: htp.formHidden ( cname =>'url', cvalue=>'');
338: end if;
339:
340: end DocumentInformation;
Line 337: htp.formHidden ( cname =>'url', cvalue=>'');
333: htp.tableRowClose;
334: htp.tableClose;
335:
336: htp.formHidden ( cname =>'text', cvalue=>'');
337: htp.formHidden ( cname =>'url', cvalue=>'');
338: end if;
339:
340: end DocumentInformation;
341:
Line 409: htp.htmlOpen;
405: l_from_url := icx_call.decrypt2(UpdateAttachment.from_url);
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
407:
408: -- Call the procedure that prints header
409: htp.htmlOpen;
410: htp.headOpen;
411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
Line 410: htp.headOpen;
406: l_query_only := icx_call.decrypt2(UpdateAttachment.query_only);
407:
408: -- Call the procedure that prints header
409: htp.htmlOpen;
410: htp.headOpen;
411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
414: -- Call the procedure that prints header
Line 412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
408: -- Call the procedure that prints header
409: htp.htmlOpen;
410: htp.headOpen;
411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
414: -- Call the procedure that prints header
415: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
416: cname => 'top_frame', cmarginheight=>'0',
Line 415: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
411:
412: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
413:
414: -- Call the procedure that prints header
415: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
416: cname => 'top_frame', cmarginheight=>'0',
417: cmarginwidth=> '0', cscrolling => 'NO',
418: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
419:
Line 421: htp.frame (csrc => l_dcdname ||
417: cmarginwidth=> '0', cscrolling => 'NO',
418: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
419:
420: -- Print The Body of the Add Attachment page.
421: htp.frame (csrc => l_dcdname ||
422: '/fnd_webattch.PrintUpdateAttachment?attached_document_id='||
423: l_attached_document_id ||
424: '&'||'package_name='|| l_packagename ||
425: '&'||'function_name='||l_function_name ||
Line 439: htp.framesetclose;
435: cmarginheight=>'0', cmarginwidth=> '10', cscrolling => 'AUTO',
436: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
437:
438: -- Close the frameset.
439: htp.framesetclose;
440:
441: end UpdateAttachment;
442:
443:
Line 578: htp.htmlOpen;
574: l_from_url := icx_call.decrypt2(AddAttachment.from_url);
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
576:
577: -- Call the procedure that prints header
578: htp.htmlOpen;
579: htp.headOpen;
580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
Line 579: htp.headOpen;
575: l_query_only := icx_call.decrypt2(AddAttachment.query_only);
576:
577: -- Call the procedure that prints header
578: htp.htmlOpen;
579: htp.headOpen;
580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
583: -- Call the procedure that prints header
Line 581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
577: -- Call the procedure that prints header
578: htp.htmlOpen;
579: htp.headOpen;
580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
583: -- Call the procedure that prints header
584: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
585: cname => 'tooolbar_frame', cmarginheight=>'0',
Line 584: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
580:
581: htp.framesetopen(crows=>'60, *', cattributes =>'frameborder=no border=0');
582:
583: -- Call the procedure that prints header
584: htp.frame (csrc => l_dcdname || '/fnd_webattch.Header?Lang='||l_lang,
585: cname => 'tooolbar_frame', cmarginheight=>'0',
586: cmarginwidth=> '0', cscrolling => 'NO',
587: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
588:
Line 590: htp.frame (csrc => l_dcdname ||
586: cmarginwidth=> '0', cscrolling => 'NO',
587: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
588:
589: -- Print The Body of the Add Attachment page.
590: htp.frame (csrc => l_dcdname ||
591: '/fnd_webattch.PrintAddAttachment?package_name='||
592: l_packagename ||
593: '&'||'function_name='||l_function_name ||
594: '&'||'entity_name='||l_entity_name ||
Line 607: htp.framesetclose;
603: cmarginheight=>'0', cmarginwidth=> '10', cscrolling => 'AUTO',
604: cnoresize => 'NORESIZE', cattributes => 'FRAMEBORDER=NO');
605:
606: -- Close the frameset.
607: htp.framesetclose;
608:
609: end AddAttachment;
610:
611: -- ViewTextDocument
Line 772: -- This htp call is required for webDB implementation.
768: Add_Attachment(seq_num, category_id, document_description, datatype_id,
769: text, l_file_name, url, function_name, entity_name, pk1_value,
770: pk2_value, pk3_value, pk4_value, pk5_value, l_media_id, user_id);
771:
772: -- This htp call is required for webDB implementation.
773: htp.p('');
774:
775: END;
776:
Line 773: htp.p('');
769: text, l_file_name, url, function_name, entity_name, pk1_value,
770: pk2_value, pk3_value, pk4_value, pk5_value, l_media_id, user_id);
771:
772: -- This htp call is required for webDB implementation.
773: htp.p('');
774:
775: END;
776:
777: -- Add_Attachment
Line 1018: -- This htp call is required for webDB implementation.
1014: l_file_name, url, attached_document_id, datatype_id, function_name,
1015: entity_name, pk1_value, pk2_value, pk3_value, pk4_value, pk5_value,
1016: l_media_id, l_user_id);
1017:
1018: -- This htp call is required for webDB implementation.
1019: htp.p('');
1020:
1021: END;
1022:
Line 1019: htp.p('');
1015: entity_name, pk1_value, pk2_value, pk3_value, pk4_value, pk5_value,
1016: l_media_id, l_user_id);
1017:
1018: -- This htp call is required for webDB implementation.
1019: htp.p('');
1020:
1021: END;
1022:
1023: -- Update_Attachment
Line 1273: htp.htmlOpen;
1269: if NOT (icx_sec.ValidateSession(null)) then
1270: return;
1271: end if;
1272:
1273: htp.htmlOpen;
1274: htp.bodyOpen;
1275: -- Body background color.
1276: htp.p('
1277:
Line 1274: htp.bodyOpen;
1270: return;
1271: end if;
1272:
1273: htp.htmlOpen;
1274: htp.bodyOpen;
1275: -- Body background color.
1276: htp.p('
1277:
1278: icx_admin_sig.toolbar(language_code => Header.Lang);
Line 1276: htp.p('');
1272:
1273: htp.htmlOpen;
1274: htp.bodyOpen;
1275: -- Body background color.
1276: htp.p('');
1277:
1278: icx_admin_sig.toolbar(language_code => Header.Lang);
1279:
1280: -- Style sheet declaration.
Line 1281: htp.p('');
1277:
1278: icx_admin_sig.toolbar(language_code => Header.Lang);
1279:
1280: -- Style sheet declaration.
1281: htp.p('');
1282:
1283: htp.bodyClose;
1284: htp.htmlClose;
1285:
Line 1283: htp.bodyClose;
1279:
1280: -- Style sheet declaration.
1281: htp.p('');
1282:
1283: htp.bodyClose;
1284: htp.htmlClose;
1285:
1286: end Header;
1287:
Line 1284: htp.htmlClose;
1280: -- Style sheet declaration.
1281: htp.p('');
1282:
1283: htp.bodyClose;
1284: htp.htmlClose;
1285:
1286: end Header;
1287:
1288: -- PrintSummary
Line 1367: htp.htmlOpen;
1363:
1364: -- Set the title
1365: l_title := fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-TITLE');
1366:
1367: htp.htmlOpen;
1368: htp.headOpen;
1369: htp.p( '' );
1381: help_win = window.open('||
1382: fnd_help.get_url('ICX','@T_ATTACH')||
1383: ', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,'||
1384: 'height=250")}');
1385: htp.print( '' );
1386: htp.title(l_title);
1387:
1388: -- Add the java script to the header to open the dm window for
1389: -- any DM function that is executed.
Line 1386: htp.title(l_title);
1382: fnd_help.get_url('ICX','@T_ATTACH')||
1383: ', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,'||
1384: 'height=250")}');
1385: htp.print( '' );
1386: htp.title(l_title);
1387:
1388: -- Add the java script to the header to open the dm window for
1389: -- any DM function that is executed.
1390: fnd_document_management.get_open_dm_attach_window;
Line 1396: htp.p('');
1392: -- Add java script to the header to open display window
1393: fnd_document_management.get_open_dm_display_window;
1394:
1395: -- Style sheet declaration.
1396: htp.p('');
1397:
1398: htp.headClose;
1399: htp.bodyOpen;
1400:
Line 1398: htp.headClose;
1394:
1395: -- Style sheet declaration.
1396: htp.p('');
1397:
1398: htp.headClose;
1399: htp.bodyOpen;
1400:
1401: -- Body background color.
1402: htp.p('
Line 1399: htp.bodyOpen;
1395: -- Style sheet declaration.
1396: htp.p('');
1397:
1398: htp.headClose;
1399: htp.bodyOpen;
1400:
1401: -- Body background color.
1402: htp.p('
1403: htp.br;
Line 1402: htp.p('');
1398: htp.headClose;
1399: htp.bodyOpen;
1400:
1401: -- Body background color.
1402: htp.p('');
1403: htp.br;
1404:
1405:
1406: -- Process the cursor
Line 1403: htp.br;
1399: htp.bodyOpen;
1400:
1401: -- Body background color.
1402: htp.p('
1403: htp.br;
1404:
1405:
1406: -- Process the cursor
1407: open al_cursor;
Line 1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1407: open al_cursor;
1408: fetch al_cursor into atlstrec;
1409: if al_cursor%NOTFOUND then
1410: close al_cursor;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
Line 1412: htp.br;
1408: fetch al_cursor into atlstrec;
1409: if al_cursor%NOTFOUND then
1410: close al_cursor;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
Line 1413: htp.print( '' );
1409: if al_cursor%NOTFOUND then
1410: close al_cursor;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1417: -- Branch to the bottom header
Line 1414: htp.br;
1410: close al_cursor;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1417: -- Branch to the bottom header
1418: GOTO bottom_header;
Line 1415: htp.br;
1411: htp.bold(fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-NOATCHMTS'));
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1417: -- Branch to the bottom header
1418: GOTO bottom_header;
1419: end if;
Line 1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1412: htp.br;
1413: htp.print( '' );
1414: htp.br;
1415: htp.br;
1416: --htp.tableOpen( cattributes => ' border=1 cellpadding=3 bgcolor=white' );
1417: -- Branch to the bottom header
1418: GOTO bottom_header;
1419: end if;
1420:
Line 1422: htp.p('
| . | ');'|| 1426: fnd_message.get_string('FND','FND-WEBATCH-SUMMARY-HEADING') Line 1423: htp.p('
1419: end if;
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1694: htp.p('
1695: htp.p('
1696: end if;
1697:
1698: htp.bodyClose;
1699: htp.htmlClose;
1700:
1701: exception
1702: when others then
Line 1699: htp.htmlClose;
1695: htp.p('
2014: ''||
2015: fnd_message.get_string('FND', 'FND-WEBATCH-DOCUMENT-CATEGORY')
2016: || '
2017: htp.p('
2018: htp.formSelectOpen( cname => 'category_id' );
2019: FOR dc in doc_cat_cursor LOOP
2020: if (dc.user_name <> ' ' ) then
2021: if (dc.user_name <> x_category_description ) then
2022: htp.p('
Line 2031: htp.formSelectClose;
2141: htp.p('
2142: htp.p('
2143: htp.p('
2145: htp.p('');
2146: htp.p('
2147: ' 2148: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2149: ''||
Line 2146: htp.p(''||
2142: htp.p('
2143: htp.p('
2142: htp.p('
2145: htp.p('');
2146: htp.p('
2147: ' 2148: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2149: ''||
2150: fnd_message.get_string('FND','FND-WEBATCH-UPDATE-ATTACHMENT'));
Line 2151: htp.p('
2153: ' 2154: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2155: ''||
Line 2152: htp.p(''||
2148: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2149: ''||
2150: fnd_message.get_string('FND','FND-WEBATCH-UPDATE-ATTACHMENT'));
2151: htp.p('
');
2152: htp.p(''||
2153: '
2154: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2155: ''||
2156: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
Line 2157: htp.p('
');
2148: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2149: ''||
2150: fnd_message.get_string('FND','FND-WEBATCH-UPDATE-ATTACHMENT'));
2151: htp.p('
2153: ' 2154: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2155: ''||
2156: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
Line 2157: htp.p('
2158: htp.p('');
2159: htp.p('
Line 2158: htp.p('');
2154: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2155: ''||
2156: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2157: htp.p('');
2158: htp.p('');
2159: htp.p('
2162: htp.p('
Line 2159: htp.p('
2414: fnd_message.get_string('FND','FND-WEBATCH-FILE-DATATYPE')||'
2416: htp.p(' 2417: ' SIZE="32">');
2418: htp.tableRowClose;
2419:
2420: -- URL Datatype
2421: htp.tableRowOpen;
2422: htp.p('
Line 2421: htp.tableRowOpen;
2417: ' SIZE="32">');
2418: htp.tableRowClose;
2419:
2420: -- URL Datatype
2421: htp.tableRowOpen;
2422: htp.p('
2423: htp.p(' 2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
2418: htp.tableRowClose;
2419:
2420: -- URL Datatype
2421: htp.tableRowOpen;
2422: htp.p('
2423: htp.p(' 2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
2426: htp.p('
Line 2423: htp.p('
2419:
2420: -- URL Datatype
2421: htp.tableRowOpen;
2422: htp.p('
2423: htp.p(' 2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
2426: htp.p('
2427: htp.p('
Line 2426: htp.p('');
2422: htp.p('
');
2423: htp.p('
2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||' ');
2426: htp.p('');
2427: htp.p('
2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
Line 2427: htp.p('
2423: htp.p('
2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
');
2426: htp.p('');
2427: htp.p('
2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
2431: /*
Line 2429: htp.tableRowClose;
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
');
2426: htp.p('');
2427: htp.p('
2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
2431: /*
2432: ** Create the callback syntax to update the local fields
2433: */
Line 2449: htp.tableRowOpen;
2445: TRUE,
2446: l_search_document_URL);
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
Line 2450: htp.p('');
2446: l_search_document_URL);
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
2454: htp.p('');
Line 2451: htp.p('
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
2454: htp.p('');
2455: htp.p('
Line 2454: htp.p('');
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
Line 2455: htp.p('
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
Line 2457: htp.tableRowClose;
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
Line 2458: htp.tableClose;
2454: htp.p('
');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
Line 2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
Line 2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
Line 2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
Line 2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
Line 2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
Line 2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
Line 2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
Line 2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
Line 2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
Line 2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
Line 2471: htp.formHidden (cname =>'user_id',
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
2475:
Line 2473: htp.formHidden (cname =>'package_name',cvalue=>
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
2475:
2476: -- Submit and Reset Buttons.
2477: -- Create buttons for adding and back links.
Line 2478: htp.br;
2474: PrintAddAttachment.package_name );
2475:
2476: -- Submit and Reset Buttons.
2477: -- Create buttons for adding and back links.
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
Line 2479: htp.p('');
2481: htp.p('');
2482: htp.p('');
2483: htp.p('');
Line 2481: htp.p('');
2477: -- Create buttons for adding and back links.
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
Line 2482: htp.p('
');
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
Line 2483: htp.p('');
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
Line 2484: htp.p('');
2480: ' row defines the edges and tops-->');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
Line 2485: htp.p('
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
Line 2486: htp.p('
2482: htp.p('
');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
Line 2487: htp.p('
2483: htp.p('
');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
Line 2488: htp.p(' ');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
Line 2489: htp.p('
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
Line 2491: htp.p('');
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
Line 2492: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p('');
2496: htp.p('');
Line 2493: htp.p('
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
Line 2494: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
Line 2495: htp.p('
');
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p('');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
Line 2496: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
Line 2497: htp.p('');
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
Line 2498: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
Line 2499: htp.p('
2495: htp.p('
');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
Line 2500: htp.p('
2496: htp.p('
');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
Line 2501: htp.p('
');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p('');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
Line 2502: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
Line 2503: htp.p('');
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
Line 2504: htp.p(''||
2500: htp.p('
2501: htp.p('
');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
Line 2509: htp.p('
');
'||
2511: '
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
Line 2510: htp.p(''||
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
2509: htp.p('
');
2510: htp.p(''||
2511: '
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
Line 2515: htp.p('
');
');
2516: htp.p('');
2517: htp.p(' ');
2518:
2519: htp.p('');
Line 2516: htp.p('');
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2515: htp.p('');
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
Line 2517: htp.p('
');
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2515: htp.p('
');
2516: htp.p('');
2517: htp.p(' ');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
Line 2519: htp.p('');
2515: htp.p('');
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
Line 2520: htp.p('
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
Line 2521: htp.p('
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
Line 2522: htp.p('
2518:
2519: htp.p('
');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
Line 2523: htp.p('
');
2519: htp.p('
');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
Line 2524: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
Line 2525: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
Line 2526: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
Line 2527: htp.p('
2523: htp.p('
');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
Line 2528: htp.p('
');
2524: htp.p('
');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
Line 2529: htp.p('
');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p('');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
Line 2530: htp.formClose;
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
Line 2531: htp.bodyClose;
2527: htp.p('
2528: htp.p('
');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
Line 2532: htp.htmlClose;
2528: htp.p('');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: htp.print('Error occured and control in exception');
Line 2536: htp.print('Error occured and control in exception');
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: htp.print('Error occured and control in exception');
2537: rollback;
2538: if (dc_cursor%isopen) then
2539: close dc_cursor;
2540: end if;
Line 2546: htp.htmlOpen;
2542:
2543: PROCEDURE PrintBlankPage
2544: IS
2545: BEGIN
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('
');
Line 2547: htp.bodyOpen;
2543: PROCEDURE PrintBlankPage
2544: IS
2545: BEGIN
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('
');
2551:
Line 2550: htp.p('');
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
Line 2552: htp.bodyClose;
2548:
2549: -- Body background color.
2550: htp.p('
');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
2555:
2556: /*===========================================================================
Line 2553: htp.htmlClose;
2549: -- Body background color.
2550: htp.p('
');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
2555:
2556: /*===========================================================================
2557:
Line 2592: htp.headOpen;
2588: end if;
2589: END IF;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
Line 2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2589: END IF;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
2597:
Line 2594: htp.headClose;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
2597:
2598: htp.p('
');
2600:
Line 2598: htp.p('');
2600:
2601: htp.htmlclose;
2602:
Line 2601: htp.htmlclose;
2597:
2598: htp.p('
');
2600:
2601: htp.htmlclose;
2602:
2603:
2604: END set_document_identifier;
2605:
2422: htp.p('
2423: htp.p(' 2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
2427: htp.p(' 2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
Line 2427: htp.p('
2423: htp.p('
2424: 'type=radio value="5">'||
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
2427: htp.p(' 2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
2431: /*
Line 2429: htp.tableRowClose;
2425: fnd_message.get_string('FND','FND-WEBATCH-WEBPAGE-DATATYPE')||'
2427: htp.p(' 2428: ' SIZE="40">');
2429: htp.tableRowClose;
2430:
2431: /*
2432: ** Create the callback syntax to update the local fields
2433: */
Line 2449: htp.tableRowOpen;
2445: TRUE,
2446: l_search_document_URL);
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
2451: htp.p(' 2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
2446: l_search_document_URL);
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
2451: htp.p(' 2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
2454: htp.p('
Line 2451: htp.p('
2447:
2448: -- DM Datatype
2449: htp.tableRowOpen;
2450: htp.p('
2451: htp.p(' 2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
2454: htp.p('
2455: htp.p('
Line 2454: htp.p('');
2450: htp.p('
');
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||' ');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
Line 2455: htp.p('
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
Line 2457: htp.tableRowClose;
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
');
2454: htp.p('');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
Line 2458: htp.tableClose;
2454: htp.p('
');
2455: htp.p('
2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
Line 2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
Line 2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
Line 2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
Line 2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
Line 2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
Line 2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
Line 2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
Line 2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
Line 2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
Line 2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
Line 2471: htp.formHidden (cname =>'user_id',
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
2475:
Line 2473: htp.formHidden (cname =>'package_name',cvalue=>
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
2475:
2476: -- Submit and Reset Buttons.
2477: -- Create buttons for adding and back links.
Line 2478: htp.br;
2474: PrintAddAttachment.package_name );
2475:
2476: -- Submit and Reset Buttons.
2477: -- Create buttons for adding and back links.
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
Line 2479: htp.p('');
2481: htp.p('');
2482: htp.p('');
2483: htp.p('');
Line 2481: htp.p('');
2477: -- Create buttons for adding and back links.
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
Line 2482: htp.p('
');
2478: htp.br;
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
Line 2483: htp.p('');
2479: htp.p('');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
Line 2484: htp.p('');
2480: ' row defines the edges and tops-->');
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
Line 2485: htp.p('
2481: htp.p('
');
2482: htp.p('');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
Line 2486: htp.p('
2482: htp.p('
');
2483: htp.p('');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
Line 2487: htp.p('
2483: htp.p('
');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
Line 2488: htp.p(' ');
2484: htp.p('');
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
Line 2489: htp.p('
2485: htp.p('
2486: htp.p('
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
Line 2491: htp.p('');
2487: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
Line 2492: htp.p('
2488: htp.p(' ');
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p('');
2496: htp.p('');
Line 2493: htp.p('
2489: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
Line 2494: htp.p('
2490:
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
Line 2495: htp.p('
');
2491: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p('');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
Line 2496: htp.p('');
2492: htp.p('
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
Line 2497: htp.p('');
2493: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
Line 2498: htp.p('
2494: htp.p('
2495: htp.p(' ');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
Line 2499: htp.p('
2495: htp.p('
');
2496: htp.p('');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
Line 2500: htp.p('
2496: htp.p('
');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
Line 2501: htp.p('
');
2497: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p('');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
Line 2502: htp.p('');
2498: htp.p('
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
Line 2503: htp.p('');
2499: htp.p('
2500: htp.p('
2501: htp.p(' ');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
Line 2504: htp.p(''||
2500: htp.p('
2501: htp.p('
');
2502: htp.p('');
2503: htp.p('');
2504: htp.p(''||
2505: '
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
Line 2509: htp.p('
');
'||
2511: '
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
Line 2510: htp.p(''||
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
2509: htp.p('
');
2510: htp.p(''||
2511: '
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
Line 2515: htp.p('
');
');
2516: htp.p('');
2517: htp.p(' ');
2518:
2519: htp.p('');
Line 2516: htp.p('');
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2515: htp.p('');
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
Line 2517: htp.p('
');
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2515: htp.p('
');
2516: htp.p('');
2517: htp.p(' ');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
Line 2519: htp.p('');
2515: htp.p('');
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
Line 2520: htp.p('
2516: htp.p('');
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
Line 2521: htp.p('
2517: htp.p('
');
2518:
2519: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
Line 2522: htp.p('
2518:
2519: htp.p('
');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
Line 2523: htp.p('
');
2519: htp.p('
');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
Line 2524: htp.p('');
2520: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
Line 2525: htp.p('
2521: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
Line 2526: htp.p('
2522: htp.p('
2523: htp.p(' ');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
Line 2527: htp.p('
2523: htp.p('
');
2524: htp.p('');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
Line 2528: htp.p('
');
2524: htp.p('
');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
Line 2529: htp.p('
');
2525: htp.p('
2526: htp.p('
2527: htp.p('
2528: htp.p('');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
Line 2530: htp.formClose;
2526: htp.p('
2527: htp.p('
2528: htp.p(' ');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
Line 2531: htp.bodyClose;
2527: htp.p('
2528: htp.p('
');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
Line 2532: htp.htmlClose;
2528: htp.p('');
2529: htp.p('
');
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: htp.print('Error occured and control in exception');
Line 2536: htp.print('Error occured and control in exception');
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: htp.print('Error occured and control in exception');
2537: rollback;
2538: if (dc_cursor%isopen) then
2539: close dc_cursor;
2540: end if;
Line 2546: htp.htmlOpen;
2542:
2543: PROCEDURE PrintBlankPage
2544: IS
2545: BEGIN
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('
');
Line 2547: htp.bodyOpen;
2543: PROCEDURE PrintBlankPage
2544: IS
2545: BEGIN
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('
');
2551:
Line 2550: htp.p('');
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
Line 2552: htp.bodyClose;
2548:
2549: -- Body background color.
2550: htp.p('
');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
2555:
2556: /*===========================================================================
Line 2553: htp.htmlClose;
2549: -- Body background color.
2550: htp.p('
');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
2555:
2556: /*===========================================================================
2557:
Line 2592: htp.headOpen;
2588: end if;
2589: END IF;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
Line 2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2589: END IF;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
2597:
Line 2594: htp.headClose;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
2597:
2598: htp.p('
');
2600:
Line 2598: htp.p('');
2600:
2601: htp.htmlclose;
2602:
Line 2601: htp.htmlclose;
2597:
2598: htp.p('
');
2600:
2601: htp.htmlclose;
2602:
2603:
2604: END set_document_identifier;
2605:
2450: htp.p('
2451: htp.p(' 2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
2455: htp.p(' 2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
Line 2455: htp.p('
2451: htp.p('
2452: 'type=radio value="5">'||
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
2455: htp.p(' 2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
Line 2457: htp.tableRowClose;
2453: fnd_message.get_string('FND','FND-WEBATCH-DM-DATATYPE')||'
2455: htp.p(' 2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
Line 2458: htp.tableClose;
2454: htp.p('
2455: htp.p(' 2456: ' SIZE="40">'||l_search_document_URL);
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
Line 2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2457: htp.tableRowClose;
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
Line 2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2458: htp.tableClose;
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
Line 2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2459:
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
Line 2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2460: -- Set the data needed for add attachment as hidden field.
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
Line 2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2461: htp.formHidden (cname =>'access_id', cvalue=> to_char(access_id));
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
Line 2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2462: htp.formHidden (cname =>'function_name', cvalue=> function_name);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
Line 2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2463: htp.formHidden (cname =>'entity_name', cvalue=> entity_name);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
Line 2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2464: htp.formHidden (cname =>'pk1_value', cvalue=> pk1_value);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
Line 2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2465: htp.formHidden (cname =>'pk2_value', cvalue=> pk2_value);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
Line 2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2466: htp.formHidden (cname =>'pk3_value', cvalue=> pk3_value);
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
Line 2471: htp.formHidden (cname =>'user_id',
2467: htp.formHidden (cname =>'pk4_value', cvalue=> pk4_value);
2468: htp.formHidden (cname =>'pk5_value', cvalue=> pk5_value);
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
2475:
Line 2473: htp.formHidden (cname =>'package_name',cvalue=>
2469: htp.formHidden (cname =>'from_url', cvalue=> from_url);
2470: htp.formHidden (cname =>'query_only',cvalue=> query_only);
2471: htp.formHidden (cname =>'user_id',
2472: cvalue=> icx_sec.getID(icx_sec.PV_WEB_USER_ID));
2473: htp.formHidden (cname =>'package_name',cvalue=>
2474: PrintAddAttachment.package_name );
2475:
2476: -- Submit and Reset Buttons.
2477: -- Create buttons for adding and back links.
Line 2478: htp.br;
2474: PrintAddAttachment.package_name );
2475:
2476: -- Submit and Reset Buttons.
2477: -- Create buttons for adding and back links.
2478: htp.br;
2479: htp.p('');
2481: htp.p('
2482: htp.p('
| '); 2482: htp.p('
2530: htp.formClose; 2531: htp.bodyClose; 2532: htp.htmlClose; 2533: 2534: exception 2535: when others then Line 2532: htp.htmlClose; |
2499: htp.p('
2500: htp.p('
2501: htp.p('
2503: htp.p('');
2504: htp.p('
2505: ' 2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
Line 2504: htp.p(''||
2500: htp.p('
2501: htp.p('
2500: htp.p('
2503: htp.p('');
2504: htp.p('
2505: ' 2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
Line 2509: htp.p('
2511: ' 2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
Line 2510: htp.p(''||
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
2509: htp.p('
');
2510: htp.p(''||
2511: '
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
Line 2515: htp.p('
');
2506: ' OnMouseOver="window.status='''||'OK'||''';return true">'||
2507: ''||
2508: fnd_message.get_string('FND','FND-WEBATCH-ADD-ATTACHMENT'));
2509: htp.p('
2511: ' 2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
Line 2515: htp.p('
2516: htp.p('');
2517: htp.p('
Line 2516: htp.p('');
2512: ' OnMouseOver="window.status='''||'Reset'||''';return true">'||
2513: ''||
2514: fnd_message.get_string('FND','FND-WEBATCH-FORM-RESET'));
2515: htp.p('');
2516: htp.p('');
2517: htp.p('
2520: htp.p('
Line 2517: htp.p('
2530: htp.formClose;
2531: htp.bodyClose;
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: htp.print('Error occured and control in exception');
Line 2536: htp.print('Error occured and control in exception');
2532: htp.htmlClose;
2533:
2534: exception
2535: when others then
2536: htp.print('Error occured and control in exception');
2537: rollback;
2538: if (dc_cursor%isopen) then
2539: close dc_cursor;
2540: end if;
Line 2546: htp.htmlOpen;
2542:
2543: PROCEDURE PrintBlankPage
2544: IS
2545: BEGIN
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('
Line 2547: htp.bodyOpen;
2543: PROCEDURE PrintBlankPage
2544: IS
2545: BEGIN
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('
2551:
Line 2550: htp.p('');
2546: htp.htmlOpen;
2547: htp.bodyOpen;
2548:
2549: -- Body background color.
2550: htp.p('');
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
Line 2552: htp.bodyClose;
2548:
2549: -- Body background color.
2550: htp.p('
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
2555:
2556: /*===========================================================================
Line 2553: htp.htmlClose;
2549: -- Body background color.
2550: htp.p('
2551:
2552: htp.bodyClose;
2553: htp.htmlClose;
2554: END PrintBlankPage;
2555:
2556: /*===========================================================================
2557:
Line 2592: htp.headOpen;
2588: end if;
2589: END IF;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
Line 2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2589: END IF;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
2597:
Line 2594: htp.headClose;
2590:
2591:
2592: htp.headOpen;
2593: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
2594: htp.headClose;
2595:
2596: htp.htmlopen;
2597:
2598: htp.p('
2600:
Line 2598: htp.p('');
2600:
2601: htp.htmlclose;
2602:
Line 2601: htp.htmlclose;
2597:
2598: htp.p('
2600:
2601: htp.htmlclose;
2602:
2603:
2604: END set_document_identifier;
2605: