DBA Data[Home] [Help]

APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 329: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

325: C_Distribution_Set_ID NUMBER;
326: C_quantity_outstanding NUMBER;
327: C_overbilled VARCHAR2(1);
328: C_Quantity NUMBER;
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;

Line 330: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;

326: C_quantity_outstanding NUMBER;
327: C_overbilled VARCHAR2(1);
328: C_Quantity NUMBER;
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;

Line 834: ap_system_parameters sp,

830: P_approval_workflow_flag,
831: P_inventory_org_id,
832: P_ship_to_location_id
833: FROM po_vendors v,
834: ap_system_parameters sp,
835: po_vendor_sites vs,
836: financials_system_parameters fsp
837: WHERE v.vendor_id = P_vendor_id
838: AND vs.org_id = sp.org_id

Line 1281: FROM ap_system_parameters;

1277: debug_info := 'Get WF Approval option';
1278: BEGIN
1279: SELECT approval_workflow_flag
1280: INTO l_use_workflow_flag
1281: FROM ap_system_parameters;
1282:
1283: SELECT approval_required_flag
1284: INTO l_approval_required_flag
1285: FROM ap_recurring_payments_all