APPS.PO_PDOI_GRP SQL Statements

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

Line: 108

  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_clm_flag IN VARCHAR2 DEFAULT 'N' --CLM PDOI Project
) IS

d_api_version CONSTANT NUMBER := 1.0;

Line: 169

    p_selected_batch_id => p_selected_batch_id,
    p_batch_size => p_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 => p_org_id,
    p_ga_flag => p_ga_flag,
    p_submit_dft_flag => NULL,
    p_role => PO_GLOBAL.g_ROLE_BUYER,
    p_catalog_to_expire => NULL,
    p_err_lines_tolerance => NULL,
	p_clm_flag => p_clm_flag, --CLM PDOI Project
    x_processed_lines_count => l_processed_lines_count,
    x_rejected_lines_count => l_rejected_lines_count,
    x_err_tolerance_exceeded => l_err_tolerance_exceeded
  );

Line: 334

  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,
  p_clm_flag IN VARCHAR2 DEFAULT 'N' --
) IS

d_api_version CONSTANT NUMBER := 1.0;

Line: 400

    p_selected_batch_id => p_selected_batch_id,
    p_batch_size => p_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 => p_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_clm_flag => p_clm_flag, --CLM PDOI Project
    p_err_lines_tolerance => p_err_lines_tolerance,
    x_processed_lines_count => x_processed_lines_count,
    x_rejected_lines_count => x_rejected_lines_count,
    x_err_tolerance_exceeded => x_err_tolerance_exceeded
  );

Line: 510

  p_selected_batch_id IN NUMBER,
  p_document_type IN VARCHAR2,
  p_document_subtype IN VARCHAR2,
  p_interface_header_id IN NUMBER,
  p_org_id IN NUMBER,
  p_clm_flag IN VARCHAR2 DEFAULT 'N' --
) IS

d_api_version CONSTANT NUMBER := 1.0;

Line: 561

    p_selected_batch_id => p_selected_batch_id,
    p_batch_size => 1,
    p_buyer_id => NULL,
    p_document_type => p_document_type,
    p_document_subtype => p_document_subtype,
    p_create_items => 'N',
    p_create_sourcing_rules_flag => 'N',
    p_rel_gen_method => NULL,
    p_sourcing_level => NULL,
    p_sourcing_inv_org_id => NULL,
    p_approved_status => NULL,
    p_process_code => PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED,
    p_interface_header_id => p_interface_header_id,
    p_org_id => p_org_id,
    p_ga_flag => NULL,
    p_submit_dft_flag => NULL,
    p_role => PO_GLOBAL.g_ROLE_BUYER,
    p_catalog_to_expire => NULL,
	p_clm_flag => p_clm_flag, --CLM PDOI Project
    p_err_lines_tolerance => NULL,
    x_processed_lines_count => l_processed_lines_count,
    x_rejected_lines_count => l_rejected_lines_count,
    x_err_tolerance_exceeded => l_err_tolerance_exceeded
  );