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_AUCTION_HEADERS_ALL

Line 21: l_header_id_orig_amend pon_auction_headers_all.auction_header_id_orig_amend%TYPE;

17: l_form_id pon_forms_sections.form_id%TYPE;
18: is_post_pending VARCHAR2(1);
19: is_docupload_inserted VARCHAR2(1);
20: l_module VARCHAR2(100) := 'VALIDATE_FBO_POSTING';
21: l_header_id_orig_amend pon_auction_headers_all.auction_header_id_orig_amend%TYPE;
22:
23: BEGIN
24:
25: IF g_debug_mode IS NULL THEN

Line 50: FROM pon_auction_headers_all WHERE auction_header_id = p_document_id;

46: LOG_MESSAGE(l_module,'Document Upload form_id ' || l_form_id);
47:
48: -- bug 13440212
49: SELECT auction_header_id_orig_amend INTO l_header_id_orig_amend
50: FROM pon_auction_headers_all WHERE auction_header_id = p_document_id;
51:
52: IS_PRESOL_PUBLISHED(l_header_id_orig_amend,x_result);
53:
54: IF x_result <> 'S' THEN

Line 280: pon_auction_headers_all pah,

276:
277: SELECT pah.document_number,pah.auctioN_title
278: INTO x_sol_number,x_sol_title
279: FROM
280: pon_auction_headers_all pah,
281: pon_bid_headers pbh
282: WHERE pbh.po_header_id = p_po_header_id
283: AND pbh.auction_header_id = pah.auction_header_id;
284:

Line 300: fed_solnbr pon_auction_headers_all.document_Number%TYPE;

296: l_pwd VARCHAR2(1000);
297: query VARCHAR2(20000);
298: l_form_code VARCHAR2(100);
299:
300: fed_solnbr pon_auction_headers_all.document_Number%TYPE;
301: fed_date VARCHAR2(1000);
302: fed_respdate VARCHAR2(1000);
303: fed_archdate VARCHAR2(1000);
304: FED_ZIP_COL VARCHAR2(1000);

Line 337: l_amendment_id pon_auctioN_headers_all.auction_Header_id%TYPE;

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:
339: BEGIN
340:
341: LOG_MESSAGE(l_module,'BEGIN paramters '||p_auction_header_id || ' ' || p_form_id);

Line 374: from pon_auction_headers_all

370: To_Char(SYSDATE,'YYYYMMDD'),
371: TO_CHAR(CLOSE_BIDDING_DATE, 'YYYYMMDD'),
372: TO_CHAR(CLOSE_BIDDING_DATE + 15, 'YYYYMMDD')
373: into fed_solnbr,fed_date, fed_respdate,fed_archdate
374: from pon_auction_headers_all
375: where auction_header_id = p_auction_header_id;
376:
377: SELECT MAPPING_FIELD_VALUE_COLUMN
378: INTO FED_ZIP_COL

Line 584: FROM pon_auction_headers_all

580: those attachments that were added or modified in the amendment
581: */
582: BEGIN
583: SELECT auction_header_id INTO l_amendment_id
584: FROM pon_auction_headers_all
585: WHERE auction_header_id_prev_amend =
586: (SELECT auction_header_id_prev_amend
587: FROM pon_auction_Headers_all
588: WHERE auction_header_Id = p_auction_header_id)

Line 587: FROM pon_auction_Headers_all

583: SELECT auction_header_id INTO l_amendment_id
584: FROM pon_auction_headers_all
585: WHERE auction_header_id_prev_amend =
586: (SELECT auction_header_id_prev_amend
587: FROM pon_auction_Headers_all
588: WHERE auction_header_Id = p_auction_header_id)
589: AND amendment_flag = 'Y'
590: AND amendment_Number > 0;
591: EXCEPTION

Line 605: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'

601: fnd_document_categories doccat
602: WHERE fad.document_id = fdvl.document_id
603: and fdvl.category_id = doccat.category_id
604: and doccat.name = l_doccat_name
605: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'
606: AND fad.pk1_value = Nvl(l_amendment_id,p_auction_header_id)
607: AND fl.file_id(+) = fdvl.media_id
608: AND fdvl.datatype_name = 'File') LOOP
609: files_temp_holder := '' || temp.filename || '';

Line 653: l_amendment_id pon_auctioN_headers_all.auction_Header_id%TYPE;

649: l_ntype_element VARCHAR2(100);
650: files_clob CLOB;
651: files_temp_holder VARCHAR2(1000);
652: l_soap_operation VARCHAR2(100) := 'createSecureDocumentPackage';
653: l_amendment_id pon_auctioN_headers_all.auction_Header_id%TYPE;
654:
655: BEGIN
656:
657: LOG_MESSAGE(l_module,'BEGIN paramters '||p_auction_header_id || ' ' || p_form_id);

Line 760: FROM pon_auction_headers_all

756: those attachments that were added or modified in the amendment
757: */
758: BEGIN
759: SELECT auction_header_id INTO l_amendment_id
760: FROM pon_auction_headers_all
761: WHERE auction_header_id_prev_amend =
762: (SELECT auction_header_id_prev_amend
763: FROM pon_auction_Headers_all
764: WHERE auction_header_Id = p_auction_header_id)

Line 763: FROM pon_auction_Headers_all

759: SELECT auction_header_id INTO l_amendment_id
760: FROM pon_auction_headers_all
761: WHERE auction_header_id_prev_amend =
762: (SELECT auction_header_id_prev_amend
763: FROM pon_auction_Headers_all
764: WHERE auction_header_Id = p_auction_header_id)
765: AND amendment_flag = 'Y'
766: AND amendment_Number > 0;
767: EXCEPTION

Line 781: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'

777: fnd_document_categories doccat
778: WHERE fad.document_id = fdvl.document_id
779: and fdvl.category_id = doccat.category_id
780: and doccat.name = 'ToFedBizOppsSecure'
781: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'
782: AND fad.pk1_value = nvl(l_amendment_id,p_auction_header_id)
783: AND fl.file_id(+) = fdvl.media_id
784: AND fdvl.datatype_name = 'File') LOOP
785: files_temp_holder := '' || temp.filename || '';

Line 812: fed_solnbr pon_auction_headers_all.document_Number%TYPE;

808: l_username VARCHAR2(1001);
809: l_pwd VARCHAR2(1000);
810: query VARCHAR2(20000);
811:
812: fed_solnbr pon_auction_headers_all.document_Number%TYPE;
813: fed_respdate VARCHAR2(1000);
814:
815: l_module VARCHAR2(100) := 'GET_DOCUPLOAD_XML';
816: files_clob CLOB;

Line 826: l_amendment_id pon_auctioN_headers_all.auction_Header_id%TYPE;

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:
830: LOG_MESSAGE(l_module,'BEGIN paramters '||p_auction_header_id || ' ' || p_form_id);

Line 837: from pon_auction_headers_all

833: l_pwd := fnd_profile.Value('PON_FBO_PASSWORD');
834:
835: select DOCUMENT_NUMBER,TO_CHAR(CLOSE_BIDDING_DATE, 'YYYYMMDD')
836: into fed_solnbr,fed_respdate
837: from pon_auction_headers_all
838: where auction_header_id = p_auction_header_id;
839:
840: SELECT MAPPING_FIELD_VALUE_COLUMN
841: INTO FED_NTYPE_COL

Line 907: FROM pon_auction_headers_all

903: those attachments that were added or modified in the amendment
904: */
905: BEGIN
906: SELECT auction_header_id INTO l_amendment_id
907: FROM pon_auction_headers_all
908: WHERE auction_header_id_prev_amend =
909: (SELECT auction_header_id_prev_amend
910: FROM pon_auction_Headers_all
911: WHERE auction_header_Id = p_auction_header_id)

Line 910: FROM pon_auction_Headers_all

906: SELECT auction_header_id INTO l_amendment_id
907: FROM pon_auction_headers_all
908: WHERE auction_header_id_prev_amend =
909: (SELECT auction_header_id_prev_amend
910: FROM pon_auction_Headers_all
911: WHERE auction_header_Id = p_auction_header_id)
912: AND amendment_flag = 'Y'
913: AND amendment_Number > 0;
914: EXCEPTION

Line 928: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'

924: fnd_document_categories doccat
925: WHERE fad.document_id = fdvl.document_id
926: and fdvl.category_id = doccat.category_id
927: and doccat.name in ('ToFedBizOpps','Vendor')
928: AND fad.entity_name = 'PON_AUCTION_HEADERS_ALL'
929: AND fad.pk1_value = Nvl(l_amendment_id,p_auction_header_id)
930: AND fl.file_id(+) = fdvl.media_id
931: AND fdvl.datatype_name = 'File') LOOP
932: files_temp_holder := '' || temp.filename || '';

Line 1306: l_sol_number pon_auctioN_headers_all.document_Number%TYPE;

1302:
1303: PROCEDURE NOTIFY_REQUESTORS(p_auction_header_id IN NUMBER,
1304: p_form_id IN NUMBER )
1305: AS
1306: l_sol_number pon_auctioN_headers_all.document_Number%TYPE;
1307: l_date_sent pon_forms_instances.fbo_date_sent%TYPE;
1308: l_username wf_users.name%type;
1309: l_user_display_name wf_users.display_name%TYPE;
1310: l_itemtype VARCHAR2(10) := 'PONFEDPS';

Line 1316: FROM pon_auctioN_Headers_all

1312:
1313: BEGIN
1314:
1315: SELECT document_Number INTO l_sol_number
1316: FROM pon_auctioN_Headers_all
1317: WHERE auctioN_header_id = p_auction_header_id;
1318:
1319: SELECT fbo_date_sent INTO l_date_sent
1320: FROM pon_forms_instances

Line 1423: VALUES('PON_AUCTION_HEADERS_ALL',

1419: CREATED_BY,
1420: LAST_UPDATE_DATE,
1421: LAST_UPDATED_BY,
1422: LAST_UPDATE_LOGIN)
1423: VALUES('PON_AUCTION_HEADERS_ALL',
1424: p_document_id,
1425: p_form_id,
1426: 'DATA_ENTERED',
1427: SYSDATE,

Line 1447: 'PON_AUCTION_HEADERS_ALL',

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,
1450: -1,
1451: SYSDATE,