[Home] [Help]
82: x_application_id number := null;
83:
84: x_language_code VARCHAR2(3);
85: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
86: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
87: x_origination_code pon_auction_headers_all.auction_origination_code%TYPE;
88: x_return_code VARCHAR2(10);
89:
90: l_api_name VARCHAR2(30) := ' AUTO_ALLOC_AND_SPLIT_REQ';
404: p_requisition_number OUT NOCOPY VARCHAR2,
405: p_job_name OUT NOCOPY VARCHAR2,
406: p_document_disp_line_number OUT NOCOPY VARCHAR2) IS
407:
408: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
409: x_result VARCHAR2(10);
410: x_error_message VARCHAR2(1000);
411:
412: -- unallocatedItems are items that have awarded bids that have yet to be
554: l_split_error_code VARCHAR2(10);
555: l_orig_req_line NUMBER;
556: l_req_qty NUMBER;
557: l_num_messages NUMBER;
558: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
559: l_req_line_id_col dbms_sql.number_table;
560: lock_not_acquired EXCEPTION;
561: l_user_id NUMBER;
562:
958: --l_split_req_line_id_insertcol dbms_sql.number_table;
959: l_clm_info_flag dbms_sql.number_table;
960:
961: l_empty_table dbms_sql.number_table;
962: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
963: l_user_id NUMBER;
964: l_login_id NUMBER;
965: l_bid_price_col dbms_sql.number_table;
966: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
1742: x_line_number NUMBER;
1743: x_award_quantity NUMBER;
1744: x_allocation_quantity NUMBER;
1745: x_requisition_line_id NUMBER;
1746: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1747: x_interface_header_id NUMBER;
1748: x_interface_line_id NUMBER;
1749: x_price NUMBER;
1750: x_quantity NUMBER;
4349: x_language_code VARCHAR2(4);
4350: x_round_number NUMBER;
4351: x_line_number NUMBER;
4352: x_bid_number NUMBER;
4353: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4354: x_po_header_id NUMBER;
4355: x_order_number pon_bid_headers.order_number%TYPE;
4356: x_interface_header_id NUMBER;
4357: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
4852: x_seq_for_item_key varchar2(6) := null;
4853: x_doc_type_to_create varchar2(25);
4854: v_old_policy varchar2(1);
4855: v_old_org_id number;
4856: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4857: x_supplier_notif_method po_vendor_sites_all.supplier_notif_method%TYPE := null;
4858: x_print_flag varchar2(1) := 'N';
4859: x_fax_flag varchar2(1) := 'N';
4860: x_email_flag varchar2(1) := 'N';
5041:
5042:
5043: x_number_of_failed_pos NUMBER;
5044: x_auction_header_id NUMBER;
5045: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5046:
5047: BEGIN
5048: IF (UNCMODE = 'CANCEL') THEN
5049: return;
5129: newline varchar2(256);
5130: beginBold VARCHAR2(10);
5131: endBold VARCHAR2(10);
5132: x_count NUMBER;
5133: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5134: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
5135: x_purchase_orders VARCHAR2(30);
5136: x_contract_type pon_auction_headers_all.contract_type%TYPE;
5137:
5299: newline varchar2(256);
5300: beginBold VARCHAR2(10);
5301: endBold VARCHAR2(10);
5302: x_count NUMBER;
5303: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5304: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
5305: x_purchase_orders VARCHAR2(30);
5306: x_contract_type pon_auction_headers_all.contract_type%TYPE;
5307: x_error_msg pon_bid_headers.po_error_msg%type;
5516: l_debug_enabled VARCHAR2(1) := 'N';
5517: l_exception_enabled VARCHAR2(1) := 'N';
5518: l_progress NUMBER := 0;
5519:
5520: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5521:
5522: -- Business Events Project
5523: x_return_status VARCHAR2(20);
5524: x_msg_count NUMBER;
6019: l_api_name VARCHAR2(150) := 'create_pon_back_req_alloc';
6020: l_debug_enabled VARCHAR2(1);
6021: l_exception_enabled VARCHAR2(1);
6022:
6023: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
6024: x_result VARCHAR2(10);
6025: x_error_message VARCHAR2(1000);
6026: l_count NUMBER;
6027: