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_AUCTION_PKG dependencies on PON_AUC_DOCTYPES

Line 995: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt

991: hz.person_first_name || ' ' || hz.person_last_name,
992: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 7), 1, nvl(view_by_date, open_bidding_date)+3,
993: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 1), 1, nvl(view_by_date, open_bidding_date) + 1,
994: nvl(view_by_date, open_bidding_date) + 1/24)) reminder_time
995: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt
996: where hz.party_id = auh.trading_partner_contact_id
997: and auh.doctype_id = dt.doctype_id
998: and auction_header_id = p_auction_header_id;
999: BEGIN

Line 1642: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt

1638: nvl(substr(bhz.attribute2,0,3),''),
1639: bhz.person_first_name || ' ' || bhz.person_last_name,
1640: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
1641: ah.view_by_date, ah.staggered_closing_interval
1642: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
1643: where bhz.party_id = bih.trading_partner_contact_id
1644: and bih.bid_number = p_bid_id
1645: and ah.auction_header_id = bih.auction_header_id
1646: and ah.doctype_id = dt.doctype_id;

Line 2202: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt

2198: ah.document_number, dt.doctype_group_name, dt.doctype_id,
2199: bhz.person_first_name || ' ' || bhz.person_last_name, ah.trading_partner_contact_name,
2200: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2201: view_by_date, nvl(ah.has_items_flag, 'Y'), ah.staggered_closing_interval,bih.award_status
2202: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2203: where bhz.party_id = bih.trading_partner_contact_id
2204: and bih.bid_number = p_bid_id
2205: and ah.auction_header_id = bih.auction_header_id
2206: and ah.doctype_id = dt.doctype_id;

Line 5742: x_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE := '';

5738: END;
5739:
5740: FUNCTION GET_MESSAGE_SUFFIX (x_doctype_group_name VARCHAR2) RETURN VARCHAR2 AS
5741:
5742: x_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE := '';
5743:
5744: BEGIN
5745: BEGIN
5746: SELECT message_suffix

Line 5748: FROM pon_auc_doctypes

5744: BEGIN
5745: BEGIN
5746: SELECT message_suffix
5747: INTO x_msg_suffix
5748: FROM pon_auc_doctypes
5749: WHERE doctype_group_name = x_doctype_group_name;
5750: EXCEPTION WHEN NO_DATA_FOUND THEN
5751: x_msg_suffix := '';
5752: END;

Line 5760: FUNCTION GET_TRANSACTION_TYPE (p_doctype_group_name PON_AUC_DOCTYPES.INTERNAL_NAME%TYPE)

5756: RETURN ('_'||x_msg_suffix);
5757: END IF;
5758: END;
5759:
5760: FUNCTION GET_TRANSACTION_TYPE (p_doctype_group_name PON_AUC_DOCTYPES.INTERNAL_NAME%TYPE)
5761: RETURN PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE AS
5762:
5763: x_trans_type PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE;
5764:

Line 5761: RETURN PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE AS

5757: END IF;
5758: END;
5759:
5760: FUNCTION GET_TRANSACTION_TYPE (p_doctype_group_name PON_AUC_DOCTYPES.INTERNAL_NAME%TYPE)
5761: RETURN PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE AS
5762:
5763: x_trans_type PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE;
5764:
5765: BEGIN

Line 5763: x_trans_type PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE;

5759:
5760: FUNCTION GET_TRANSACTION_TYPE (p_doctype_group_name PON_AUC_DOCTYPES.INTERNAL_NAME%TYPE)
5761: RETURN PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE AS
5762:
5763: x_trans_type PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE;
5764:
5765: BEGIN
5766: BEGIN
5767: SELECT transaction_type

Line 5769: FROM pon_auc_doctypes

5765: BEGIN
5766: BEGIN
5767: SELECT transaction_type
5768: INTO x_trans_type
5769: FROM pon_auc_doctypes
5770: WHERE doctype_group_name = p_doctype_group_name;
5771: EXCEPTION WHEN NO_DATA_FOUND THEN
5772: x_trans_type := '';
5773: END;

Line 6369: from pon_auction_headers_all auh, pon_auc_doctypes dt

6365: EXCEPTION
6366: WHEN OTHERS THEN
6367: select dt.doctype_group_name
6368: into x_doctype_group_name
6369: from pon_auction_headers_all auh, pon_auc_doctypes dt
6370: where auh.auction_header_id = x_auction_header_id
6371: and auh.doctype_id = dt.doctype_id;
6372: END;
6373:

Line 9819: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;

9815: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
9816: l_auction_start_date DATE;
9817: l_auction_end_date DATE;
9818: l_preview_date DATE;
9819: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
9820: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9821: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
9822: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
9823: l_task_target_date DATE;

Line 9898: pon_auc_doctypes pad

9894: from pon_auction_headers_all auh,
9895: hz_parties hz,
9896: pon_neg_team_members pntm,
9897: fnd_user fu,
9898: pon_auc_doctypes pad
9899: where auh.auction_header_id = p_auction_header_id
9900: AND hz.party_id = auh.trading_partner_id
9901: AND pntm.auction_header_id = auh.auction_header_id
9902: AND pntm.user_id = p_user_id

Line 10150: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;

10146: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
10147: l_auction_start_date DATE;
10148: l_auction_end_date DATE;
10149: l_preview_date DATE;
10150: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10151: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10152: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10153: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10154: l_task_target_date DATE;

Line 10212: pon_auc_doctypes pad,

10208: l_tp_contact_usr_id,
10209: l_open_auction_now_flag,
10210: l_publish_auction_now_flag
10211: from pon_auction_headers_all auh,
10212: pon_auc_doctypes pad,
10213: fnd_user fu
10214: where auh.auction_header_id = p_auction_header_id
10215: AND pad.doctype_id = auh.doctype_id
10216: AND fu.person_party_id = auh.TRADING_PARTNER_CONTACT_ID

Line 10254: pon_auc_doctypes pad,

10250: l_tp_contact_usr_id,
10251: l_open_auction_now_flag,
10252: l_publish_auction_now_flag
10253: from pon_auction_headers_all auh,
10254: pon_auc_doctypes pad,
10255: fnd_user fu
10256: where auh.auction_header_id = p_auction_header_id
10257: AND pad.doctype_id = auh.doctype_id
10258: AND fu.person_party_id = auh.TRADING_PARTNER_CONTACT_ID

Line 10528: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;

10524: PROCEDURE SEND_RESP_NOTIF ( p_bid_number IN NUMBER,
10525: x_return_status OUT NOCOPY VARCHAR2)
10526: IS
10527: l_module_name constant VARCHAR2(40) := 'SEND_RESP_NOTIF';
10528: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10529: l_progress VARCHAR2(3);
10530: l_lang_code VARCHAR2(4);
10531: l_itemtype VARCHAR2(7);
10532: l_language_code VARCHAR2(20);

Line 10609: pon_auc_doctypes pad,

10605: l_bid_publish_date,
10606: l_bidder_tpc_id,
10607: l_auction_header_id
10608: from pon_auction_headers_all auh,
10609: pon_auc_doctypes pad,
10610: pon_bid_headers pbh,
10611: fnd_user fu
10612: where pbh.bid_number = p_bid_number
10613: AND pad.doctype_id = auh.doctype_id

Line 10660: pon_auc_doctypes pad,

10656: l_bid_publish_date,
10657: l_bidder_tpc_id,
10658: l_auction_header_id
10659: from pon_auction_headers_all auh,
10660: pon_auc_doctypes pad,
10661: pon_bid_headers pbh,
10662: fnd_user fu
10663: where pbh.bid_number = p_bid_number
10664: AND pad.doctype_id = auh.doctype_id

Line 10996: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;

10992: l_auction_end_date DATE;
10993: l_preview_date DATE;
10994: l_msg_sent_date DATE;
10995: l_null_date DATE;
10996: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10997: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10998: l_subject PON_THREADS.SUBJECT%TYPE;
10999: l_sender_name VARCHAR2(350);
11000: l_recipient_name VARCHAR2(350);

Line 11227: pon_auc_doctypes pad,

11223: l_discussion_id,
11224: l_open_auction_now_flag ,
11225: l_publish_auction_now_flag
11226: FROM pon_auction_headers_all auh,
11227: pon_auc_doctypes pad,
11228: pon_thread_entries pte,
11229: pon_threads pt,
11230: pon_discussions pd
11231: WHERE pte.entry_id = p_entryid

Line 13935: -- To check if given doctype_id corresponds to a RFI we need to select doctype id for RFI from PON_AUC_DOCTYPES

13931: p_qty_price_tiers_enabled || ', p_doctype_id = ' || p_doctype_id);
13932: END IF; --}
13933:
13934: --
13935: -- To check if given doctype_id corresponds to a RFI we need to select doctype id for RFI from PON_AUC_DOCTYPES
13936: --
13937:
13938: SELECT doctype_id
13939: INTO l_rfi_doctype_id

Line 13940: FROM PON_AUC_DOCTYPES

13936: --
13937:
13938: SELECT doctype_id
13939: INTO l_rfi_doctype_id
13940: FROM PON_AUC_DOCTYPES
13941: WHERE doctype_group_name = 'REQUEST_FOR_INFORMATION';
13942:
13943: --
13944: -- Default price tiers value is Null if neg is