3478: l_return_status VARCHAR2(1);
3479: l_msg_count NUMBER;
3480: l_msg_data VARCHAR2(2000);
3481: l_tax_status VARCHAR2(1);
3482: l_tax_message fnd_new_messages.message_text%TYPE;
3483: --
3484:
3485: l_clm_req VARCHAR2(1); -- Bug 9667820
3486:
4082: l_return_status VARCHAR2(1);
4083: l_tax_status VARCHAR2(1);
4084: l_msg_count NUMBER;
4085: l_msg_data VARCHAR2(2000);
4086: l_tax_message fnd_new_messages.message_text%TYPE;
4087: --
4088:
4089: --bug#3987438
4090: --A new table to hold the invalid ship to location codes
5952: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;
5953: l_requesting_org_id NumTab;
5954: l_display_rate NUMBER;
5955: l_return_status VARCHAR2(1);
5956: l_error_message_name FND_NEW_MESSAGES.message_name%TYPE;
5957: l_req_line_price_pou_base_curr PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5958: l_req_line_price_ext_precn PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5959: --
5960:
8208: l_textline po_online_report_text.text_line%TYPE := NULL;
8209: l_api_name CONSTANT varchar2(40) := 'CHECK_PO';
8210: l_progress VARCHAR2(3);
8211: l_is_complex_po boolean;
8212: l_line_loc_token_value fnd_new_messages.message_text%TYPE;
8213: TYPE NumTab is TABLE of NUMBER INDEX by BINARY_INTEGER;
8214: l_quantity1 NumTab;
8215: l_quantity2 NumTab;
8216: l_line_num NumTab;
8236: l_return_status VARCHAR2(1);
8237: l_tax_status VARCHAR2(1);
8238: l_msg_count NUMBER;
8239: l_msg_data VARCHAR2(2000);
8240: l_tax_message fnd_new_messages.message_text%TYPE;
8241: --
8242:
8243: l_po_vmi_display_warning VARCHAR2(1);
8244: -- CLM Aprvl
21352: )
21353: IS
21354:
21355: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
21356: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
21357: l_calling_sequence VARCHAR2(100);
21358: l_invoice_type VARCHAR2(100) := 'BOTH';
21359: l_is_complex_po boolean;
21360: l_token_value VARCHAR2(256);
21614: x_calling_sequence OUT NOCOPY VARCHAR2,
21615: x_return_status OUT NOCOPY VARCHAR2) IS
21616:
21617: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
21618: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
21619: l_calling_sequence VARCHAR2(100);
21620: l_invoice_type VARCHAR2(100) := 'BOTH';
21621: l_is_complex_po boolean := false;
21622: l_document_id NUMBER;