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_FORMS_UTIL_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 443: select AWARD_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

439:
440:
441: if p_field_code = 'AWARD_DATE' then
442:
443: select AWARD_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
444:
445: elsif p_field_code = 'CLOSE_DATE' then
446:
447: select CLOSE_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 447: select CLOSE_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

443: select AWARD_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
444:
445: elsif p_field_code = 'CLOSE_DATE' then
446:
447: select CLOSE_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
448:
449: elsif p_field_code = 'OPEN_DATE' then
450:
451: select OPEN_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 451: select OPEN_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

447: select CLOSE_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
448:
449: elsif p_field_code = 'OPEN_DATE' then
450:
451: select OPEN_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
452:
453: elsif p_field_code = 'PREVIEW_DATE' then
454:
455: select VIEW_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 455: select VIEW_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

451: select OPEN_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
452:
453: elsif p_field_code = 'PREVIEW_DATE' then
454:
455: select VIEW_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
456:
457: end if;
458:
459: print_debug_log(l_api_name, 'END rt_date = '||rt_date);

Line 503: select PAYMENT_TERMS_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

499: print_debug_log(l_api_name, 'l_stmt = '||l_stmt);
500:
501: if p_field_code = 'PAYMENT_TERMS' then
502:
503: select PAYMENT_TERMS_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
504:
505: elsif p_field_code = 'ORGANIZATION' then
506:
507: select ORG_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 507: select ORG_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

503: select PAYMENT_TERMS_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
504:
505: elsif p_field_code = 'ORGANIZATION' then
506:
507: select ORG_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
508:
509: elsif p_field_code = 'AUCTION_HEADER_ID' then
510:
511: select AUCTION_HEADER_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 511: select AUCTION_HEADER_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

507: select ORG_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
508:
509: elsif p_field_code = 'AUCTION_HEADER_ID' then
510:
511: select AUCTION_HEADER_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
512:
513: end if;
514:
515: print_debug_log(l_api_name, 'END rt_value = '||rt_value);

Line 562: select ABSTRACT_STATUS into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

558: print_debug_log(l_api_name, 'l_stmt = '||l_stmt);
559:
560: if p_field_code = 'ABSTRACT_STATUS' then
561:
562: select ABSTRACT_STATUS into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
563:
564: elsif p_field_code = 'AMENDMENT_DESCRIPTION' then
565:
566: select AMENDMENT_DESCRIPTION into rt_large_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 566: select AMENDMENT_DESCRIPTION into rt_large_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

562: select ABSTRACT_STATUS into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
563:
564: elsif p_field_code = 'AMENDMENT_DESCRIPTION' then
565:
566: select AMENDMENT_DESCRIPTION into rt_large_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
567:
568: elsif p_field_code = 'TITLE' then
569:
570: select AUCTION_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 570: select AUCTION_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

566: select AMENDMENT_DESCRIPTION into rt_large_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
567:
568: elsif p_field_code = 'TITLE' then
569:
570: select AUCTION_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
571:
572: elsif p_field_code = 'STYLE' then
573:
574: select BID_VISIBILITY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 574: select BID_VISIBILITY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

570: select AUCTION_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
571:
572: elsif p_field_code = 'STYLE' then
573:
574: select BID_VISIBILITY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
575:
576: elsif p_field_code = 'CARRIER' then
577:
578: select CARRIER_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 578: select CARRIER_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

574: select BID_VISIBILITY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
575:
576: elsif p_field_code = 'CARRIER' then
577:
578: select CARRIER_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
579:
580: elsif p_field_code = 'NEGOTIATION_CURR' then
581:
582: select CURRENCY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 582: select CURRENCY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

578: select CARRIER_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
579:
580: elsif p_field_code = 'NEGOTIATION_CURR' then
581:
582: select CURRENCY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
583:
584: elsif p_field_code = 'NEGOTIATION_NUM' then
585:
586: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 586: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

