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_FIELD_VALUES

Line 76: || 'pon_forms_instances and pon_form_field_values tables');

72: p_request_id,
73: 'PON');
74: INSERT_DOC_UPLOAD_RECORD(p_document_id,l_form_id,NULL,NULL,NULL);
75: LOG_MESSAGE(l_module,'Document Upload record inserted into '
76: || 'pon_forms_instances and pon_form_field_values tables');
77: END;
78:
79: EXCEPTION
80: WHEN OTHERS THEN

Line 330: l_classcode_value pon_form_field_values.TEXTCOL1%TYPE; -- 13422278

326:
327: l_soap_operation VARCHAR2(100);
328: arch_date_query VARCHAR2(1000);
329:
330: l_classcode_value pon_form_field_values.TEXTCOL1%TYPE; -- 13422278
331: l_classcode_charvalue VARCHAR2(2);
332: l_classcode_query VARCHAR2(1000);
333:
334: l_setaside_code pon_form_field_values.TEXTCOL1%TYPE;

Line 334: l_setaside_code pon_form_field_values.TEXTCOL1%TYPE;

330: l_classcode_value pon_form_field_values.TEXTCOL1%TYPE; -- 13422278
331: l_classcode_charvalue VARCHAR2(2);
332: l_classcode_query VARCHAR2(1000);
333:
334: l_setaside_code pon_form_field_values.TEXTCOL1%TYPE;
335: l_setaside_code_query VARCHAR2(1000);
336: l_setaside_value PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
337: l_amendment_id pon_auctioN_headers_all.auction_Header_id%TYPE;
338:

Line 396: ' from pon_form_field_values ' ||

392: If it is alphanumeric, first character should be posted.
393: */
394: BEGIN
395: l_classcode_query := 'select ' || FED_CLASSCOD_COL ||
396: ' from pon_form_field_values ' ||
397: ' where entity_Pk1 = :doc_id and form_id = :form_id';
398:
399: EXECUTE IMMEDIATE l_classcode_query INTO l_classcode_value USING p_auction_header_id,p_form_id;
400: l_classcode_charvalue := To_Char(To_Number(SubStr(l_classcode_value,1,2)));

Line 442: ' from pon_form_field_values

438: -- bug 13462125
439: -- FBO site accepts only the meaning instead of code for SETASIDE field
440: BEGIN
441: l_setaside_code_query := 'select ' || FED_SETASIDE_COL ||
442: ' from pon_form_field_values
443: where entity_Pk1 = :doc_id and form_id = :form_id';
444:
445: EXECUTE IMMEDIATE l_setaside_code_query INTO l_setaside_code
446: USING p_auction_header_id,p_form_id;

Line 515: from pon_form_field_values

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'')
515: from pon_form_field_values
516: where entity_Pk1 = :doc_id and form_id = :form_id';
517:
518: EXECUTE IMMEDIATE arch_date_query INTO fed_archdate USING p_auction_header_id,p_form_id;
519:

Line 566: from pon_form_field_values WHERE entity_Pk1 = :doc_id and form_id = :form_id';

562: xmlelement("popzip",' || fed_popzip_col || '),
563: xmlelement("popcountry",' || fed_popcountry_col || '),
564: xmlelement("recovery_act",' || fed_recoveryact_col || ')
565: ))
566: from pon_form_field_values WHERE entity_Pk1 = :doc_id and form_id = :form_id';
567:
568: LOG_MESSAGE(l_module,'xml query constructed');
569:
570: EXECUTE IMMEDIATE query INTO x_xml USING p_auction_header_id,p_form_id;

Line 742: from pon_form_field_values WHERE entity_Pk1 = :doc_id and form_id = :form_id';

738: xmlelement("is_cd_avail",'|| FED_CDAVAIL_COL || '),
739: xmlelement("files",''''),
740: xmlelement("release",' || FED_RELEASE_COL || ')
741: ))
742: from pon_form_field_values WHERE entity_Pk1 = :doc_id and form_id = :form_id';
743:
744: LOG_MESSAGE(l_module,'xml query constructed');
745:
746: EXECUTE IMMEDIATE query INTO x_xml USING p_auction_header_id,p_form_id;

Line 825: l_ntype_val pon_form_field_values.TEXTCOL1%TYPE;

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:
828: BEGIN
829:

Line 851: ' from pon_form_field_values ' ||

847: -- NTYPE should be PRESOL while posting automatically
848: -- otherwise it should take value from user given value
849: BEGIN
850: l_ntype_query := 'select ' || FED_NTYPE_COL ||
851: ' from pon_form_field_values ' ||
852: ' where entity_Pk1 = :doc_id and form_id = :form_id';
853:
854: EXECUTE IMMEDIATE l_ntype_query INTO l_ntype_val
855: USING p_auction_header_id,p_form_id;

Line 1433: INSERT INTO pon_form_field_values(FORM_FIELD_VALUE_ID,

1429: SYSDATE,
1430: fnd_global.user_id,
1431: fnd_global.login_id);
1432:
1433: INSERT INTO pon_form_field_values(FORM_FIELD_VALUE_ID,
1434: FORM_ID,
1435: OWNING_ENTITY_CODE,
1436: ENTITY_PK1,
1437: SECTION_ID,

Line 1445: VALUES(pon_form_field_values_s.nextval,

1441: LAST_UPDATE_DATE,
1442: LAST_UPDATED_BY,
1443: LAST_UPDATE_LOGIN,
1444: Textcol1)
1445: VALUES(pon_form_field_values_s.nextval,
1446: p_form_id,
1447: 'PON_AUCTION_HEADERS_ALL',
1448: p_document_id,
1449: -1,