DBA Data[Home] [Help]

APPS.PO_COPYDOC_S1 dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 4436: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;

4432: IS
4433: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
4434: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
4435: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
4436: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
4437: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
4438: l_return_code NUMBER;
4439: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
4440: d_pos NUMBER;

Line 4437: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;

4433: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
4434: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
4435: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
4436: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
4437: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
4438: l_return_code NUMBER;
4439: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
4440: d_pos NUMBER;
4441: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.VAL_PARAMS_AND_DUPLICATE_DOC';

Line 4469: FROM po_headers_all POH, financials_system_params_all FSP

4465: FSP.SET_OF_BOOKS_ID
4466: INTO l_doc_org_id, l_type_lookup_code,
4467: l_global_agreement_flag,
4468: l_inv_org_id, l_sob_id
4469: FROM po_headers_all POH, financials_system_params_all FSP
4470: WHERE po_header_id = p_po_header_id
4471: AND poh.org_id = fsp.org_id;
4472:
4473: IF PO_LOG.d_stmt THEN