582: select CURRENCY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
583:
584: elsif p_field_code = 'NEGOTIATION_NUM' then
585:
586: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
587:
588: elsif p_field_code = 'EVENT' then
589:
590: select EVENT_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 590: select EVENT_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

586: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
587:
588: elsif p_field_code = 'EVENT' then
589:
590: select EVENT_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
591:
592: elsif p_field_code = 'FOB' then
593:
594: select FOB_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 594: select FOB_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

590: select EVENT_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
591:
592: elsif p_field_code = 'FOB' then
593:
594: select FOB_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
595:
596: elsif p_field_code = 'FREIGHT_TERMS' then
597:
598: select FREIGHT_TERMS_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 598: select FREIGHT_TERMS_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

594: select FOB_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
595:
596: elsif p_field_code = 'FREIGHT_TERMS' then
597:
598: select FREIGHT_TERMS_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
599:
600: elsif p_field_code = 'BUYER' then
601:
602: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 602: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

598: select FREIGHT_TERMS_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
599:
600: elsif p_field_code = 'BUYER' then
601:
602: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
603:
604: elsif p_field_code = 'PAYMENT_TERMS_NAME' then
605:
606: select atvl_1.NAME

Line 609: PON_AUCTION_HEADERS_ALL ah,

605:
606: select atvl_1.NAME
607: into rt_value
608: from
609: PON_AUCTION_HEADERS_ALL ah,
610: AP_TERMS_VL atvl_1
611: where
612: ah.auction_header_id = to_number(p_id)
613: and atvl_1.TERM_ID(+) = ah.PAYMENT_TERMS_ID;

Line 620: from pon_auction_headers_all ah,

616:
617: select
618: PON_FORMS_UTIL_PVT.GET_FREIGHT(ah.carrier_code, fsp.inventory_organization_id)
619: into rt_large_value
620: from pon_auction_headers_all ah,
621: financials_system_params_all fsp
622: where ah.auction_header_id = to_number(p_id)
623: and fsp.org_id(+) = ah.org_id;
624:

Line 630: from pon_auction_headers_all ah

626:
627: select
628: decode( nvl(ah.INCLUDE_PDF_IN_EXTERNAL_PAGE, 'N'), 'Y', 'SHOW_PDF', 'HIDE_PDF') DISPLAY_PDF_FLAG
629: into rt_value
630: from pon_auction_headers_all ah
631: where ah.auction_header_id = to_number(p_id);
632:
633: elsif p_field_code = 'NEGOTIATION_TYPE' then
634:

Line 638: pon_auction_headers_all ah,

634:
635: select doc.internal_name
636: into rt_value
637: from
638: pon_auction_headers_all ah,
639: PON_AUC_DOCTYPES doc
640: where
641: ah.auction_header_id = to_number(p_id)
642: and ah.DOCTYPE_ID = doc.DOCTYPE_ID;

Line 648: from pon_auction_headers_all ah,

644: elsif p_field_code = 'NEGOTIATION_TYPE_NAME' then
645:
646: select doctl.NAME
647: into rt_value
648: from pon_auction_headers_all ah,
649: PON_AUC_DOCTYPES_TL doctl
650: where
651: ah.auction_header_id = to_number(p_id)
652: and ah.DOCTYPE_ID = doctl.DOCTYPE_ID

Line 661: from pon_auction_headers_all ah,

657: select
658: lookup_1.MEANING
659: into
660: rt_value
661: from pon_auction_headers_all ah,
662: FND_LOOKUP_VALUES lookup_1
663: where
664: ah.auction_header_id = to_number(p_id)
665: and lookup_1.LOOKUP_CODE(+) = ah.BID_VISIBILITY_CODE

Line 676: from pon_auction_headers_all ah,

672:
673: select
674: lookup_2.MEANING
675: into rt_value
676: from pon_auction_headers_all ah,
677: FND_LOOKUP_VALUES lookup_2
678: where ah.auction_header_id = to_number(p_id)
679: and lookup_2.lookup_code(+) = ah.fob_code
680: and lookup_2.LOOKUP_TYPE(+) = 'FOB'

Line 691: from pon_auction_headers_all ah,

687: select
688: lookup_3.MEANING
689: into
690: rt_value
691: from pon_auction_headers_all ah,
692: FND_LOOKUP_VALUES lookup_3
693: where ah.auction_header_id = to_number(p_id)
694: and lookup_3.LOOKUP_CODE(+) = ah.FREIGHT_TERMS_CODE
695: and lookup_3.lookup_type ='FREIGHT TERMS'

Line 706: from pon_auction_headers_all ah,

702: select
703: org.NAME
704: into
705: rt_value
706: from pon_auction_headers_all ah,
707: HR_ALL_ORGANIZATION_UNITS_TL org
708: where ah.auction_header_id = to_number(p_id)
709: and org.ORGANIZATION_ID = ah.ORG_ID
710: and org.LANGUAGE = userenv('LANG');

Line 738: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

734: elsif p_field_code = 'FED_OFFADD' then
735: rt_value := get_uda_fed_offadd(to_number(p_id));
736:
737: elsif p_field_code = 'FED_SOLNBR' then
738: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
739:
740: elsif p_field_code = 'FED_CLOSINGDATE' then
741:
742: select TO_CHAR(CLOSE_BIDDING_DATE, 'YYYYMMDD') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

Line 742: select TO_CHAR(CLOSE_BIDDING_DATE, 'YYYYMMDD') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

738: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
739:
740: elsif p_field_code = 'FED_CLOSINGDATE' then
741:
742: select TO_CHAR(CLOSE_BIDDING_DATE, 'YYYYMMDD') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
743:
744: elsif p_field_code = 'FED_ARCHDATE' then
745: select TO_CHAR(CLOSE_BIDDING_DATE + 15, 'YYYYMMDD') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
746:

Line 745: select TO_CHAR(CLOSE_BIDDING_DATE + 15, 'YYYYMMDD') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

741:
742: select TO_CHAR(CLOSE_BIDDING_DATE, 'YYYYMMDD') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
743:
744: elsif p_field_code = 'FED_ARCHDATE' then
745: select TO_CHAR(CLOSE_BIDDING_DATE + 15, 'YYYYMMDD') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
746:
747: elsif p_field_code = 'FED_UPLOADTYPE' then
748: select DECODE(amendment_flag,'Y','A','S') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
749:

Line 748: select DECODE(amendment_flag,'Y','A','S') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

744: elsif p_field_code = 'FED_ARCHDATE' then
745: select TO_CHAR(CLOSE_BIDDING_DATE + 15, 'YYYYMMDD') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
746:
747: elsif p_field_code = 'FED_UPLOADTYPE' then
748: select DECODE(amendment_flag,'Y','A','S') into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
749:
750: elsif p_field_code = 'FED_FILE_LINK' then
751: rt_value := get_fed_file_link(to_number(p_id));
752:

Line 3371: update pon_auction_headers_all

3367: print_debug_log(l_api_name, 'BEGIN- p_auction_header_id = '|| p_auction_header_id||'
3368: p_include_pdf_flag = '||p_include_pdf_flag ||'
3369: p_publish_action = '||p_publish_action);
3370:
3371: update pon_auction_headers_all
3372: set include_pdf_in_external_page = p_include_pdf_flag,
3373: last_update_date = sysdate
3374: where auction_header_id = p_auction_header_id;
3375:

Line 3382: -- pon_auction_headers_all.abstract_status OR

3378: if((nvl(p_publish_action, '@') = 'Y' ) OR (nvl(p_publish_action, '@') = 'N') ) then
3379:
3380: -- if the user hasn't pressed the publish abstract button
3381: -- we dont need to update the status in either
3382: -- pon_auction_headers_all.abstract_status OR
3383: -- pon_forms_instances.status
3384:
3385: -- as we do invoke this method when the user presses the apply button as well
3386:

Line 3387: update pon_auction_headers_all

3383: -- pon_forms_instances.status
3384:
3385: -- as we do invoke this method when the user presses the apply button as well
3386:
3387: update pon_auction_headers_all
3388: set abstract_status = decode(nvl(p_publish_action, 'X'), 'Y', 'PUBLISHED', 'NOT_PUBLISHED'),
3389: last_update_date = sysdate
3390: where auction_header_id = p_auction_header_id;
3391:

Line 3401: where entity_code = 'PON_AUCTION_HEADERS_ALL'

3397:
3398: update pon_forms_instances
3399: set status = decode(nvl(p_publish_action, 'X'), 'Y', 'PUBLISHED', 'NOT_PUBLISHED'),
3400: last_update_date = sysdate
3401: where entity_code = 'PON_AUCTION_HEADERS_ALL'
3402: and entity_pk1 = to_char(p_auction_header_id)
3403: and form_id = l_form_id;
3404:
3405: end if;

Line 3503: update pon_auction_headers_all

3499:
3500: if(NVL(p_include_pdf, 'x@Y#z') <> 'x@Y#z') then
3501:
3502: begin
3503: update pon_auction_headers_all
3504: set include_pdf_in_external_page = p_include_pdf,
3505: last_update_date = sysdate
3506: where auction_header_id = to_number(p_entity_pk1);
3507:

Line 3854: l_fed_desc pon_auction_headers_all.amendment_description%TYPE;

3850: * current document is amendment or not
3851: */
3852: FUNCTION get_fed_desc(p_auction_header_id IN NUMBER)
3853: RETURN VARCHAR2 IS
3854: l_fed_desc pon_auction_headers_all.amendment_description%TYPE;
3855:
3856: BEGIN
3857:
3858: SELECT Decode(Nvl(amendment_flag,'N'),'Y',amendment_description,abstract_details)

Line 3860: FROM pon_auction_headers_all

3856: BEGIN
3857:
3858: SELECT Decode(Nvl(amendment_flag,'N'),'Y',amendment_description,abstract_details)
3859: INTO l_fed_desc
3860: FROM pon_auction_headers_all
3861: WHERE auction_header_id = p_auction_header_id;
3862:
3863: RETURN l_fed_desc;
3864:

Line 3880: FROM pon_auction_headers_all

3876: BEGIN
3877:
3878: SELECT Decode(Nvl(amendment_number,0),0,'S','A')
3879: INTO l_uploadtype
3880: FROM pon_auction_headers_all
3881: WHERE auction_header_id = p_auction_header_id;
3882:
3883: RETURN l_uploadtype;
3884:

Line 4246: ,p_object_name => 'PON_AUCTION_HEADERS_ALL'

4242: ,p_attr_internal_name => p_attr_internal_name
4243: ,p_attr_group_int_name => p_attr_group_int_name
4244: ,p_attr_id => l_attr_id
4245: ,p_attr_group_type => p_attr_group_type
4246: ,p_object_name => 'PON_AUCTION_HEADERS_ALL'
4247: ,p_pk1_column_name => 'AUCTION_HEADER_ID'
4248: ,p_pk1_value => p_auction_header_id
4249: );
4250:

Line 4314: select DOCUMENT_NUMBER into l_solnbr from pon_auction_headers_all where auction_header_id = p_entity_pk1;

4310: into l_sequence
4311: from dual;
4312:
4313: --get solicitation number
4314: select DOCUMENT_NUMBER into l_solnbr from pon_auction_headers_all where auction_header_id = p_entity_pk1;
4315:
4316: l_curr_lang := fnd_global.current_language;
4317:
4318: --get form name