APPS.PO_WIP_INTEGRATION_GRP SQL Statements

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

Line: 21

PROCEDURE update_document (
  p_api_version            IN NUMBER,
  p_init_msg_list          IN VARCHAR2,
  x_return_status          OUT NOCOPY VARCHAR2,
  p_changes                IN OUT NOCOPY PO_CHANGES_REC_TYPE,
  p_run_submission_checks  IN VARCHAR2,
  p_launch_approvals_flag  IN VARCHAR2,
  p_buyer_id               IN NUMBER,
  p_update_source          IN VARCHAR2,
  p_override_date          IN DATE,
  x_api_errors             OUT NOCOPY PO_API_ERRORS_REC_TYPE
) IS
  l_api_name     CONSTANT VARCHAR(30) := 'UPDATE_DOCUMENT';

Line: 47

  PO_DOCUMENT_UPDATE_GRP.update_document(
    p_api_version => 1.0,
    p_init_msg_list => p_init_msg_list,
    x_return_status => x_return_status,
    p_changes => p_changes,
    p_run_submission_checks => p_run_submission_checks,
    p_launch_approvals_flag => p_launch_approvals_flag,
    p_buyer_id => p_buyer_id,
    p_update_source => p_update_source,
    p_override_date => p_override_date,
    x_api_errors => x_api_errors
  );

Line: 62

    PO_DOCUMENT_UPDATE_PVT.add_message_list_errors (
      p_api_errors => x_api_errors,
      x_return_status => x_return_status
    );

Line: 72

    PO_DOCUMENT_UPDATE_PVT.add_message_list_errors (
      p_api_errors => x_api_errors,
      x_return_status => x_return_status
    );

Line: 77

END update_document;

Line: 179

PROCEDURE update_requisition (
    p_api_version            IN NUMBER,
    p_req_changes            IN OUT NOCOPY PO_REQ_CHANGES_REC_TYPE,
    p_update_source          IN VARCHAR2,
    x_return_status          OUT NOCOPY VARCHAR2,
    x_msg_count              OUT NOCOPY NUMBER,
    x_msg_data               OUT NOCOPY VARCHAR2
) IS

BEGIN

--Call the group procedure to update requisition
PO_REQ_DOCUMENT_UPDATE_GRP.update_requisition(
    p_api_version => p_api_version,
    p_req_changes => p_req_changes,
    p_update_source => p_update_source,
    x_return_status  => x_return_status,
    x_msg_count  => x_msg_count,
    x_msg_data  => x_msg_data);

Line: 199

END update_requisition;