APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_LOOKUP_CODES

Line 327: C_Description ap_lookup_codes.description%TYPE;

323: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
324: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
325: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
326: C_Price NUMBER;
327: C_Description ap_lookup_codes.description%TYPE;
328: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
329: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
330: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
331: C_dist_tab AP_MATCHING_PKG.dist_tab_type;

Line 906: -- from ap_lookup_codes to enable translation Problem

902: END IF;
903:
904: -------------------------------------------------------------
905: -- Retreive description 'Created by Recurring Invoice'
906: -- from ap_lookup_codes to enable translation Problem
907: --------------------------------------------------------------
908: debug_info := 'get new description';
909: Begin
910: SELECT description INTO P_Description

Line 911: FROM ap_lookup_codes

907: --------------------------------------------------------------
908: debug_info := 'get new description';
909: Begin
910: SELECT description INTO P_Description
911: FROM ap_lookup_codes
912: WHERE lookup_type = 'SOURCE' and
913: lookup_code = 'RECURRING INVOICE';
914: EXCEPTION
915: WHEN NO_DATA_FOUND Then

Line 1227: C_source ap_lookup_codes.displayed_field%TYPE;

1223:
1224: C_invoice_id NUMBER;
1225: debug_info VARCHAR2(100);
1226: current_calling_sequence VARCHAR2(2000);
1227: C_source ap_lookup_codes.displayed_field%TYPE;
1228: l_ready_for_wf VARCHAR2(1);
1229: l_use_workflow_flag VARCHAR2(1);
1230: l_wfapproval_status VARCHAR2(50);
1231: l_approval_required_flag VARCHAR2(1);