APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_AUC_DOCTYPES

Line 191: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;

187: v_error_code VARCHAR2(100);
188: v_error_message VARCHAR2(400);
189: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
190: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
191: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
192: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
193: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
194: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
195: v_trading_partner_id pon_bidding_parties.trading_partner_id%TYPE;

Line 192: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;

188: v_error_message VARCHAR2(400);
189: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
190: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
191: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
192: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
193: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
194: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
195: v_trading_partner_id pon_bidding_parties.trading_partner_id%TYPE;
196: v_trading_partner_name pon_bidding_parties.trading_partner_name%TYPE;

Line 391: FROM pon_auc_doctypes

387: -- Get doctypeID
388: v_debug_status := 'DOCTYPE_ID';
389: SELECT doctype_id, transaction_type
390: INTO v_doctype_id, v_transaction_type
391: FROM pon_auc_doctypes
392: WHERE internal_name = g_header_rec.neg_type;
393:
394: -- price break header setting
395: PON_AUCTION_PKG.get_default_hdr_pb_settings (