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.

[Home] [Help]

APPS.PON_FORMS_UTIL_PVT dependencies on PON_AUCTION_HEADERS_ALL

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

432:
433:
434: if p_field_code = 'AWARD_DATE' then
435:
436: select AWARD_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
437:
438: elsif p_field_code = 'CLOSE_DATE' then
439:
440: select CLOSE_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

436: select AWARD_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
437:
438: elsif p_field_code = 'CLOSE_DATE' then
439:
440: select CLOSE_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
441:
442: elsif p_field_code = 'OPEN_DATE' then
443:
444: select OPEN_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

440: select CLOSE_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
441:
442: elsif p_field_code = 'OPEN_DATE' then
443:
444: select OPEN_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
445:
446: elsif p_field_code = 'PREVIEW_DATE' then
447:
448: select VIEW_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

444: select OPEN_BIDDING_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
445:
446: elsif p_field_code = 'PREVIEW_DATE' then
447:
448: select VIEW_BY_DATE into rt_date from pon_auction_headers_all where auction_header_id = to_number(p_id);
449:
450: end if;
451:
452: print_debug_log(l_api_name, 'END rt_date = '||rt_date);

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

492: print_debug_log(l_api_name, 'l_stmt = '||l_stmt);
493:
494: if p_field_code = 'PAYMENT_TERMS' then
495:
496: select PAYMENT_TERMS_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
497:
498: elsif p_field_code = 'ORGANIZATION' then
499:
500: select ORG_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

496: select PAYMENT_TERMS_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
497:
498: elsif p_field_code = 'ORGANIZATION' then
499:
500: select ORG_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
501:
502: elsif p_field_code = 'AUCTION_HEADER_ID' then
503:
504: select AUCTION_HEADER_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

500: select ORG_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
501:
502: elsif p_field_code = 'AUCTION_HEADER_ID' then
503:
504: select AUCTION_HEADER_ID into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
505:
506: end if;
507:
508: print_debug_log(l_api_name, 'END rt_value = '||rt_value);

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

551: print_debug_log(l_api_name, 'l_stmt = '||l_stmt);
552:
553: if p_field_code = 'ABSTRACT_STATUS' then
554:
555: select ABSTRACT_STATUS into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
556:
557: elsif p_field_code = 'AMENDMENT_DESCRIPTION' then
558:
559: select AMENDMENT_DESCRIPTION into rt_large_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

555: select ABSTRACT_STATUS into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
556:
557: elsif p_field_code = 'AMENDMENT_DESCRIPTION' then
558:
559: select AMENDMENT_DESCRIPTION into rt_large_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
560:
561: elsif p_field_code = 'TITLE' then
562:
563: select AUCTION_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

559: select AMENDMENT_DESCRIPTION into rt_large_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
560:
561: elsif p_field_code = 'TITLE' then
562:
563: select AUCTION_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
564:
565: elsif p_field_code = 'STYLE' then
566:
567: select BID_VISIBILITY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

563: select AUCTION_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
564:
565: elsif p_field_code = 'STYLE' then
566:
567: select BID_VISIBILITY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
568:
569: elsif p_field_code = 'CARRIER' then
570:
571: select CARRIER_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

567: select BID_VISIBILITY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
568:
569: elsif p_field_code = 'CARRIER' then
570:
571: select CARRIER_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
572:
573: elsif p_field_code = 'NEGOTIATION_CURR' then
574:
575: select CURRENCY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

571: select CARRIER_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
572:
573: elsif p_field_code = 'NEGOTIATION_CURR' then
574:
575: select CURRENCY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
576:
577: elsif p_field_code = 'NEGOTIATION_NUM' then
578:
579: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

575: select CURRENCY_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
576:
577: elsif p_field_code = 'NEGOTIATION_NUM' then
578:
579: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
580:
581: elsif p_field_code = 'EVENT' then
582:
583: select EVENT_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

579: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
580:
581: elsif p_field_code = 'EVENT' then
582:
583: select EVENT_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
584:
585: elsif p_field_code = 'FOB' then
586:
587: select FOB_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

583: select EVENT_TITLE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
584:
585: elsif p_field_code = 'FOB' then
586:
587: select FOB_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
588:
589: elsif p_field_code = 'FREIGHT_TERMS' then
590:
591: select FREIGHT_TERMS_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

587: select FOB_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
588:
589: elsif p_field_code = 'FREIGHT_TERMS' then
590:
591: select FREIGHT_TERMS_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
592:
593: elsif p_field_code = 'BUYER' then
594:
595: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);

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

591: select FREIGHT_TERMS_CODE into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
592:
593: elsif p_field_code = 'BUYER' then
594:
595: select DOCUMENT_NUMBER into rt_value from pon_auction_headers_all where auction_header_id = to_number(p_id);
596:
597: elsif p_field_code = 'PAYMENT_TERMS_NAME' then
598:
599: select atvl_1.NAME

Line 602: PON_AUCTION_HEADERS_ALL ah,

598:
599: select atvl_1.NAME
600: into rt_value
601: from
602: PON_AUCTION_HEADERS_ALL ah,
603: AP_TERMS_VL atvl_1
604: where
605: ah.auction_header_id = to_number(p_id)
606: and atvl_1.TERM_ID(+) = ah.PAYMENT_TERMS_ID;

Line 613: from pon_auction_headers_all ah,

609:
610: select
611: PON_FORMS_UTIL_PVT.GET_FREIGHT(ah.carrier_code, fsp.inventory_organization_id)
612: into rt_large_value
613: from pon_auction_headers_all ah,
614: financials_system_params_all fsp
615: where ah.auction_header_id = to_number(p_id)
616: and fsp.org_id(+) = ah.org_id;
617:

Line 623: from pon_auction_headers_all ah

619:
620: select
621: decode( nvl(ah.INCLUDE_PDF_IN_EXTERNAL_PAGE, 'N'), 'Y', 'SHOW_PDF', 'HIDE_PDF') DISPLAY_PDF_FLAG
622: into rt_value
623: from pon_auction_headers_all ah
624: where ah.auction_header_id = to_number(p_id);
625:
626: elsif p_field_code = 'NEGOTIATION_TYPE' then
627:

Line 631: pon_auction_headers_all ah,

627:
628: select doc.internal_name
629: into rt_value
630: from
631: pon_auction_headers_all ah,
632: PON_AUC_DOCTYPES doc
633: where
634: ah.auction_header_id = to_number(p_id)
635: and ah.DOCTYPE_ID = doc.DOCTYPE_ID;

Line 641: from pon_auction_headers_all ah,

637: elsif p_field_code = 'NEGOTIATION_TYPE_NAME' then
638:
639: select doctl.NAME
640: into rt_value
641: from pon_auction_headers_all ah,
642: PON_AUC_DOCTYPES_TL doctl
643: where
644: ah.auction_header_id = to_number(p_id)
645: and ah.DOCTYPE_ID = doctl.DOCTYPE_ID

Line 654: from pon_auction_headers_all ah,

650: select
651: lookup_1.MEANING
652: into
653: rt_value
654: from pon_auction_headers_all ah,
655: FND_LOOKUP_VALUES lookup_1
656: where
657: ah.auction_header_id = to_number(p_id)
658: and lookup_1.LOOKUP_CODE(+) = ah.BID_VISIBILITY_CODE

Line 669: from pon_auction_headers_all ah,

665:
666: select
667: lookup_2.MEANING
668: into rt_value
669: from pon_auction_headers_all ah,
670: FND_LOOKUP_VALUES lookup_2
671: where ah.auction_header_id = to_number(p_id)
672: and lookup_2.lookup_code(+) = ah.fob_code
673: and lookup_2.LOOKUP_TYPE(+) = 'FOB'

Line 684: from pon_auction_headers_all ah,

680: select
681: lookup_3.MEANING
682: into
683: rt_value
684: from pon_auction_headers_all ah,
685: FND_LOOKUP_VALUES lookup_3
686: where ah.auction_header_id = to_number(p_id)
687: and lookup_3.LOOKUP_CODE(+) = ah.FREIGHT_TERMS_CODE
688: and lookup_3.lookup_type ='FREIGHT TERMS'

Line 699: from pon_auction_headers_all ah,

695: select
696: org.NAME
697: into
698: rt_value
699: from pon_auction_headers_all ah,
700: HR_ALL_ORGANIZATION_UNITS_TL org
701: where ah.auction_header_id = to_number(p_id)
702: and org.ORGANIZATION_ID = ah.ORG_ID
703: and org.LANGUAGE = userenv('LANG');

Line 3295: update pon_auction_headers_all

3291: print_debug_log(l_api_name, 'BEGIN- p_auction_header_id = '|| p_auction_header_id||'
3292: p_include_pdf_flag = '||p_include_pdf_flag ||'
3293: p_publish_action = '||p_publish_action);
3294:
3295: update pon_auction_headers_all
3296: set include_pdf_in_external_page = p_include_pdf_flag,
3297: last_update_date = sysdate
3298: where auction_header_id = p_auction_header_id;
3299:

Line 3306: -- pon_auction_headers_all.abstract_status OR

3302: if((nvl(p_publish_action, '@') = 'Y' ) OR (nvl(p_publish_action, '@') = 'N') ) then
3303:
3304: -- if the user hasn't pressed the publish abstract button
3305: -- we dont need to update the status in either
3306: -- pon_auction_headers_all.abstract_status OR
3307: -- pon_forms_instances.status
3308:
3309: -- as we do invoke this method when the user presses the apply button as well
3310:

Line 3311: update pon_auction_headers_all

3307: -- pon_forms_instances.status
3308:
3309: -- as we do invoke this method when the user presses the apply button as well
3310:
3311: update pon_auction_headers_all
3312: set abstract_status = decode(nvl(p_publish_action, 'X'), 'Y', 'PUBLISHED', 'NOT_PUBLISHED'),
3313: last_update_date = sysdate
3314: where auction_header_id = p_auction_header_id;
3315:

Line 3325: where entity_code = 'PON_AUCTION_HEADERS_ALL'

3321:
3322: update pon_forms_instances
3323: set status = decode(nvl(p_publish_action, 'X'), 'Y', 'PUBLISHED', 'NOT_PUBLISHED'),
3324: last_update_date = sysdate
3325: where entity_code = 'PON_AUCTION_HEADERS_ALL'
3326: and entity_pk1 = to_char(p_auction_header_id)
3327: and form_id = l_form_id;
3328:
3329: end if;

Line 3415: update pon_auction_headers_all

3411:
3412: if(NVL(p_include_pdf, 'x@Y#z') <> 'x@Y#z') then
3413:
3414: begin
3415: update pon_auction_headers_all
3416: set include_pdf_in_external_page = p_include_pdf,
3417: last_update_date = sysdate
3418: where auction_header_id = to_number(p_entity_pk1);
3419: