DBA Data[Home] [Help]

APPS.PO_COPYDOC_S1 dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 3804: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;

3800: IS
3801: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
3802: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
3803: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
3804: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
3805: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
3806: l_return_code NUMBER;
3807: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
3808: d_pos NUMBER;

Line 3805: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;

3801: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
3802: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
3803: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
3804: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
3805: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
3806: l_return_code NUMBER;
3807: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
3808: d_pos NUMBER;
3809: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.VAL_PARAMS_AND_DUPLICATE_DOC';

Line 3837: FROM po_headers_all POH, financials_system_params_all FSP

3833: FSP.SET_OF_BOOKS_ID
3834: INTO l_doc_org_id, l_type_lookup_code,
3835: l_global_agreement_flag,
3836: l_inv_org_id, l_sob_id
3837: FROM po_headers_all POH, financials_system_params_all FSP
3838: WHERE po_header_id = p_po_header_id
3839: AND poh.org_id = fsp.org_id;
3840:
3841: IF PO_LOG.d_stmt THEN