DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 734: sol_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;

730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;
731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;
732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;
733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;
734: sol_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
735: req_line_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
736: sol_ip_category_id PON_AUCTION_ITEM_PRICES_ALL.ip_category_id%TYPE;
737: sol_uom_code VARCHAR2(10);
738: req_line_uom VARCHAR2(10);

Line 764: FROM pon_auction_headers_all paha, pon_auc_doctypes doc

760:
761: BEGIN
762: SELECT paha.contract_type,pon_auction_pkg.get_message_suffix(doc.internal_name)
763: INTO sol_contract_type,message_suffix
764: FROM pon_auction_headers_all paha, pon_auc_doctypes doc
765: WHERE paha.auction_header_id =p_draft_id
766: and paha.doctype_id = doc.doctype_id;
767:
768: EXCEPTION