APPS.PO_PDOI_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

  p_selected_batch_id IN NUMBER,
  p_batch_size IN NUMBER,
  p_buyer_id IN NUMBER,
  p_document_type IN VARCHAR2,
  p_document_subtype IN VARCHAR2,
  p_create_items IN VARCHAR2,
  p_create_sourcing_rules_flag IN VARCHAR2,
  p_rel_gen_method IN VARCHAR2,
  p_sourcing_level IN VARCHAR2,
  p_sourcing_inv_org_id IN NUMBER,
  p_approved_status IN VARCHAR2,
  p_process_code IN VARCHAR2,
  p_interface_header_id IN NUMBER,
  p_org_id IN NUMBER,
  p_ga_flag IN VARCHAR2,
  p_submit_dft_flag IN VARCHAR2,
  p_role IN VARCHAR2,
  p_catalog_to_expire IN VARCHAR2,
  p_err_lines_tolerance IN NUMBER
);

Line: 185

  p_selected_batch_id IN NUMBER,
  p_batch_size IN NUMBER,
  p_buyer_id IN NUMBER,
  p_document_type IN VARCHAR2,
  p_document_subtype IN VARCHAR2,
  p_create_items IN VARCHAR2,
  p_create_sourcing_rules_flag IN VARCHAR2,
  p_rel_gen_method IN VARCHAR2,
  p_sourcing_level IN VARCHAR2,
  p_sourcing_inv_org_id IN NUMBER,
  p_approved_status IN VARCHAR2,
  p_process_code IN VARCHAR2,
  p_interface_header_id IN NUMBER,
  p_org_id IN NUMBER,
  p_ga_flag IN VARCHAR2,
  p_submit_dft_flag IN VARCHAR2,
  p_role IN VARCHAR2,
  p_catalog_to_expire IN VARCHAR2,
  p_err_lines_tolerance IN NUMBER,
  x_processed_lines_count OUT NOCOPY NUMBER,
  x_rejected_lines_count OUT NOCOPY NUMBER,
  x_err_tolerance_exceeded OUT NOCOPY VARCHAR2
) IS

d_api_version CONSTANT NUMBER := 1.0;

Line: 231

    PO_LOG.proc_begin (d_module, 'p_selected_batch_id', p_selected_batch_id);

Line: 293

    p_selected_batch_id          => p_selected_batch_id,
    p_batch_size                 => NVL(p_batch_size, PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE),
    p_buyer_id                   => p_buyer_id,
    p_document_type              => p_document_type,
    p_document_subtype           => p_document_subtype,
    p_create_items               => p_create_items,
    p_create_sourcing_rules_flag => p_create_sourcing_rules_flag,
    p_rel_gen_method             => p_rel_gen_method,
    p_sourcing_level             => p_sourcing_level,
    p_sourcing_inv_org_id        => p_sourcing_inv_org_id,
    p_approved_status            => p_approved_status,
    p_process_code               => p_process_code,
    p_interface_header_id        => p_interface_header_id,
    p_org_id                     => l_org_id,
    p_ga_flag                    => p_ga_flag,
    p_submit_dft_flag            => p_submit_dft_flag,
    p_role                       => p_role,
    p_catalog_to_expire          => p_catalog_to_expire,
    p_err_lines_tolerance        => p_err_lines_tolerance
  );

Line: 456

  p_selected_batch_id IN NUMBER,
  p_batch_size IN NUMBER,
  p_buyer_id IN NUMBER,
  p_document_type IN VARCHAR2,
  p_document_subtype IN VARCHAR2,
  p_create_items IN VARCHAR2,
  p_create_sourcing_rules_flag IN VARCHAR2,
  p_rel_gen_method IN VARCHAR2,
  p_sourcing_level IN VARCHAR2,
  p_sourcing_inv_org_id IN NUMBER,
  p_approved_status IN VARCHAR2,
  p_process_code IN VARCHAR2,
  p_interface_header_id IN NUMBER,
  p_org_id IN NUMBER,
  p_ga_flag IN VARCHAR2,
  p_submit_dft_flag IN VARCHAR2,
  p_role IN VARCHAR2,
  p_catalog_to_expire IN VARCHAR2,
  p_err_lines_tolerance IN NUMBER
) IS

d_api_name CONSTANT VARCHAR2(30) := 'init_startup_values';

Line: 493

  PO_PDOI_PARAMS.g_request.batch_id            := p_selected_batch_id;

Line: 528

  SELECT PO_PDOI_PROCESSING_ID_S.nextval
  INTO PO_PDOI_PARAMS.g_processing_id
  FROM DUAL;

Line: 673

  SELECT price_break_lookup_code,
         supplier_authoring_acceptance,
         cat_admin_authoring_acceptance
  INTO PO_PDOI_PARAMS.g_sys.price_break_lookup_code,
       PO_PDOI_PARAMS.g_sys.supplier_auth_acc,
       PO_PDOI_PARAMS.g_sys.cat_admin_auth_acc
  FROM po_system_parameters;

Line: 682

  SELECT match_option,
         business_group_id
  INTO   PO_PDOI_PARAMS.g_sys.invoice_match_option,
         PO_PDOI_PARAMS.g_sys.def_business_group_id
  FROM   financials_system_parameters;

Line: 689

  SELECT master_organization_id
  INTO PO_PDOI_PARAMS.g_sys.master_inv_org_id
  FROM mtl_parameters
  WHERE organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

Line: 726

  SELECT MCSB.structure_id,
         MCSB.category_set_id,
         MCSB.default_category_id
  INTO   PO_PDOI_PARAMS.g_sys.def_structure_id,
         PO_PDOI_PARAMS.g_sys.def_cat_set_id,
         PO_PDOI_PARAMS.g_sys.def_category_id
  FROM   MTL_DEFAULT_CATEGORY_SETS MDCS,
         MTL_CATEGORY_SETS_B MCSB
  WHERE  MDCS.functional_area_id = 2
  AND    MDCS.category_set_id = MCSB.category_set_id;

Line: 847

  PO_PDOI_PARAMS.g_profile.po_price_update_tolerance :=
    FND_PROFILE.value('PO_PRICE_UPDATE_TOLERANCE');

Line: 865

    PO_LOG.stmt (d_module, d_position, 'po_price_update_tolerance', PO_PDOI_PARAMS.g_profile.po_price_update_tolerance);

Line: 995

  SELECT archive_external_revision_code
  INTO   x_when_to_archive
  FROM   po_document_types
  WHERE  document_type_code = p_document_type
  AND    document_subtype = p_document_subtype;

Line: 1153

  UPDATE po_drafts DFT
  SET    DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
  WHERE  DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING
  AND    DFT.draft_id IN
           (SELECT PHI.draft_id
            FROM   po_headers_interface PHI
            WHERE  PHI.processing_id IN (PO_PDOI_PARAMS.g_processing_id,
                                         -PO_PDOI_PARAMS.g_processing_id)
            AND    PHI.processing_round_num=PO_PDOI_PARAMS.g_current_round_num);