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

APPS.PON_FBO_PKG dependencies on PON_FORM_SECTION_COMPILED

Line 379: FROM pon_form_section_compiled

375: where auction_header_id = p_auction_header_id;
376:
377: SELECT MAPPING_FIELD_VALUE_COLUMN
378: INTO FED_ZIP_COL
379: FROM pon_form_section_compiled
380: WHERE form_id = p_form_id
381: AND field_code = 'FED_ZIP';
382:
383: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 385: FROM pon_form_section_compiled

381: AND field_code = 'FED_ZIP';
382:
383: SELECT MAPPING_FIELD_VALUE_COLUMN
384: INTO FED_CLASSCOD_COL
385: FROM pon_form_section_compiled
386: WHERE form_id = p_form_id
387: AND field_code = 'FED_CLASSCOD';
388:
389: /*

Line 410: FROM pon_form_section_compiled

406: END;
407:
408: SELECT MAPPING_FIELD_VALUE_COLUMN
409: INTO fed_naics_col
410: FROM pon_form_section_compiled
411: WHERE form_id = p_form_id
412: AND field_code = 'FED_NAICS';
413:
414: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 416: FROM pon_form_section_compiled

412: AND field_code = 'FED_NAICS';
413:
414: SELECT MAPPING_FIELD_VALUE_COLUMN
415: INTO FED_SUBJECT_COL
416: FROM pon_form_section_compiled
417: WHERE form_id = p_form_id
418: AND field_code = 'FED_SUBJECT';
419:
420: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 422: FROM pon_form_section_compiled

418: AND field_code = 'FED_SUBJECT';
419:
420: SELECT MAPPING_FIELD_VALUE_COLUMN
421: INTO FED_CONTACT_COL
422: FROM pon_form_section_compiled
423: WHERE form_id = p_form_id
424: AND field_code = 'FED_CONTACT';
425:
426: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 428: FROM pon_form_section_compiled

424: AND field_code = 'FED_CONTACT';
425:
426: SELECT MAPPING_FIELD_VALUE_COLUMN
427: INTO FED_DESC_COL
428: FROM pon_form_section_compiled
429: WHERE form_id = p_form_id
430: AND field_code = 'FED_DESC';
431:
432: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 434: FROM pon_form_section_compiled

430: AND field_code = 'FED_DESC';
431:
432: SELECT MAPPING_FIELD_VALUE_COLUMN
433: INTO FED_SETASIDE_COL
434: FROM pon_form_section_compiled
435: WHERE form_id = p_form_id
436: AND field_code = 'FED_SETASIDE';
437:
438: -- bug 13462125

Line 460: FROM pon_form_section_compiled

456: END;
457:
458: SELECT MAPPING_FIELD_VALUE_COLUMN
459: INTO FED_URL_COL
460: FROM pon_form_section_compiled
461: WHERE form_id = p_form_id
462: AND field_code = 'FED_URL';
463:
464: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 466: FROM pon_form_section_compiled

462: AND field_code = 'FED_URL';
463:
464: SELECT MAPPING_FIELD_VALUE_COLUMN
465: INTO FED_URL_DESC_COL
466: FROM pon_form_section_compiled
467: WHERE form_id = p_form_id
468: AND field_code = 'FED_URL_DESC';
469:
470: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 472: FROM pon_form_section_compiled

468: AND field_code = 'FED_URL_DESC';
469:
470: SELECT MAPPING_FIELD_VALUE_COLUMN
471: INTO FED_EMAIL_ADDRESS_COL
472: FROM pon_form_section_compiled
473: WHERE form_id = p_form_id
474: AND field_code = 'FED_EMAIL_ADDRESS';
475:
476: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 478: FROM pon_form_section_compiled

474: AND field_code = 'FED_EMAIL_ADDRESS';
475:
476: SELECT MAPPING_FIELD_VALUE_COLUMN
477: INTO FED_EMAIL_DESC_COL
478: FROM pon_form_section_compiled
479: WHERE form_id = p_form_id
480: AND field_code = 'FED_EMAIL_DESC';
481:
482: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 484: FROM pon_form_section_compiled

480: AND field_code = 'FED_EMAIL_DESC';
481:
482: SELECT MAPPING_FIELD_VALUE_COLUMN
483: INTO FED_POPADDRESS_COL
484: FROM pon_form_section_compiled
485: WHERE form_id = p_form_id
486: AND field_code = 'FED_POPADDRESS';
487:
488: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 490: FROM pon_form_section_compiled

486: AND field_code = 'FED_POPADDRESS';
487:
488: SELECT MAPPING_FIELD_VALUE_COLUMN
489: INTO FED_POPZIP_COL
490: FROM pon_form_section_compiled
491: WHERE form_id = p_form_id
492: AND field_code = 'FED_POPZIP';
493:
494: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 496: FROM pon_form_section_compiled

492: AND field_code = 'FED_POPZIP';
493:
494: SELECT MAPPING_FIELD_VALUE_COLUMN
495: INTO FED_POPCOUNTRY_COL
496: FROM pon_form_section_compiled
497: WHERE form_id = p_form_id
498: AND field_code = 'FED_POPCOUNTRY';
499:
500: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 502: FROM pon_form_section_compiled

498: AND field_code = 'FED_POPCOUNTRY';
499:
500: SELECT MAPPING_FIELD_VALUE_COLUMN
501: INTO FED_RECOVERYACT_COL
502: FROM pon_form_section_compiled
503: WHERE form_id = p_form_id
504: AND field_code = 'FED_RECOVERY_ACT';
505:
506: IF l_form_code = 'FED_SOURCES_SOUGHT' THEN

Line 510: FROM pon_form_section_compiled

506: IF l_form_code = 'FED_SOURCES_SOUGHT' THEN
507: BEGIN
508: SELECT MAPPING_FIELD_VALUE_COLUMN
509: INTO FED_RESPONSEDATE_COL
510: FROM pon_form_section_compiled
511: WHERE form_id = p_form_id
512: AND field_code = 'FED_RESPONSEDATE';
513:
514: arch_date_query := 'select to_char(' || FED_RESPONSEDATE_COL ||'+15,''YYYYMMDD'')

Line 665: FROM pon_form_section_compiled

661: WHERE form_id = p_form_id;
662:
663: SELECT MAPPING_FIELD_VALUE_COLUMN
664: INTO FED_PRNUMBER_COL
665: FROM pon_form_section_compiled
666: WHERE form_id = p_form_id
667: AND field_code = 'FED_PR_NUMBER';
668:
669: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 671: FROM pon_form_section_compiled

667: AND field_code = 'FED_PR_NUMBER';
668:
669: SELECT MAPPING_FIELD_VALUE_COLUMN
670: INTO fed_PKGLABEL_col
671: FROM pon_form_section_compiled
672: WHERE form_id = p_form_id
673: AND field_code = 'FED_PACKAGE_LABEL';
674:
675: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 677: FROM pon_form_section_compiled

673: AND field_code = 'FED_PACKAGE_LABEL';
674:
675: SELECT MAPPING_FIELD_VALUE_COLUMN
676: INTO FED_PROJECTNUMBER_COL
677: FROM pon_form_section_compiled
678: WHERE form_id = p_form_id
679: AND field_code = 'FED_PROJECTNUMBER';
680:
681: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 683: FROM pon_form_section_compiled

679: AND field_code = 'FED_PROJECTNUMBER';
680:
681: SELECT MAPPING_FIELD_VALUE_COLUMN
682: INTO FED_NSNMMAC_COL
683: FROM pon_form_section_compiled
684: WHERE form_id = p_form_id
685: AND field_code = 'FED_NSNMMAC';
686:
687: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 689: FROM pon_form_section_compiled

685: AND field_code = 'FED_NSNMMAC';
686:
687: SELECT MAPPING_FIELD_VALUE_COLUMN
688: INTO FED_PARTNUMBER_COL
689: FROM pon_form_section_compiled
690: WHERE form_id = p_form_id
691: AND field_code = 'FED_PARTNUMBER';
692:
693: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 695: FROM pon_form_section_compiled

691: AND field_code = 'FED_PARTNUMBER';
692:
693: SELECT MAPPING_FIELD_VALUE_COLUMN
694: INTO FED_NOMENCLATURE_COL
695: FROM pon_form_section_compiled
696: WHERE form_id = p_form_id
697: AND field_code = 'FED_NOMENCLATURE';
698:
699: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 701: FROM pon_form_section_compiled

697: AND field_code = 'FED_NOMENCLATURE';
698:
699: SELECT MAPPING_FIELD_VALUE_COLUMN
700: INTO FED_EXPORTCONTROL_COL
701: FROM pon_form_section_compiled
702: WHERE form_id = p_form_id
703: AND field_code = 'FED_EXPORT_CONTROLLED';
704:
705: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 707: FROM pon_form_section_compiled

703: AND field_code = 'FED_EXPORT_CONTROLLED';
704:
705: SELECT MAPPING_FIELD_VALUE_COLUMN
706: INTO FED_EXPLICITACCESS_COL
707: FROM pon_form_section_compiled
708: WHERE form_id = p_form_id
709: AND field_code = 'FED_EXPLICIT_ACCESS';
710:
711: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 713: FROM pon_form_section_compiled

709: AND field_code = 'FED_EXPLICIT_ACCESS';
710:
711: SELECT MAPPING_FIELD_VALUE_COLUMN
712: INTO FED_CDAVAIL_COL
713: FROM pon_form_section_compiled
714: WHERE form_id = p_form_id
715: AND field_code = 'FED_IS_CD_AVAIL';
716:
717: SELECT MAPPING_FIELD_VALUE_COLUMN

Line 719: FROM pon_form_section_compiled

715: AND field_code = 'FED_IS_CD_AVAIL';
716:
717: SELECT MAPPING_FIELD_VALUE_COLUMN
718: INTO FED_RELEASE_COL
719: FROM pon_form_section_compiled
720: WHERE form_id = p_form_id
721: AND field_code = 'FED_RELEASE';
722:
723:

Line 823: FED_NTYPE_COL pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN%TYPE;

819: l_pdfname VARCHAR2(1000);
820: l_pdfdata CLOB;
821: l_soap_operation VARCHAR2(100) := 'submitDocumentsAndLinksToNotice';
822:
823: FED_NTYPE_COL pon_form_section_compiled.MAPPING_FIELD_VALUE_COLUMN%TYPE;
824: l_ntype_query VARCHAR2(1000);
825: l_ntype_val pon_form_field_values.TEXTCOL1%TYPE;
826: l_amendment_id pon_auctioN_headers_all.auction_Header_id%TYPE;
827:

Line 842: FROM pon_form_section_compiled

838: where auction_header_id = p_auction_header_id;
839:
840: SELECT MAPPING_FIELD_VALUE_COLUMN
841: INTO FED_NTYPE_COL
842: FROM pon_form_section_compiled
843: WHERE form_id = p_form_id
844: AND field_code = 'FED_NTYPE_DOCUPLOAD'; -- bug 13484000
845:
846: -- bug 13434496