[Home] [Help]
80: x_application_id number := null;
81:
82: x_language_code VARCHAR2(3);
83: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
84: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
85: x_origination_code pon_auction_headers_all.auction_origination_code%TYPE;
86: x_return_code VARCHAR2(10);
87:
88: l_api_name VARCHAR2(30) := ' AUTO_ALLOC_AND_SPLIT_REQ';
378: p_requisition_number OUT NOCOPY VARCHAR2,
379: p_job_name OUT NOCOPY VARCHAR2,
380: p_document_disp_line_number OUT NOCOPY VARCHAR2) IS
381:
382: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
383: x_result VARCHAR2(10);
384: x_error_message VARCHAR2(1000);
385:
386: -- unallocatedItems are items that have awarded bids that have yet to be
528: l_split_error_code VARCHAR2(10);
529: l_orig_req_line NUMBER;
530: l_req_qty NUMBER;
531: l_num_messages NUMBER;
532: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
533: l_req_line_id_col dbms_sql.number_table;
534: lock_not_acquired EXCEPTION;
535: l_user_id NUMBER;
536:
902: l_orig_req_header_insertcol dbms_sql.number_table;
903: l_allocated_qty_insertcol dbms_sql.number_table;
904: l_auction_header_id_insertcol dbms_sql.number_table;
905: l_empty_table dbms_sql.number_table;
906: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
907: l_user_id NUMBER;
908: l_login_id NUMBER;
909: l_bid_price_col dbms_sql.number_table;
910: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
1661: x_line_number NUMBER;
1662: x_award_quantity NUMBER;
1663: x_allocation_quantity NUMBER;
1664: x_requisition_line_id NUMBER;
1665: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1666: x_interface_header_id NUMBER;
1667: x_interface_line_id NUMBER;
1668: x_price NUMBER;
1669: x_quantity NUMBER;
3454: x_language_code VARCHAR2(4);
3455: x_round_number NUMBER;
3456: x_line_number NUMBER;
3457: x_bid_number NUMBER;
3458: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3459: x_po_header_id NUMBER;
3460: x_order_number pon_bid_headers.order_number%TYPE;
3461: x_interface_header_id NUMBER;
3462: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
3870: x_seq_for_item_key varchar2(6) := null;
3871: x_doc_type_to_create varchar2(25);
3872: v_old_policy varchar2(1);
3873: v_old_org_id number;
3874: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3875: x_supplier_notif_method po_vendor_sites_all.supplier_notif_method%TYPE := null;
3876: x_print_flag varchar2(1) := 'N';
3877: x_fax_flag varchar2(1) := 'N';
3878: x_email_flag varchar2(1) := 'N';
4059:
4060:
4061: x_number_of_failed_pos NUMBER;
4062: x_auction_header_id NUMBER;
4063: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4064:
4065: BEGIN
4066: IF (UNCMODE = 'CANCEL') THEN
4067: return;
4147: newline varchar2(256);
4148: beginBold VARCHAR2(10);
4149: endBold VARCHAR2(10);
4150: x_count NUMBER;
4151: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4152: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
4153: x_purchase_orders VARCHAR2(30);
4154: x_contract_type pon_auction_headers_all.contract_type%TYPE;
4155:
4314: newline varchar2(256);
4315: beginBold VARCHAR2(10);
4316: endBold VARCHAR2(10);
4317: x_count NUMBER;
4318: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4319: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
4320: x_purchase_orders VARCHAR2(30);
4321: x_contract_type pon_auction_headers_all.contract_type%TYPE;
4322: x_error_msg pon_bid_headers.po_error_msg%type;
4528: l_debug_enabled VARCHAR2(1) := 'N';
4529: l_exception_enabled VARCHAR2(1) := 'N';
4530: l_progress NUMBER := 0;
4531:
4532: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4533:
4534: -- Business Events Project
4535: x_return_status VARCHAR2(20);
4536: x_msg_count NUMBER;