[Home] [Help]
1301:
1302: -- Auction Header Information
1303: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1304: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1305: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1360: l_progress_payment_type,
1361: l_price_tiers_indicator
1362: FROM
1363: pon_auction_headers_all paha,
1364: pon_auc_doctypes pad
1365: WHERE
1366: paha.auction_header_id = p_auction_header_id AND
1367: paha.doctype_id = pad.doctype_id;
1368:
1770:
1771: -- Auction Header Information
1772: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1773: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1774: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1775: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1776: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1777: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1778: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1885: l_progress_payment_type,
1886: l_price_tiers_indicator
1887: FROM
1888: pon_auction_headers_all paha,
1889: pon_auc_doctypes pad
1890: WHERE
1891: paha.auction_header_id = p_auction_header_id AND
1892: paha.doctype_id = pad.doctype_id;
1893:
4163: *======================================================================*/
4164:
4165: FUNCTION GET_ABBR_DOC_TYPE_GRP_NAME (p_doctype_id IN NUMBER) RETURN VARCHAR2
4166: IS
4167: v_doctype_name pon_auc_doctypes_tl.name%TYPE;
4168:
4169: BEGIN
4170:
4171: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
4177: SELECT name
4178: INTO
4179: v_doctype_name
4180: FROM
4181: pon_auc_doctypes_tl
4182: WHERE
4183: doctype_id = p_doctype_id and
4184: language = 'US';
4185: