APPS.ASO_IBY_FINANCE_CALLBACK SQL Statements

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

Line: 14

  PROCEDURE update_status (
    p_api_version               IN       NUMBER,
    p_init_msg_list             IN       VARCHAR2 := fnd_api.g_false,
    p_commit                    IN       VARCHAR2 := fnd_api.g_false,
    p_validation_level          IN       NUMBER   := fnd_api.g_miss_num,
    p_tangible_id               IN       NUMBER,
    p_credit_app_id             IN       NUMBER,
    p_new_status_category       IN       VARCHAR2,
    p_new_status                IN       VARCHAR2,
    p_last_update_date          IN       DATE     := fnd_api.g_miss_date,
    x_return_status             OUT NOCOPY /* file.sql.39 change */       VARCHAR2,
    x_msg_count                 OUT NOCOPY /* file.sql.39 change */       NUMBER,
    x_msg_data                  OUT NOCOPY /* file.sql.39 change */       VARCHAR2
  ) IS
    l_api_version                 NUMBER := 1.0;

Line: 29

    l_api_name                    VARCHAR2 (50) := 'Update_Status';

Line: 32

    SAVEPOINT update_status_pub;

Line: 62

    aso_iby_financing_pvt.update_status (
      p_api_version                => p_api_version,
      p_init_msg_list              => p_init_msg_list,
      p_commit                     => p_commit,
      p_validation_level           => p_validation_level,
      p_tangible_id                => p_tangible_id,
      p_credit_app_id              => p_credit_app_id,
      p_new_status_category        => p_new_status_category,
      p_new_status                 => p_new_status,
      p_last_update_date           => p_last_update_date,
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data
    );

Line: 78

        'Update_Status: after Update_Status return_status: '|| x_return_status,
        1,
        'Y'
      );

Line: 148

  END update_status;