APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_AUC_DOCTYPES

Line 209: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;

205: v_error_code VARCHAR2(100);
206: v_error_message VARCHAR2(400);
207: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
208: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
209: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
210: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
211: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
212: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
213: v_trading_partner_id pon_bidding_parties.trading_partner_id%TYPE;

Line 210: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;

206: v_error_message VARCHAR2(400);
207: v_functional_currency_code pon_auction_headers_all.currency_code%TYPE;
208: v_currency_precision pon_auction_headers_all.number_price_decimals%TYPE;
209: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
210: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
211: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
212: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
213: v_trading_partner_id pon_bidding_parties.trading_partner_id%TYPE;
214: v_trading_partner_name pon_bidding_parties.trading_partner_name%TYPE;

Line 430: FROM pon_auc_doctypes

426: -- Get doctypeID
427: v_debug_status := 'DOCTYPE_ID';
428: SELECT doctype_id, transaction_type
429: INTO v_doctype_id, v_transaction_type
430: FROM pon_auc_doctypes
431: WHERE internal_name = g_header_rec.neg_type;
432:
433: -- price break header setting
434: PON_AUCTION_PKG.get_default_hdr_pb_settings (