APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_AUC_DOCTYPES

Line 1305: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;

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;

Line 1369: pon_auc_doctypes pad

1365: l_price_tiers_indicator,
1366: l_doctype_id
1367: FROM
1368: pon_auction_headers_all paha,
1369: pon_auc_doctypes pad
1370: WHERE
1371: paha.auction_header_id = p_auction_header_id AND
1372: paha.doctype_id = pad.doctype_id;
1373:

Line 1835: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;

1831:
1832: -- Auction Header Information
1833: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1834: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1835: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;

Line 1956: pon_auc_doctypes pad

1952: l_price_tiers_indicator,
1953: l_doctype_id
1954: FROM
1955: pon_auction_headers_all paha,
1956: pon_auc_doctypes pad
1957: WHERE
1958: paha.auction_header_id = p_auction_header_id AND
1959: paha.doctype_id = pad.doctype_id;
1960:

Line 4311: v_doctype_name pon_auc_doctypes_tl.name%TYPE;

4307: *======================================================================*/
4308:
4309: FUNCTION GET_ABBR_DOC_TYPE_GRP_NAME (p_doctype_id IN NUMBER) RETURN VARCHAR2
4310: IS
4311: v_doctype_name pon_auc_doctypes_tl.name%TYPE;
4312:
4313: BEGIN
4314:
4315: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN

Line 4325: pon_auc_doctypes_tl

4321: SELECT name
4322: INTO
4323: v_doctype_name
4324: FROM
4325: pon_auc_doctypes_tl
4326: WHERE
4327: doctype_id = p_doctype_id and
4328: language = 'US';
4329: