[Home] [Help]
1436: hz.person_first_name || ' ' || hz.person_last_name,
1437: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 7), 1, nvl(view_by_date, open_bidding_date)+3,
1438: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 1), 1, nvl(view_by_date, open_bidding_date) + 1,
1439: nvl(view_by_date, open_bidding_date) + 1/24)) reminder_time
1440: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt
1441: where hz.party_id = auh.trading_partner_contact_id
1442: and auh.doctype_id = dt.doctype_id
1443: and auction_header_id = p_auction_header_id;
1444: BEGIN
2100: nvl(substr(bhz.attribute2,0,3),''),
2101: bhz.person_first_name || ' ' || bhz.person_last_name,
2102: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2103: ah.view_by_date, ah.staggered_closing_interval
2104: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2105: where bhz.party_id = bih.trading_partner_contact_id
2106: and bih.bid_number = p_bid_id
2107: and ah.auction_header_id = bih.auction_header_id
2108: and ah.doctype_id = dt.doctype_id;
2670: ah.document_number, dt.doctype_group_name, dt.doctype_id,
2671: bhz.person_first_name || ' ' || bhz.person_last_name, ah.trading_partner_contact_name,
2672: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2673: view_by_date, nvl(ah.has_items_flag, 'Y'), ah.staggered_closing_interval,bih.award_status
2674: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2675: where bhz.party_id = bih.trading_partner_contact_id
2676: and bih.bid_number = p_bid_id
2677: and ah.auction_header_id = bih.auction_header_id
2678: and ah.doctype_id = dt.doctype_id;
6334: END;
6335:
6336: FUNCTION GET_MESSAGE_SUFFIX (x_doctype_group_name VARCHAR2) RETURN VARCHAR2 AS
6337:
6338: x_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE := '';
6339:
6340: BEGIN
6341: BEGIN
6342: SELECT message_suffix
6340: BEGIN
6341: BEGIN
6342: SELECT message_suffix
6343: INTO x_msg_suffix
6344: FROM pon_auc_doctypes
6345: WHERE doctype_group_name = x_doctype_group_name;
6346: EXCEPTION WHEN NO_DATA_FOUND THEN
6347: x_msg_suffix := '';
6348: END;
6352: RETURN ('_'||x_msg_suffix);
6353: END IF;
6354: END;
6355:
6356: FUNCTION GET_TRANSACTION_TYPE (p_doctype_group_name PON_AUC_DOCTYPES.INTERNAL_NAME%TYPE)
6357: RETURN PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE AS
6358:
6359: x_trans_type PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE;
6360:
6353: END IF;
6354: END;
6355:
6356: FUNCTION GET_TRANSACTION_TYPE (p_doctype_group_name PON_AUC_DOCTYPES.INTERNAL_NAME%TYPE)
6357: RETURN PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE AS
6358:
6359: x_trans_type PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE;
6360:
6361: BEGIN
6355:
6356: FUNCTION GET_TRANSACTION_TYPE (p_doctype_group_name PON_AUC_DOCTYPES.INTERNAL_NAME%TYPE)
6357: RETURN PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE AS
6358:
6359: x_trans_type PON_AUC_DOCTYPES.TRANSACTION_TYPE%TYPE;
6360:
6361: BEGIN
6362: BEGIN
6363: SELECT transaction_type
6361: BEGIN
6362: BEGIN
6363: SELECT transaction_type
6364: INTO x_trans_type
6365: FROM pon_auc_doctypes
6366: WHERE doctype_group_name = p_doctype_group_name;
6367: EXCEPTION WHEN NO_DATA_FOUND THEN
6368: x_trans_type := '';
6369: END;
6967: EXCEPTION
6968: WHEN OTHERS THEN
6969: select dt.doctype_group_name
6970: into x_doctype_group_name
6971: from pon_auction_headers_all auh, pon_auc_doctypes dt
6972: where auh.auction_header_id = x_auction_header_id
6973: and auh.doctype_id = dt.doctype_id;
6974: END;
6975:
10651: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
10652: l_auction_start_date DATE;
10653: l_auction_end_date DATE;
10654: l_preview_date DATE;
10655: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10656: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10657: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10658: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10659: l_task_target_date DATE;
10730: from pon_auction_headers_all auh,
10731: hz_parties hz,
10732: pon_neg_team_members pntm,
10733: fnd_user fu,
10734: pon_auc_doctypes pad
10735: where auh.auction_header_id = p_auction_header_id
10736: AND hz.party_id = auh.trading_partner_id
10737: AND pntm.auction_header_id = auh.auction_header_id
10738: AND pntm.user_id = p_user_id
10982: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
10983: l_auction_start_date DATE;
10984: l_auction_end_date DATE;
10985: l_preview_date DATE;
10986: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10987: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10988: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10989: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10990: l_task_target_date DATE;
11044: l_tp_contact_usr_id,
11045: l_open_auction_now_flag,
11046: l_publish_auction_now_flag
11047: from pon_auction_headers_all auh,
11048: pon_auc_doctypes pad,
11049: fnd_user fu
11050: where auh.auction_header_id = p_auction_header_id
11051: AND pad.doctype_id = auh.doctype_id
11052: AND fu.person_party_id = auh.TRADING_PARTNER_CONTACT_ID
11086: l_tp_contact_usr_id,
11087: l_open_auction_now_flag,
11088: l_publish_auction_now_flag
11089: from pon_auction_headers_all auh,
11090: pon_auc_doctypes pad,
11091: fnd_user fu
11092: where auh.auction_header_id = p_auction_header_id
11093: AND pad.doctype_id = auh.doctype_id
11094: AND fu.person_party_id = auh.TRADING_PARTNER_CONTACT_ID
11360: PROCEDURE SEND_RESP_NOTIF ( p_bid_number IN NUMBER,
11361: x_return_status OUT NOCOPY VARCHAR2)
11362: IS
11363: l_module_name constant VARCHAR2(40) := 'SEND_RESP_NOTIF';
11364: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
11365: l_progress VARCHAR2(3);
11366: l_lang_code VARCHAR2(4);
11367: l_itemtype VARCHAR2(7);
11368: l_language_code VARCHAR2(20);
11441: l_bid_publish_date,
11442: l_bidder_tpc_id,
11443: l_auction_header_id
11444: from pon_auction_headers_all auh,
11445: pon_auc_doctypes pad,
11446: pon_bid_headers pbh,
11447: fnd_user fu
11448: where pbh.bid_number = p_bid_number
11449: AND pad.doctype_id = auh.doctype_id
11492: l_bid_publish_date,
11493: l_bidder_tpc_id,
11494: l_auction_header_id
11495: from pon_auction_headers_all auh,
11496: pon_auc_doctypes pad,
11497: pon_bid_headers pbh,
11498: fnd_user fu
11499: where pbh.bid_number = p_bid_number
11500: AND pad.doctype_id = auh.doctype_id
11828: l_auction_end_date DATE;
11829: l_preview_date DATE;
11830: l_msg_sent_date DATE;
11831: l_null_date DATE;
11832: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
11833: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11834: l_subject PON_THREADS.SUBJECT%TYPE;
11835: l_sender_name VARCHAR2(350);
11836: l_recipient_name VARCHAR2(350);
12059: l_discussion_id,
12060: l_open_auction_now_flag ,
12061: l_publish_auction_now_flag
12062: FROM pon_auction_headers_all auh,
12063: pon_auc_doctypes pad,
12064: pon_thread_entries pte,
12065: pon_threads pt,
12066: pon_discussions pd
12067: WHERE pte.entry_id = p_entryid
14790: p_qty_price_tiers_enabled || ', p_doctype_id = ' || p_doctype_id);
14791: END IF; --}
14792:
14793: --
14794: -- To check if given doctype_id corresponds to a RFI we need to select doctype id for RFI from PON_AUC_DOCTYPES
14795: --
14796:
14797: SELECT doctype_id
14798: INTO l_rfi_doctype_id
14795: --
14796:
14797: SELECT doctype_id
14798: INTO l_rfi_doctype_id
14799: FROM PON_AUC_DOCTYPES
14800: WHERE doctype_group_name = 'REQUEST_FOR_INFORMATION';
14801:
14802: --
14803: -- Default price tiers value is Null if neg is