APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_LOOKUP_CODES

Line 333: C_Description ap_lookup_codes.description%TYPE;

329: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
330: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
331: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
332: C_Price NUMBER;
333: C_Description ap_lookup_codes.description%TYPE;
334: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
335: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
336: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
337: C_dist_tab AP_MATCHING_PKG.dist_tab_type;

Line 930: -- from ap_lookup_codes to enable translation Problem

926: END IF;
927:
928: -------------------------------------------------------------
929: -- Retreive description 'Created by Recurring Invoice'
930: -- from ap_lookup_codes to enable translation Problem
931: --------------------------------------------------------------
932: debug_info := 'get new description';
933: Begin
934: SELECT description INTO P_Description

Line 935: FROM ap_lookup_codes

931: --------------------------------------------------------------
932: debug_info := 'get new description';
933: Begin
934: SELECT description INTO P_Description
935: FROM ap_lookup_codes
936: WHERE lookup_type = 'SOURCE' and
937: lookup_code = 'RECURRING INVOICE';
938: EXCEPTION
939: WHEN NO_DATA_FOUND Then

Line 1251: C_source ap_lookup_codes.displayed_field%TYPE;

1247:
1248: C_invoice_id NUMBER;
1249: debug_info VARCHAR2(100);
1250: current_calling_sequence VARCHAR2(2000);
1251: C_source ap_lookup_codes.displayed_field%TYPE;
1252: l_ready_for_wf VARCHAR2(1);
1253: l_use_workflow_flag VARCHAR2(1);
1254: l_wfapproval_status VARCHAR2(50);
1255: l_approval_required_flag VARCHAR2(1);