' ||
Line 362: htp.p(' ');
358:
359: htp.p('');
360:
361: ELSE
362: htp.p('');
363: htp.p(' ' ||
364: fnd_message.get_string('ICX','ICX_POS_SUPP_NO_ACCESS') || ' ');
365: htp.p('
');
366: END IF;
Line 363: htp.p(' ' ||
359: htp.p('');
360:
361: ELSE
362: htp.p('
');
363: htp.p(' ' ||
364: fnd_message.get_string('ICX','ICX_POS_SUPP_NO_ACCESS') || ' ');
365: htp.p('
');
366: END IF;
367:
Line 365: htp.p('
');
361: ELSE
362: htp.p('
');
363: htp.p(' ' ||
364: fnd_message.get_string('ICX','ICX_POS_SUPP_NO_ACCESS') || ' ');
365: htp.p('
');
366: END IF;
367:
368: if l_po_number is not null then
369: veera_debug('criteria_frame: po number not null');
Line 370: htp.p('');
373: end if;
374:
Line 371: htp.p('document.POS_ACK_SEARCH.submit(); ');
367:
368: if l_po_number is not null then
369: veera_debug('criteria_frame: po number not null');
370: htp.p('');
373: end if;
374:
375: htp.bodyClose;
Line 372: htp.p('');
368: if l_po_number is not null then
369: veera_debug('criteria_frame: po number not null');
370: htp.p('');
373: end if;
374:
375: htp.bodyClose;
376: htp.htmlClose;
Line 375: htp.bodyClose;
371: htp.p('document.POS_ACK_SEARCH.submit(); ');
372: htp.p('');
373: end if;
374:
375: htp.bodyClose;
376: htp.htmlClose;
377:
378: Veera_Debug('End Criteria_Frame');
379: END CRITERIA_FRAME;
Line 376: htp.htmlClose;
372: htp.p('');
373: end if;
374:
375: htp.bodyClose;
376: htp.htmlClose;
377:
378: Veera_Debug('End Criteria_Frame');
379: END CRITERIA_FRAME;
380:
Line 389: htp.htmlopen;
385: IF NOT icx_sec.validatesession THEN
386: RETURN;
387: END IF;
388:
389: htp.htmlopen;
390: htp.headOpen;
391: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
392: htp.headClose;
393: htp.bodyOpen;
Line 390: htp.headOpen;
386: RETURN;
387: END IF;
388:
389: htp.htmlopen;
390: htp.headOpen;
391: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
392: htp.headClose;
393: htp.bodyOpen;
394: htp.p('
');
Line 391: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
387: END IF;
388:
389: htp.htmlopen;
390: htp.headOpen;
391: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
392: htp.headClose;
393: htp.bodyOpen;
394: htp.p('
');
395:
Line 392: htp.headClose;
388:
389: htp.htmlopen;
390: htp.headOpen;
391: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
392: htp.headClose;
393: htp.bodyOpen;
394: htp.p('
');
395:
396: htp.p('');
Line 393: htp.bodyOpen;
389: htp.htmlopen;
390: htp.headOpen;
391: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
392: htp.headClose;
393: htp.bodyOpen;
394: htp.p('
');
395:
396: htp.p('');
397:
Line 394: htp.p('');
390: htp.headOpen;
391: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
392: htp.headClose;
393: htp.bodyOpen;
394: htp.p('');
395:
396: htp.p('
');
397:
398: /* if the supplier is not set up for the user dont show the enter criteria message. instead
Line 396: htp.p(' ');
392: htp.headClose;
393: htp.bodyOpen;
394: htp.p('
');
395:
396: htp.p('');
397:
398: /* if the supplier is not set up for the user dont show the enter criteria message. instead
399: clear the frame so that a message is shown in the criteris frame */
400: if l_supplier_contact <> -1 then
Line 402: htp.p(' ' ||
398: /* if the supplier is not set up for the user dont show the enter criteria message. instead
399: clear the frame so that a message is shown in the criteris frame */
400: if l_supplier_contact <> -1 then
401: -- Row with 'Enter Criteria ; * means required field
402: htp.p(' ' ||
403: fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_CRITERIA') || ' ');
404:
405: else
406: htp.p(' ' ||
Line 406: htp.p(' ' ||
402: htp.p('
' ||
403: fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_CRITERIA') || ' ');
404:
405: else
406: htp.p(' ' ||
407: ' ');
408: end if;
409:
410: htp.p('
');
Line 410: htp.p('
');
406: htp.p('
' ||
407: ' ');
408: end if;
409:
410: htp.p('
');
411:
412: htp.bodyClose;
413: htp.htmlClose;
414: END FIXED_FRAME;
Line 412: htp.bodyClose;
408: end if;
409:
410: htp.p('
');
411:
412: htp.bodyClose;
413: htp.htmlClose;
414: END FIXED_FRAME;
415:
416: PROCEDURE COUNTER_FRAME (
Line 413: htp.htmlClose;
409:
410: htp.p('
');
411:
412: htp.bodyClose;
413: htp.htmlClose;
414: END FIXED_FRAME;
415:
416: PROCEDURE COUNTER_FRAME (
417: p_first IN NUMBER DEFAULT 0,
Line 431: htp.htmlopen;
427: IF NOT icx_sec.validatesession THEN
428: RETURN;
429: END IF;
430:
431: htp.htmlopen;
432: htp.headOpen;
433: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
434: htp.headClose;
435: htp.bodyOpen;
Line 432: htp.headOpen;
428: RETURN;
429: END IF;
430:
431: htp.htmlopen;
432: htp.headOpen;
433: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
434: htp.headClose;
435: htp.bodyOpen;
436: htp.p('
');
Line 433: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
429: END IF;
430:
431: htp.htmlopen;
432: htp.headOpen;
433: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
434: htp.headClose;
435: htp.bodyOpen;
436: htp.p('
');
437: htp.p(' ');
Line 434: htp.headClose;
430:
431: htp.htmlopen;
432: htp.headOpen;
433: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
434: htp.headClose;
435: htp.bodyOpen;
436: htp.p('
');
437: htp.p(' ');
438: if p_total > 0 then
Line 435: htp.bodyOpen;
431: htp.htmlopen;
432: htp.headOpen;
433: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
434: htp.headClose;
435: htp.bodyOpen;
436: htp.p('
');
437: htp.p(' ');
438: if p_total > 0 then
439: l_msg := fnd_message.get_string('ICX','ICX_POS_ACK_PO_COUNTER');
Line 436: htp.p('');
432: htp.headOpen;
433: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
434: htp.headClose;
435: htp.bodyOpen;
436: htp.p('');
437: htp.p('
');
438: if p_total > 0 then
439: l_msg := fnd_message.get_string('ICX','ICX_POS_ACK_PO_COUNTER');
440:
Line 437: htp.p(' ');
433: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
434: htp.headClose;
435: htp.bodyOpen;
436: htp.p('
');
437: htp.p(' ');
438: if p_total > 0 then
439: l_msg := fnd_message.get_string('ICX','ICX_POS_ACK_PO_COUNTER');
440:
441: l_msg := replace(l_msg, '&TOTAL', to_char(p_total));
Line 445: --htp.p(l_msg);
441: l_msg := replace(l_msg, '&TOTAL', to_char(p_total));
442: l_msg := replace(l_msg, '&FROM', to_char(p_first));
443: l_msg := replace(l_msg, '&TO', to_char(p_last));
444:
445: --htp.p(l_msg);
446:
447: htp.p('
448:
449:
Line 447: htp.p('
443: l_msg := replace(l_msg, '&TO', to_char(p_last));
444:
445: --htp.p(l_msg);
446:
447: htp.p('
448:
449:
450: ' ||
451: fnd_message.get_string('ICX', 'ICX_POS_ACK_SELECT_RESULT') ||
Line 460: htp.bodyClose;
456: '
'
457: );
458:
459: end if;
460: htp.bodyClose;
461: htp.htmlClose;
462: END COUNTER_FRAME;
463:
464: PROCEDURE BLANK_FRAME (
Line 461: htp.htmlClose;
457: );
458:
459: end if;
460: htp.bodyClose;
461: htp.htmlClose;
462: END COUNTER_FRAME;
463:
464: PROCEDURE BLANK_FRAME (
465: l_called_from IN NUMBER DEFAULT 0,
Line 494: htp.htmlOpen;
490: veera_debug('Org Id: ' || to_char(l_org_id) || 'User Id: ' ||
491: to_char(l_user_id) || 'Resp ID: ' || to_char(l_responsibility_id) ||
492: 'Session Id: ' || to_char(l_session_id));
493:
494: htp.htmlOpen;
495: htp.headOpen;
496: js.scriptOpen;
497: icx_util.LOVscript;
498: htp.p('
Line 495: htp.headOpen;
491: to_char(l_user_id) || 'Resp ID: ' || to_char(l_responsibility_id) ||
492: 'Session Id: ' || to_char(l_session_id));
493:
494: htp.htmlOpen;
495: htp.headOpen;
496: js.scriptOpen;
497: icx_util.LOVscript;
498: htp.p('
499:
Line 498: htp.p('
494: htp.htmlOpen;
495: htp.headOpen;
496: js.scriptOpen;
497: icx_util.LOVscript;
498: htp.p('
499:
500: function openDlg(l_rows) {
501: var winWidth = 400;
502: var winHeight = 200;
Line 530: htp.headClose;
526: openDlg(p_rows_inserted);
527: }
528: ');
529: js.scriptClose;
530: htp.headClose;
531: htp.bodyOpen;
532: if l_called_from <> 0 then
533: l_msg := fnd_message.get_string('ICX','ICX_POS_ACK_TOTAL_PO_SUB');
534:
Line 531: htp.bodyOpen;
527: }
528: ');
529: js.scriptClose;
530: htp.headClose;
531: htp.bodyOpen;
532: if l_called_from <> 0 then
533: l_msg := fnd_message.get_string('ICX','ICX_POS_ACK_TOTAL_PO_SUB');
534:
535: l_msg := replace(l_msg, '&TOTAL', to_char(l_rows_inserted));
Line 536: htp.p('
537: to_char(l_rows_inserted) || ', ''' || l_msg || ''')">');
538: else
539: htp.p('');
540: end if;
Line 539: htp.p('');
535: l_msg := replace(l_msg, '&TOTAL', to_char(l_rows_inserted));
536: htp.p('
');
538: else
539: htp.p('');
540: end if;
541: htp.bodyClose;
542: htp.htmlClose;
543: veera_debug('End Blank_Frame');
Line 541: htp.bodyClose;
537: to_char(l_rows_inserted) || ', ''' || l_msg || ''')">');
538: else
539: htp.p('
');
540: end if;
541: htp.bodyClose;
542: htp.htmlClose;
543: veera_debug('End Blank_Frame');
544: END BLANK_FRAME;
545:
Line 542: htp.htmlClose;
538: else
539: htp.p('
');
540: end if;
541: htp.bodyClose;
542: htp.htmlClose;
543: veera_debug('End Blank_Frame');
544: END BLANK_FRAME;
545:
546: PROCEDURE ADD_FRAME (
Line 560: htp.htmlOpen;
556: IF NOT icx_sec.validatesession THEN
557: RETURN;
558: END IF;
559:
560: htp.htmlOpen;
561: htp.headOpen;
562: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
563: htp.headClose;
564: htp.bodyOpen;
Line 561: htp.headOpen;
557: RETURN;
558: END IF;
559:
560: htp.htmlOpen;
561: htp.headOpen;
562: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
563: htp.headClose;
564: htp.bodyOpen;
565:
Line 562: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
558: END IF;
559:
560: htp.htmlOpen;
561: htp.headOpen;
562: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
563: htp.headClose;
564: htp.bodyOpen;
565:
566: -- Bug 1785297 mji
Line 563: htp.headClose;
559:
560: htp.htmlOpen;
561: htp.headOpen;
562: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
563: htp.headClose;
564: htp.bodyOpen;
565:
566: -- Bug 1785297 mji
567: l_msg := fnd_message.get_string('ICX', 'ICX_POS_ACK_SUBMIT');
Line 564: htp.bodyOpen;
560: htp.htmlOpen;
561: htp.headOpen;
562: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
563: htp.headClose;
564: htp.bodyOpen;
565:
566: -- Bug 1785297 mji
567: l_msg := fnd_message.get_string('ICX', 'ICX_POS_ACK_SUBMIT');
568:
Line 569: htp.p('
616: ');
617: htp.p('');
618:
619: if p_total > 0 then
620:
621: button('javascript:SubmitAcknowledge()',
Line 629: htp.bodyClose;
625: fnd_message.get_string('ICX', 'ICX_POS_BTN_CANCEL'));
626:
627: end if;
628:
629: htp.bodyClose;
630: htp.htmlClose;
631: END ADD_FRAME;
632:
633: FUNCTION GET_SUPPLIER_ID
Line 630: htp.htmlClose;
626:
627: end if;
628:
629: htp.bodyClose;
630: htp.htmlClose;
631: END ADD_FRAME;
632:
633: FUNCTION GET_SUPPLIER_ID
634: (
Line 676: htp.p(' ');
672: l_session_id NUMBER := icx_sec.getID(icx_sec.PV_SESSION_ID);
673: l_where_clause VARCHAR2(2000) := '';
674: BEGIN
675: Veera_Debug('Paint_Search: Po Number: ' || l_po_number);
676: htp.p('');
677:
678: htp.p('');
679: htp.p('');
680: htp.p('' ||
Line 678: htp.p('');
674: BEGIN
675: Veera_Debug('Paint_Search: Po Number: ' || l_po_number);
676: htp.p('
');
677:
678: htp.p('');
679: htp.p('');
680: htp.p('' ||
681: ' ' ||
682: ' ' ||
Line 679: htp.p('');
675: Veera_Debug('Paint_Search: Po Number: ' || l_po_number);
676: htp.p('
');
677:
678: htp.p('');
679: htp.p('');
680: htp.p('' ||
681: ' ' ||
682: ' ' ||
683: ' ');
Line 680: htp.p('' ||
676: htp.p('
');
677:
678: htp.p('');
679: htp.p('');
680: htp.p(' ' ||
681: ' ' ||
682: ' ' ||
683: ' ');
684: htp.p(' ');
Line 684: htp.p('');
680: htp.p('
' ||
681: ' ' ||
682: ' ' ||
683: ' ');
684: htp.p('');
685: htp.p('
');
686:
687: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
688: p_parent_region_code => 'POS_ACK_SEARCH_R',
Line 685: htp.p('
');
681: ' ' ||
682: ' ' ||
683: ' ');
684: htp.p('
');
685: htp.p('
');
686:
687: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
688: p_parent_region_code => 'POS_ACK_SEARCH_R',
689: p_where_clause => l_where_clause,
Line 698: htp.p(' ');
694:
695: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
696: l_result_index := ak_query_pkg.g_results_table.FIRST;
697:
698: htp.p('');
699:
700: htp.p('');
701:
702: l_current_col := 0;
Line 700: htp.p('');
696: l_result_index := ak_query_pkg.g_results_table.FIRST;
697:
698: htp.p('
');
699:
700: htp.p('');
701:
702: l_current_col := 0;
703:
704: WHILE (l_attribute_index IS NOT NULL) LOOP
Line 709: htp.p('');
711: IF item_code(l_attribute_index) = 'POS_ACK_SR_ROW_NUM' then
712: htp.p('
708: IF (item_style(l_attribute_index) = 'HIDDEN') THEN
709: htp.p('');
711: IF item_code(l_attribute_index) = 'POS_ACK_SR_ROW_NUM' then
712: htp.p(' ');
715: ELSIF item_code(l_attribute_index) = 'POS_ACK_SR_ACC_STATUS' then
716: htp.p('
712: htp.p(' ');
715: ELSIF item_code(l_attribute_index) = 'POS_ACK_SR_ACC_STATUS' then
716: htp.p(' ');
719: ELSE
720: htp.p('
716: htp.p(' ');
719: ELSE
720: htp.p(' ');
724: END IF;
Line 728: htp.p('
724: END IF;
725: ELSIF item_displayed(l_attribute_index) THEN
726: IF (item_style(l_attribute_index) = 'TEXT') THEN
727: IF item_updateable(l_attribute_index) THEN
728: htp.p('
729: item_valign(l_attribute_index) || ' WIDTH=30% ' || '>' ||
730: item_reqd(l_attribute_index) || ''
731: || item_name(l_attribute_index) || ' ' || ' ' ||
732: ' ');
Line 736: htp.p('
732: '
');
733:
734: IF item_code(l_attribute_index) = 'POS_ACK_SR_PO_NUMBER' THEN
735: veera_debug('Inside if of pos_ack_sr_po_number');
736: htp.p('
737: '>' || ''||
738: ' ');
742: else
743: veera_debug('Inside else of pos_ack_sr_po_number');
744: htp.p('
745: '>' || ''||
746: '
748: nvl(get_result_value(l_result_index, l_current_col), '') ||
749: '" >
');
750: end if;
751: IF (ak_query_pkg.g_items_table(l_attribute_index).lov_region_code IS NOT NULL AND ak_query_pkg.g_items_table(l_attribute_index).lov_attribute_code IS NOT NULL) THEN
752: htp.p('
755: BORDER=0 WIDTH=23 HEIGHT=21 border=no align=absmiddle>
756: ');
Line 761: htp.p('' ||
757: END IF;
758: IF item_code(l_attribute_index) = 'POS_ACK_SR_ACC_REQD_START_DATE' THEN
759: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
760: l_current_col := l_current_col + 1;
761: htp.p('' ||
762: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long ||
763: ' ');
764: htp.p('
760: l_current_col := l_current_col + 1;
761: htp.p('' ||
762: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long ||
763: ' ');
764: htp.p('
767: ' MAXLENGTH='||
768: ak_query_pkg.g_items_table(l_attribute_index).attribute_value_length||
Line 771: htp.p('
');
767: ' MAXLENGTH='||
768: ak_query_pkg.g_items_table(l_attribute_index).attribute_value_length||
769: '>');
770: END IF;
771: htp.p('');
772: ELSE
773: htp.p('
774: item_halign(l_attribute_index) ||
775: item_valign(l_attribute_index) || ' WIDTH=175 ' || '>' ||
Line 773: htp.p('
769: '>');
770: END IF;
771: htp.p('
');
772: ELSE
773: htp.p('
774: item_halign(l_attribute_index) ||
775: item_valign(l_attribute_index) || ' WIDTH=175 ' || '>' ||
776: '' || item_name(l_attribute_index)
777: || ' ' || ' ');
Line 779: htp.p('
775: item_valign(l_attribute_index) || ' WIDTH=175 ' || '>' ||
776: '' || item_name(l_attribute_index)
777: || ' ' || '
');
778:
779: htp.p('
780: item_valign(l_attribute_index) ||
781: '>' || '' ||
782: nvl(get_result_value(l_result_index, l_current_col), '&nbs
783: p') ||
Line 789: htp.p('
785:
786: END IF;
787: ELSIF (item_style(l_attribute_index) = 'POPLIST') THEN
788: IF item_updateable(l_attribute_index) THEN
789: htp.p('
790: item_valign(l_attribute_index) || ' WIDTH=30% ' || '>' ||
791: '' || item_name(l_attribute_index)
792: || ' ' || ' ' || ' ');
793:
Line 794: htp.p('
790: item_valign(l_attribute_index) || ' WIDTH=30% ' || '>' ||
791: '' || item_name(l_attribute_index)
792: || ' ' || ' ' || '
');
793:
794: htp.p('
795: ' WIDTH=350 ' || '>' || ''||
796: '' ||
797: get_option_string(l_attribute_index) ||
798: ' ');
Line 800: htp.p('
796: '' ||
797: get_option_string(l_attribute_index) ||
798: '
');
799: ELSE
800: htp.p('
801: item_halign(l_attribute_index) ||
802: item_valign(l_attribute_index) || ' WIDTH=175 ' || '>' ||
803: '' || item_name(l_attribute_index)
804: || ' ' || ' ');
Line 805: htp.p('
801: item_halign(l_attribute_index) ||
802: item_valign(l_attribute_index) || ' WIDTH=175 ' || '>' ||
803: '' || item_name(l_attribute_index)
804: || ' ' || '
');
805: htp.p('
806: item_valign(l_attribute_index) || ' WIDTH=350 ' || '>' ||
807: '' ||
808: nvl(get_result_value(l_result_index, l_current_col), ' ') ||
809: ' ');
Line 820: htp.p('');
816:
817: if ((l_current_col mod 1) = 0) THEN
818: l_row := l_row + 1;
819: IF l_row = 1 THEN
820: htp.p('
');
821:
822: --button('javascript:top.SearchPOs()', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
823: button('javascript:document.POS_ACK_SEARCH.submit(); ', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
824:
Line 825: htp.p(' ');
821:
822: --button('javascript:top.SearchPOs()', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
823: button('javascript:document.POS_ACK_SEARCH.submit(); ', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
824:
825: htp.p('
');
826: htp.p('');
827:
828: button('javascript:clearsearchfields()', fnd_message.get_string('ICX', 'ICX_POS_CLEAR'));
829:
Line 826: htp.p('');
822: --button('javascript:top.SearchPOs()', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
823: button('javascript:document.POS_ACK_SEARCH.submit(); ', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
824:
825: htp.p('
');
826: htp.p(' ');
827:
828: button('javascript:clearsearchfields()', fnd_message.get_string('ICX', 'ICX_POS_CLEAR'));
829:
830: htp.p(' ');
Line 830: htp.p(' ');
826: htp.p('
');
827:
828: button('javascript:clearsearchfields()', fnd_message.get_string('ICX', 'ICX_POS_CLEAR'));
829:
830: htp.p(' ');
831:
832:
833: END IF;
834: htp.p(' ');
Line 834: htp.p('');
830: htp.p('');
831:
832:
833: END IF;
834: htp.p('');
835: htp.p('
');
836: end if;
837:
838: END LOOP;
Line 835: htp.p('');
831:
832:
833: END IF;
834: htp.p('
');
835: htp.p('');
836: end if;
837:
838: END LOOP;
839:
Line 840: htp.p(' ');
836: end if;
837:
838: END LOOP;
839:
840: htp.p('
');
841: htp.p('
');
842:
843: END Paint_Search_Fields;
844:
Line 841: htp.p('
');
837:
838: END LOOP;
839:
840: htp.p('');
841: htp.p('
');
842:
843: END Paint_Search_Fields;
844:
845: PROCEDURE RESULT_POS
Line 923: htp.htmlOpen;
919: l_start_row := to_number(pos_ack_sr_row_num);
920: l_end_row := l_start_row + 25 -1;
921: end if;
922:
923: htp.htmlOpen;
924: -- Header Start
925:
926: htp.headOpen;
927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
Line 926: htp.headOpen;
922:
923: htp.htmlOpen;
924: -- Header Start
925:
926: htp.headOpen;
927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
928: js.scriptOpen;
929: icx_util.LOVscript;
930: htp.p('
Line 927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
923: htp.htmlOpen;
924: -- Header Start
925:
926: htp.headOpen;
927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
928: js.scriptOpen;
929: icx_util.LOVscript;
930: htp.p('
931:
Line 930: htp.p('
926: htp.headOpen;
927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
928: js.scriptOpen;
929: icx_util.LOVscript;
930: htp.p('
931:
932: function LoadCounter(p_start, p_end, p_total)
933: {
934: var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" +
Line 1031: htp.headClose;
1027:
1028:
1029: ');
1030: js.scriptClose;
1031: htp.headClose;
1032:
1033: -- Header End
1034: /*
1035: select count(*) into l_count
Line 1048: htp.p('
1049: '1, ' || to_char(l_count) || ',' || to_char(l_count) ||
1050: ')">');
1051:
1052:
Line 1054: htp.p(' ');
Line 1059: htp.p(' ' ||
1056: ' ' ||
1057: ' ' ||
1058: ' ');
1059: htp.p('');
1061:
1062:
1063: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
Line 1065: htp.p(' ');
1061:
1062:
1063: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1064: paint_edit_pos(to_number(pos_ack_sr_row_num));
1065: htp.p('');
1066: else
1067: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p(' ');
Line 1067: htp.p('');
1063: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1064: paint_edit_pos(to_number(pos_ack_sr_row_num));
1065: htp.p('');
1066: else
1067: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p(' ');
1070: end if;
1071:
Line 1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1064: paint_edit_pos(to_number(pos_ack_sr_row_num));
1065: htp.p('');
1066: else
1067: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p(' ');
1070: end if;
1071:
1072: htp.p('');
Line 1069: htp.p('');
1065: htp.p('');
1066: else
1067: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p(' ');
1070: end if;
1071:
1072: htp.p('');
1073: htp.htmlClose;
Line 1072: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p('');
1070: end if;
1071:
1072: htp.p('');
1073: htp.htmlClose;
1074: END RESULT_POS;
1075:
1076: PROCEDURE SHOW_POS(
Line 1073: htp.htmlClose;
1069: htp.p('');
1070: end if;
1071:
1072: htp.p('');
1073: htp.htmlClose;
1074: END RESULT_POS;
1075:
1076: PROCEDURE SHOW_POS(
1077: pos_ack_sr_row_num IN VARCHAR2 default '0',
Line 1087: htp.htmlOpen;
1083: l_msg1 VARCHAR2(240);
1084: l_msg2 VARCHAR2(240);
1085: BEGIN
1086: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1087: htp.htmlOpen;
1088:
1089: htp.headOpen;
1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1091: js.scriptOpen;
Line 1089: htp.headOpen;
1085: BEGIN
1086: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1087: htp.htmlOpen;
1088:
1089: htp.headOpen;
1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1091: js.scriptOpen;
1092: icx_util.LOVscript;
1093: htp.p('
Line 1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1086: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1087: htp.htmlOpen;
1088:
1089: htp.headOpen;
1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1091: js.scriptOpen;
1092: icx_util.LOVscript;
1093: htp.p('
1094:
Line 1093: htp.p('
1089: htp.headOpen;
1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1091: js.scriptOpen;
1092: icx_util.LOVscript;
1093: htp.p('
1094:
1095: function call_LOV1(c_attribute_code)
1096: {
1097: var c_where_clause = "";
Line 1186: htp.headClose;
1182: }
1183:
1184: ');
1185: js.scriptClose;
1186: htp.headClose;
1187:
1188: select count(*) into l_count
1189: from pos_ack_select;
1190:
Line 1197: htp.p('
1198: '1, ' || to_char(l_count) || ',' || to_char(l_count) ||
1199: ',' || to_char(l_rows_inserted) ||
1200: ', ''' || l_msg1 || ''',''' || l_msg2 || '''' ||
1201: ')">');
Line 1206: htp.p(' ' ||
1202:
1203:
1204: if l_count > 0 then
1205: --test
1206: htp.p('' ||
1207: ' ' ||
1208: ' ' ||
1209: ' ' ||
1210: '
');
Line 1212: htp.p(' ' ||
1209: ' ' ||
1210: ' ');
1211: --test
1212: htp.p('');
1214:
1215:
1216: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
Line 1218: htp.p(' ');
1214:
1215:
1216: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1217: paint_edit_pos(to_number(pos_ack_sr_row_num));
1218: htp.p('');
1219: else
1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1221: end if;
1222:
Line 1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1216: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1217: paint_edit_pos(to_number(pos_ack_sr_row_num));
1218: htp.p('');
1219: else
1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1221: end if;
1222:
1223: htp.p('');
1224: htp.htmlClose;
Line 1223: htp.p('');
1219: else
1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1221: end if;
1222:
1223: htp.p('');
1224: htp.htmlClose;
1225: END SHOW_POS;
1226:
1227: FUNCTION item_color(l_index in number) RETURN VARCHAR2 IS
Line 1224: htp.htmlClose;
1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1221: end if;
1222:
1223: htp.p('');
1224: htp.htmlClose;
1225: END SHOW_POS;
1226:
1227: FUNCTION item_color(l_index in number) RETURN VARCHAR2 IS
1228: BEGIN
Line 1430: htp.p('
1426: procedure button(src IN varchar2,
1427: txt IN varchar2) IS
1428: BEGIN
1429:
1430: htp.p('
1431:
1432:
1433:
1434:
Line 1461: htp.p('
1457: src2 IN varchar2,
1458: txt2 IN varchar2) IS
1459: BEGIN
1460:
1461: htp.p('
1462:
1463:
1464:
1465:
Line 1551: htp.p(' '
1547:
1548: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
1549: veera_debug('After AK Select' || to_char(ak_query_pkg.g_items_table.count));
1550:
1551: htp.p(''
1552: );
1553: htp.p('');
1554:
1555:
Line 1553: htp.p('');
1549: veera_debug('After AK Select' || to_char(ak_query_pkg.g_items_table.count));
1550:
1551: htp.p('
'
1552: );
1553: htp.p('');
1554:
1555:
1556: -- Print the table heading
1557: htp.p('');
Line 1557: htp.p(' ');
1553: htp.p('
');
1554:
1555:
1556: -- Print the table heading
1557: htp.p('');
1558:
1559: htp.p('');
1560:
1561: WHILE (l_attribute_index IS NOT NULL) LOOP
Line 1559: htp.p('');
1555:
1556: -- Print the table heading
1557: htp.p('
');
1558:
1559: htp.p('');
1560:
1561: WHILE (l_attribute_index IS NOT NULL) LOOP
1562: IF (item_style(l_attribute_index) = 'HIDDEN') THEN
1563: htp.p('' );
1565: ELSIF item_displayed(l_attribute_index) THEN
1566: htp.p('
1567: item_halign(l_attribute_index) ||
Line 1566: htp.p('
1562: IF (item_style(l_attribute_index) = 'HIDDEN') THEN
1563: htp.p('' );
1565: ELSIF item_displayed(l_attribute_index) THEN
1566: htp.p('
1567: item_halign(l_attribute_index) ||
1568: --item_valign(l_attribute_index) ||
1569: ' valign=bottom' ||
1570: '>' ||
Line 1573: --htp.p('' || item_name(l_attribute_index) || ' ');
1569: ' valign=bottom' ||
1570: '>' ||
1571: item_reqd(l_attribute_index)
1572: );
1573: --htp.p('' || item_name(l_attribute_index) || ' ');
1574: htp.p('' || item_name(l_attribute_index) || ' ');
1575: htp.p('
');
1576: END IF;
1577:
Line 1574: htp.p('' || item_name(l_attribute_index) || ' ');
1570: '>' ||
1571: item_reqd(l_attribute_index)
1572: );
1573: --htp.p('' || item_name(l_attribute_index) || ' ');
1574: htp.p('' || item_name(l_attribute_index) || ' ');
1575: htp.p('
');
1576: END IF;
1577:
1578: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
Line 1575: htp.p('');
1571: item_reqd(l_attribute_index)
1572: );
1573: --htp.p('' || item_name(l_attribute_index) || ' ');
1574: htp.p('' || item_name(l_attribute_index) || ' ');
1575: htp.p('');
1576: END IF;
1577:
1578: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
1579: END LOOP;
Line 1581: htp.p('  ');
1577:
1578: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
1579: END LOOP;
1580: --test promise date
1581: htp.p('
  ');
1582: --test promise date
1583:
1584: htp.p(' ');
1585:
Line 1584: htp.p('');
1580: --test promise date
1581: htp.p('
  ');
1582: --test promise date
1583:
1584: htp.p('');
1585:
1586: ----- end print table heading ----
1587:
1588:
Line 1604: htp.p('');
1600: GOTO my_point2;
1601: end if;
1602: --
1603: if ((l_current_row mod 2) = 0) THEN
1604: htp.p('');
1605: else
1606: htp.p(' ');
1607: end if;
1608: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
Line 1606: htp.p('');
1602: --
1603: if ((l_current_row mod 2) = 0) THEN
1604: htp.p('
');
1605: else
1606: htp.p('');
1607: end if;
1608: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
1609: l_current_col := 0;
1610: WHILE (l_attribute_index IS NOT NULL) LOOP
Line 1614: htp.p('
1610: WHILE (l_attribute_index IS NOT NULL) LOOP
1611: l_current_col := l_current_col + 1;
1612: -- hardcode radio buttons
1613: IF (item_code(l_attribute_index) = 'POS_ACK_ACCEPT') THEN
1614: htp.p('
1615: item_halign(l_attribute_index) ||
1616: item_valign(l_attribute_index) ||
1617: '>' ||
1618: '' || '' ||
1634:
1635: ELSIF (item_code(l_attribute_index) = 'POS_ACK_PO_NUMBER') THEN
1636: htp.p('
');
1637: htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1638: --htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1639: htp.p(' ');
1640: l_po_num := get_result_value(l_result_index, l_current_col);
1641: GOTO my_point;
1642:
Line 1639: htp.p(' ');
1635: ELSIF (item_code(l_attribute_index) = 'POS_ACK_PO_NUMBER') THEN
1636: htp.p('
');
1637: htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1638: --htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1639: htp.p(' ');
1640: l_po_num := get_result_value(l_result_index, l_current_col);
1641: GOTO my_point;
1642:
1643: ELSIF (item_code(l_attribute_index) = 'POS_ACK_BUYER') THEN
Line 1644: htp.p('');
1640: l_po_num := get_result_value(l_result_index, l_current_col);
1641: GOTO my_point;
1642:
1643: ELSIF (item_code(l_attribute_index) = 'POS_ACK_BUYER') THEN
1644: htp.p('
');
1645: htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1646: --htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1647: htp.p(' ');
1648: GOTO my_point;
Line 1645: htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1641: GOTO my_point;
1642:
1643: ELSIF (item_code(l_attribute_index) = 'POS_ACK_BUYER') THEN
1644: htp.p('
');
1645: htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1646: --htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1647: htp.p(' ');
1648: GOTO my_point;
1649:
Line 1646: --htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1642:
1643: ELSIF (item_code(l_attribute_index) = 'POS_ACK_BUYER') THEN
1644: htp.p('
');
1645: htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1646: --htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1647: htp.p(' ');
1648: GOTO my_point;
1649:
1650: END IF;
Line 1647: htp.p('');
1643: ELSIF (item_code(l_attribute_index) = 'POS_ACK_BUYER') THEN
1644: htp.p('
');
1645: htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1646: --htp.p('' || nvl(get_result_value(l_result_index, l_current_col), ' ') || ' ');
1647: htp.p(' ');
1648: GOTO my_point;
1649:
1650: END IF;
1651: IF (item_style(l_attribute_index) = 'HIDDEN') THEN
Line 1660: /*htp.p(' ' ;
1659:
1660: /*htp.p(' '); */
1663: ELSE
1664: IF item_displayed(l_attribute_index) THEN
Line 1667: htp.p('
1663: ELSE
1664: IF item_displayed(l_attribute_index) THEN
1665: IF (item_style(l_attribute_index) = 'TEXT' ) THEN
1666: IF item_updateable(l_attribute_index) THEN
1667: htp.p('
1668: item_halign(l_attribute_index) ||
1669: item_valign(l_attribute_index) ||
1670: '>' ||
1671: '' ||
Line 1681: htp.p(' '
1678: );
1679: IF (ak_query_pkg.g_items_table(l_attribute_index).lov_region_code IS NOT NULL AND ak_query_pkg.g_items_table(l_attribute_index).lov_attribute_code IS NOT NULL) THEN
1680: /*
1681: htp.p('
1683: '> ');
1684: */
1685: htp.p('
1681: htp.p('
1683: '> ');
1684: */
1685: htp.p('
1688: '> ');
1689: END IF;
Line 1690: htp.p('');
1686: ak_query_pkg.g_items_table(l_attribute_index).attribute_code || ''''|| ',' || ''''|| to_char(l_current_row-1) || '''' || ',' || ''''|| l_script_name ||
1687: ''')"' ||
1688: '> ');
1689: END IF;
1690: htp.p('');
1691:
1692: --LOV Test
1693: -- '');
1694: ELSE
Line 1695: htp.p('
1691:
1692: --LOV Test
1693: -- '
');
1694: ELSE
1695: htp.p('
1696: item_halign(l_attribute_index) ||
1697: item_valign(l_attribute_index) ||
1698: '>' ||
1699: '' ||
Line 1706: htp.p('
1702:
1703: END IF;
1704: ELSIF (item_style(l_attribute_index) = 'CHECKBOX') THEN
1705: l_current_col := l_current_col -1;
1706: htp.p('
1707: item_halign(l_attribute_index) ||
1708: item_valign(l_attribute_index) ||
1709: '>' ||
1710: '' ||
Line 1717: htp.p('
1713: ' value="' || to_char(l_current_row) ||
1714: '" >
');
1715: ELSIF (item_style(l_attribute_index) = 'IMAGE') THEN
1716: l_current_col := l_current_col -1;
1717: htp.p('
1718: item_halign(l_attribute_index) ||
1719: item_valign(l_attribute_index) ||
1720: '>' ||
1721: '
1735: ''''|| l_po_num ||'''' || ')"> ' ||
1736: fnd_message.get_string('ICX','ICX_POS_ACK_PROMISED_DATE') ||
1737: ' ' || l_hidden_fields_string || ' ');
Line 1739: htp.p(' ');
1735: ''''|| l_po_num ||'''' || ')"> ' ||
1736: fnd_message.get_string('ICX','ICX_POS_ACK_PROMISED_DATE') ||
1737: ' ' || l_hidden_fields_string || '');
1738: -- test promise date
1739: htp.p('
');
1740: <>
1741: l_result_index := ak_query_pkg.g_results_table.NEXT(l_result_index);
1742: END LOOP;
1743: END IF;
Line 1745: htp.p('
');
1741: l_result_index := ak_query_pkg.g_results_table.NEXT(l_result_index);
1742: END LOOP;
1743: END IF;
1744:
1745: htp.p('
');
1746: htp.p('
');
1747:
1748: END paint_edit_pos;
1749:
Line 1746: htp.p('
');
1742: END LOOP;
1743: END IF;
1744:
1745: htp.p('
');
1746: htp.p('
');
1747:
1748: END paint_edit_pos;
1749:
1750: PROCEDURE Find_Matching_Rows (
Line 2173: htp.htmlOpen;
2169: IS
2170: BEGIN
2171: -- delete from veera_debug;
2172: -- commit;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
Line 2174: htp.headOpen;
2170: BEGIN
2171: -- delete from veera_debug;
2172: -- commit;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
Line 2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2171: -- delete from veera_debug;
2172: -- commit;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
Line 2176: htp.p('');
2172: -- commit;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
Line 2177: htp.headClose;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2181: END CLEAR_LOG;
Line 2178: htp.bodyOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2181: END CLEAR_LOG;
2182:
Line 2179: htp.bodyClose;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2181: END CLEAR_LOG;
2182:
2183: PROCEDURE DISPLAY_LOG
Line 2180: htp.htmlClose;
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2181: END CLEAR_LOG;
2182:
2183: PROCEDURE DISPLAY_LOG
2184: IS
Line 2190: htp.htmlOpen;
2186: CURSOR debug_cursor IS
2187: select sysdate from dual;
2188: BEGIN
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
Line 2191: htp.headOpen;
2187: select sysdate from dual;
2188: BEGIN
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('
');
Line 2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2188: BEGIN
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('
');
2196:
Line 2193: htp.headClose;
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('
');
2196:
2197: LOOP
Line 2194: htp.bodyOpen;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('
');
2196:
2197: LOOP
2198: FETCH debug_cursor
Line 2195: htp.p('');
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('');
2196:
2197: LOOP
2198: FETCH debug_cursor
2199: INTO debug_string;
Line 2200: htp.p(debug_string || ' ');
2196:
2197: LOOP
2198: FETCH debug_cursor
2199: INTO debug_string;
2200: htp.p(debug_string || ' ');
2201: EXIT WHEN debug_cursor%NOTFOUND;
2202: END LOOP;
2203: CLOSE debug_cursor;
2204:
Line 2205: htp.bodyClose;
2201: EXIT WHEN debug_cursor%NOTFOUND;
2202: END LOOP;
2203: CLOSE debug_cursor;
2204:
2205: htp.bodyClose;
2206: htp.htmlClose;
2207: END DISPLAY_LOG;
2208:
2209: END POS_ACK_SEARCH;
Line 2206: htp.htmlClose;
2202: END LOOP;
2203: CLOSE debug_cursor;
2204:
2205: htp.bodyClose;
2206: htp.htmlClose;
2207: END DISPLAY_LOG;
2208:
2209: END POS_ACK_SEARCH;